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

Total elapsed time: 1.1634149551392

# Query Time
(1) connect 0.00095009803771973
(2) DESCRIBE `cruises` 0.0040349960327148
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (72916, 69155, 69189, 69187, 72827, 69120, 72919, 72834, 61525, 72843)) ORDER BY FIND_IN_SET(id, '72916,69155,69189,69187,72827,69120,72919,72834,61525,72843') 0.0031049251556396
(4) DESCRIBE `cruises` 0.0039100646972656
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72916') 0.00043392181396484
(6) DESCRIBE `ships` 0.0039529800415039
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 966))) 0.00044488906860352
(8) DESCRIBE `ships` 0.0038950443267822
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '966') 0.00049519538879395
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034594535827637
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00033283233642578
(12) DESCRIBE `itineraries` 0.0024878978729248
(13) DESCRIBE `ports` 0.0016109943389893
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00032997131347656
(15) DESCRIBE `ports` 0.0020120143890381
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00053906440734863
(17) DESCRIBE `ports` 0.0022351741790771
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00041103363037109
(19) DESCRIBE `sailingdates` 0.0017368793487549
(20) DESCRIBE `ports` 0.0020468235015869
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00041699409484863
(22) DESCRIBE `ports` 0.0018620491027832
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00035977363586426
(24) DESCRIBE `ports` 0.002173900604248
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.00043082237243652
(26) DESCRIBE `ports` 0.0021951198577881
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00034189224243164
(28) DESCRIBE `ports` 0.0016250610351562
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00044703483581543
(30) DESCRIBE `ports` 0.0013689994812012
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.0003349781036377
(32) DESCRIBE `ports` 0.0018579959869385
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00042200088500977
(34) DESCRIBE `ports` 0.00223708152771
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00042891502380371
(36) DESCRIBE `ports` 0.0018501281738281
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3014))) 0.00040817260742188
(38) DESCRIBE `ports` 0.0017759799957275
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3014') 0.00046086311340332
(40) DESCRIBE `ports` 0.0024580955505371
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 210))) 0.0004580020904541
(42) DESCRIBE `ports` 0.00189208984375
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '210') 0.00043106079101562
(44) DESCRIBE `ports` 0.0018160343170166
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00051093101501465
(46) DESCRIBE `ports` 0.0017578601837158
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00040888786315918
(48) DESCRIBE `ports` 0.0022039413452148
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00043821334838867
(50) DESCRIBE `ports` 0.002155065536499
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.0003349781036377
(52) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '72916') AND (sailingdate >= '2019-03-19') 0.015192985534668
(53) DESCRIBE `avid_specials` 0.0016839504241943
(54) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72916 and class = 'Cruise') OR (item_id = 966 AND class = 'Ship') OR (item_id = 91 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.0017719268798828
(55) DESCRIBE `cruiselines` 0.0027561187744141
(56) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.0003359317779541
(57) DESCRIBE `orchid_image` 0.0020089149475098
(58) DESCRIBE `cruiselines` 0.0028700828552246
(59) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00037002563476562
(60) DESCRIBE `cruises` 0.0035359859466553
(61) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69155') 0.00039386749267578
(62) DESCRIBE `ships` 0.0031468868255615
(63) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 508))) 0.00048208236694336
(64) DESCRIBE `ships` 0.0043010711669922
(65) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '508') 0.00052094459533691
(66) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00037598609924316
(67) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035214424133301
(68) DESCRIBE `itineraries` 0.0020461082458496
(69) DESCRIBE `ports` 0.0017318725585938
(70) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00040006637573242
(71) DESCRIBE `ports` 0.0015060901641846
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00029206275939941
(73) DESCRIBE `ports` 0.0014290809631348
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00037598609924316
(75) DESCRIBE `sailingdates` 0.0014100074768066
(76) DESCRIBE `ports` 0.0018768310546875
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00046801567077637
(78) DESCRIBE `ports` 0.0018439292907715
(79) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00044584274291992
(80) DESCRIBE `ports` 0.0014750957489014
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00046300888061523
(82) DESCRIBE `ports` 0.0024139881134033
(83) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00049901008605957
(84) DESCRIBE `ports` 0.0017480850219727
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 427))) 0.00034403800964355
(86) DESCRIBE `ports` 0.0013949871063232
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '427') 0.00040316581726074
(88) DESCRIBE `ports` 0.0018539428710938
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 609))) 0.00044083595275879
(90) DESCRIBE `ports` 0.0017631053924561
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '609') 0.00038814544677734
(92) DESCRIBE `ports` 0.0016350746154785
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 428))) 0.00037503242492676
(94) DESCRIBE `ports` 0.0016391277313232
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '428') 0.00037193298339844
(96) DESCRIBE `ports` 0.0022549629211426
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 429))) 0.00037097930908203
(98) DESCRIBE `ports` 0.0014948844909668
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '429') 0.00038814544677734
(100) DESCRIBE `ports` 0.0017869472503662
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 712))) 0.00042200088500977
(102) DESCRIBE `ports` 0.0019500255584717
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '712') 0.00039410591125488
(104) DESCRIBE `ports` 0.0015170574188232
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 205))) 0.00034713745117188
(106) DESCRIBE `ports` 0.0018410682678223
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '205') 0.00036120414733887
(108) DESCRIBE `ports` 0.0020241737365723
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 205))) 0.00022292137145996
(110) DESCRIBE `ports` 0.0016129016876221
(111) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '205') 0.00016403198242188
(112) DESCRIBE `ports` 0.0019500255584717
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 533))) 0.00026416778564453
(114) DESCRIBE `ports` 0.0015730857849121
(115) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '533') 0.0002591609954834
(116) DESCRIBE `ports` 0.0025770664215088
(117) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 198))) 0.00039386749267578
(118) DESCRIBE `ports` 0.0015828609466553
(119) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '198') 0.00029683113098145
(120) DESCRIBE `ports` 0.0016241073608398
(121) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.0003809928894043
(122) DESCRIBE `ports` 0.00130295753479
(123) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00031900405883789
(124) DESCRIBE `ports` 0.0025010108947754
(125) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1623))) 0.00041985511779785
(126) DESCRIBE `ports` 0.0018479824066162
(127) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1623') 0.00037598609924316
(128) DESCRIBE `ports` 0.0018470287322998
(129) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00043392181396484
(130) DESCRIBE `ports` 0.0023291110992432
(131) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00042915344238281
(132) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69155') AND (sailingdate >= '2019-03-19') 0.0086278915405273
(133) DESCRIBE `avid_specials` 0.0019040107727051
(134) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69155 and class = 'Cruise') OR (item_id = 508 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 45 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0016829967498779
(135) DESCRIBE `cruiselines` 0.01373815536499
(136) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00047898292541504
(137) DESCRIBE `orchid_image` 0.0018830299377441
(138) DESCRIBE `cruiselines` 0.0031650066375732
(139) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00048995018005371
(140) DESCRIBE `cruises` 0.0040500164031982
(141) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69189') 0.00056314468383789
(142) DESCRIBE `ships` 0.0037529468536377
(143) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 394))) 0.00064587593078613
(144) DESCRIBE `ships` 0.0036749839782715
(145) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '394') 0.00042605400085449
(146) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00033903121948242
(147) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0002589225769043
(148) DESCRIBE `itineraries` 0.0016138553619385
(149) DESCRIBE `ports` 0.0015609264373779
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00037813186645508
(151) DESCRIBE `ports` 0.0013120174407959
(152) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00034117698669434
(153) DESCRIBE `ports` 0.0018129348754883
(154) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00040698051452637
(155) DESCRIBE `sailingdates` 0.0018558502197266
(156) DESCRIBE `ports` 0.0016250610351562
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00040388107299805
(158) DESCRIBE `ports` 0.0016238689422607
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00036907196044922
(160) DESCRIBE `ports` 0.0014500617980957
(161) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00062704086303711
(162) DESCRIBE `ports` 0.013060092926025
(163) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00044012069702148
(164) DESCRIBE `ports` 0.0013699531555176
(165) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2139))) 0.00034713745117188
(166) DESCRIBE `ports` 0.001288890838623
(167) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2139') 0.00039196014404297
(168) DESCRIBE `ports` 0.0014739036560059
(169) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 165))) 0.0061559677124023
(170) DESCRIBE `ports` 0.0017721652984619
(171) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '165') 0.0004429817199707
(172) DESCRIBE `ports` 0.0017189979553223
(173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 169))) 0.00041484832763672
(174) DESCRIBE `ports` 0.0022180080413818
(175) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '169') 0.0025210380554199
(176) DESCRIBE `ports` 0.013854026794434
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 615))) 0.00054216384887695
(178) DESCRIBE `ports` 0.0022308826446533
(179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '615') 0.00051593780517578
(180) DESCRIBE `ports` 0.0017421245574951
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 357))) 0.00039982795715332
(182) DESCRIBE `ports` 0.001849889755249
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '357') 0.00035285949707031
(184) DESCRIBE `ports` 0.0016360282897949
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2131))) 0.00039815902709961
(186) DESCRIBE `ports` 0.0013740062713623
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2131') 0.00027990341186523
(188) DESCRIBE `ports` 0.0013699531555176
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2148))) 0.0004270076751709
(190) DESCRIBE `ports` 0.0015659332275391
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2148') 0.00038599967956543
(192) DESCRIBE `ports` 0.0016839504241943
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.00038695335388184
(194) DESCRIBE `ports` 0.0018010139465332
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.00037002563476562
(196) DESCRIBE `ports` 0.0014901161193848
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 143))) 0.00031399726867676
(198) DESCRIBE `ports` 0.0012950897216797
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '143') 0.00030303001403809
(200) DESCRIBE `ports` 0.001924991607666
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00041604042053223
(202) DESCRIBE `ports` 0.0016400814056396
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.0002892017364502
(204) DESCRIBE `ports` 0.0017809867858887
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1229))) 0.0004580020904541
(206) DESCRIBE `ports` 0.0014441013336182
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1229') 0.00036215782165527
(208) DESCRIBE `ports` 0.0017068386077881
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 29))) 0.00045299530029297
(210) DESCRIBE `ports` 0.002593994140625
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '29') 0.00037407875061035
(212) DESCRIBE `ports` 0.0014128684997559
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 295))) 0.00022411346435547
(214) DESCRIBE `ports` 0.0017359256744385
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '295') 0.00028395652770996
(216) DESCRIBE `ports` 0.0013401508331299
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00028395652770996
(218) DESCRIBE `ports` 0.00148606300354
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00034904479980469
(220) DESCRIBE `ports` 0.0014479160308838
(221) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 34))) 0.00033402442932129
(222) DESCRIBE `ports` 0.0013840198516846
(223) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '34') 0.00030088424682617
(224) DESCRIBE `ports` 0.0014309883117676
(225) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00031280517578125
(226) DESCRIBE `ports` 0.0017859935760498
(227) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00039887428283691
(228) DESCRIBE `ports` 0.0017738342285156
(229) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00042390823364258
(230) DESCRIBE `ports` 0.0023219585418701
(231) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00040197372436523
(232) DESCRIBE `ports` 0.0018129348754883
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00041604042053223
(234) DESCRIBE `ports` 0.0016701221466064
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.0003821849822998
(236) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69189') AND (sailingdate >= '2019-03-19') 0.0057318210601807
(237) DESCRIBE `avid_specials` 0.0014290809631348
(238) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69189 and class = 'Cruise') OR (item_id = 394 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 48 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.0011088848114014
(239) DESCRIBE `cruiselines` 0.0021069049835205
(240) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00052499771118164
(241) DESCRIBE `orchid_image` 0.0017580986022949
(242) DESCRIBE `cruiselines` 0.0018699169158936
(243) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00034904479980469
(244) DESCRIBE `cruises` 0.0035278797149658
(245) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69187') 0.00058388710021973
(246) DESCRIBE `ships` 0.0029599666595459
(247) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 394))) 0.00033092498779297
(248) DESCRIBE `ships` 0.0026791095733643
(249) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '394') 0.00032210350036621
(250) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026798248291016
(251) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034809112548828
(252) DESCRIBE `itineraries` 0.0011918544769287
(253) DESCRIBE `ports` 0.0013978481292725
(254) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0004420280456543
(255) DESCRIBE `ports` 0.0015730857849121
(256) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00031900405883789
(257) DESCRIBE `ports` 0.0012109279632568
(258) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00029492378234863
(259) DESCRIBE `sailingdates` 0.0011711120605469
(260) DESCRIBE `ports` 0.0015029907226562
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00035214424133301
(262) DESCRIBE `ports` 0.0014579296112061
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00029301643371582
(264) DESCRIBE `ports` 0.0014040470123291
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00030612945556641
(266) DESCRIBE `ports` 0.0012860298156738
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00029587745666504
(268) DESCRIBE `ports` 0.0012519359588623
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2139))) 0.00034594535827637
(270) DESCRIBE `ports` 0.001317024230957
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2139') 0.00030994415283203
(272) DESCRIBE `ports` 0.0012872219085693
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 165))) 0.00027585029602051
(274) DESCRIBE `ports` 0.0014429092407227
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '165') 0.00026607513427734
(276) DESCRIBE `ports` 0.0013399124145508
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 169))) 0.00032591819763184
(278) DESCRIBE `ports` 0.0012578964233398
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '169') 0.00027203559875488
(280) DESCRIBE `ports` 0.001248836517334
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 615))) 0.00029087066650391
(282) DESCRIBE `ports` 0.0013470649719238
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '615') 0.00027298927307129
(284) DESCRIBE `ports` 0.0014510154724121
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 357))) 0.00031280517578125
(286) DESCRIBE `ports` 0.0016641616821289
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '357') 0.00034999847412109
(288) DESCRIBE `ports` 0.0013468265533447
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2131))) 0.00034403800964355
(290) DESCRIBE `ports` 0.0015921592712402
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2131') 0.0003819465637207
(292) DESCRIBE `ports` 0.0014069080352783
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2148))) 0.00036883354187012
(294) DESCRIBE `ports` 0.0017390251159668
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2148') 0.00042200088500977
(296) DESCRIBE `ports` 0.0018618106842041
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.0003960132598877
(298) DESCRIBE `ports` 0.0018448829650879
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.00056600570678711
(300) DESCRIBE `ports` 0.0015509128570557
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 143))) 0.00038719177246094
(302) DESCRIBE `ports` 0.001399040222168
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '143') 0.00028109550476074
(304) DESCRIBE `ports` 0.001291036605835
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00032496452331543
(306) DESCRIBE `ports` 0.0012590885162354
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00027799606323242
(308) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69187') AND (sailingdate >= '2019-03-19') 0.009329080581665
(309) DESCRIBE `avid_specials` 0.0018508434295654
(310) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69187 and class = 'Cruise') OR (item_id = 394 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 48 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.0016369819641113
(311) DESCRIBE `cruiselines` 0.0025742053985596
(312) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.0006861686706543
(313) DESCRIBE `orchid_image` 0.0020699501037598
(314) DESCRIBE `cruiselines` 0.0025501251220703
(315) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00040698051452637
(316) DESCRIBE `cruises` 0.0035600662231445
(317) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72827') 0.00047612190246582
(318) DESCRIBE `ships` 0.0039889812469482
(319) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 850))) 0.00038599967956543
(320) DESCRIBE `ships` 0.003896951675415
(321) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '850') 0.0003509521484375
(322) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026988983154297
(323) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00029492378234863
(324) DESCRIBE `itineraries` 0.0014231204986572
(325) DESCRIBE `ports` 0.0014879703521729
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00034594535827637
(327) DESCRIBE `ports` 0.0014169216156006
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00036096572875977
(329) DESCRIBE `ports` 0.0013930797576904
(330) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00037384033203125
(331) DESCRIBE `sailingdates` 0.0013878345489502
(332) DESCRIBE `ports` 0.0014300346374512
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00045394897460938
(334) DESCRIBE `ports` 0.0013930797576904
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00032496452331543
(336) DESCRIBE `ports` 0.0016400814056396
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00041699409484863
(338) DESCRIBE `ports` 0.0015289783477783
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00037002563476562
(340) DESCRIBE `ports` 0.0016248226165771
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.0003199577331543
(342) DESCRIBE `ports` 0.0017471313476562
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00029611587524414
(344) DESCRIBE `ports` 0.0013329982757568
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00035214424133301
(346) DESCRIBE `ports` 0.0014679431915283
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00037384033203125
(348) DESCRIBE `ports` 0.0014541149139404
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1117))) 0.00034189224243164
(350) DESCRIBE `ports` 0.0013439655303955
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1117') 0.00031208992004395
(352) DESCRIBE `ports` 0.0013148784637451
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 275))) 0.0003349781036377
(354) DESCRIBE `ports` 0.0015630722045898
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '275') 0.00028204917907715
(356) DESCRIBE `ports` 0.0013527870178223
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00056815147399902
(358) DESCRIBE `ports` 0.0017099380493164
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00036883354187012
(360) DESCRIBE `ports` 0.00148606300354
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00032305717468262
(362) DESCRIBE `ports` 0.0014300346374512
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.0004119873046875
(364) DESCRIBE `ports` 0.0015149116516113
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3014))) 0.00034809112548828
(366) DESCRIBE `ports` 0.0016398429870605
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3014') 0.00035595893859863
(368) DESCRIBE `ports` 0.001317024230957
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2264))) 0.00033402442932129
(370) DESCRIBE `ports` 0.0015580654144287
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2264') 0.00031685829162598
(372) DESCRIBE `ports` 0.0015060901641846
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 210))) 0.00032496452331543
(374) DESCRIBE `ports` 0.0013689994812012
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '210') 0.00028491020202637
(376) DESCRIBE `ports` 0.0013620853424072
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.0003209114074707
(378) DESCRIBE `ports` 0.0013010501861572
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00058603286743164
(380) DESCRIBE `ports` 0.0013129711151123
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00028419494628906
(382) DESCRIBE `ports` 0.0015511512756348
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00033307075500488
(384) DESCRIBE `ports` 0.0016500949859619
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 756))) 0.00045895576477051
(386) DESCRIBE `ports` 0.0017800331115723
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '756') 0.0003819465637207
(388) DESCRIBE `ports` 0.0017399787902832
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1252))) 0.00039196014404297
(390) DESCRIBE `ports` 0.0014851093292236
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1252') 0.00028300285339355
(392) DESCRIBE `ports` 0.001600980758667
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2062))) 0.00030517578125
(394) DESCRIBE `ports` 0.0012760162353516
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2062') 0.0002138614654541
(396) DESCRIBE `ports` 0.0015711784362793
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00038790702819824
(398) DESCRIBE `ports` 0.0012691020965576
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00034284591674805
(400) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '72827') AND (sailingdate >= '2019-03-19') 0.0069060325622559
(401) DESCRIBE `avid_specials` 0.0014920234680176
(402) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72827 and class = 'Cruise') OR (item_id = 850 AND class = 'Ship') OR (item_id = 91 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.0014550685882568
(403) DESCRIBE `cruiselines` 0.0019299983978271
(404) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00039100646972656
(405) DESCRIBE `orchid_image` 0.0016448497772217
(406) DESCRIBE `cruiselines` 0.002479076385498
(407) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00034213066101074
(408) DESCRIBE `cruises` 0.0040559768676758
(409) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69120') 0.00046706199645996
(410) DESCRIBE `ships` 0.0040919780731201
(411) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1108))) 0.00061702728271484
(412) DESCRIBE `ships` 0.0041861534118652
(413) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1108') 0.00049090385437012
(414) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00030112266540527
(415) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0002589225769043
(416) DESCRIBE `itineraries` 0.0018119812011719
(417) DESCRIBE `ports` 0.0016469955444336
(418) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00036191940307617
(419) DESCRIBE `ports` 0.0014419555664062
(420) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00037288665771484
(421) DESCRIBE `ports` 0.0014450550079346
(422) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00032305717468262
(423) DESCRIBE `sailingdates` 0.0012350082397461
(424) DESCRIBE `ports` 0.0017290115356445
(425) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.0004270076751709
(426) DESCRIBE `ports` 0.00154709815979
(427) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00032901763916016
(428) DESCRIBE `ports` 0.0014579296112061
(429) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 609))) 0.00036287307739258
(430) DESCRIBE `ports` 0.0014858245849609
(431) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '609') 0.00034713745117188
(432) DESCRIBE `ports` 0.0014429092407227
(433) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 428))) 0.00044417381286621
(434) DESCRIBE `ports` 0.0014500617980957
(435) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '428') 0.00032782554626465
(436) DESCRIBE `ports` 0.0014629364013672
(437) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 429))) 0.00035810470581055
(438) DESCRIBE `ports` 0.0015578269958496
(439) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '429') 0.00033211708068848
(440) DESCRIBE `ports` 0.001460075378418
(441) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 429))) 0.00034904479980469
(442) DESCRIBE `ports` 0.001471996307373
(443) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '429') 0.00033211708068848
(444) DESCRIBE `ports` 0.0014400482177734
(445) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 712))) 0.00033283233642578
(446) DESCRIBE `ports` 0.0014710426330566
(447) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '712') 0.00029587745666504
(448) DESCRIBE `ports` 0.0014760494232178
(449) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 205))) 0.00037813186645508
(450) DESCRIBE `ports` 0.0014309883117676
(451) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '205') 0.00031805038452148
(452) DESCRIBE `ports` 0.0014588832855225
(453) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 205))) 0.00034904479980469
(454) DESCRIBE `ports` 0.0014910697937012
(455) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '205') 0.00033307075500488
(456) DESCRIBE `ports` 0.0014369487762451
(457) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 533))) 0.00040316581726074
(458) DESCRIBE `ports` 0.0014441013336182
(459) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '533') 0.00031113624572754
(460) DESCRIBE `ports` 0.0014448165893555
(461) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 198))) 0.00034809112548828
(462) DESCRIBE `ports` 0.0014829635620117
(463) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '198') 0.00030899047851562
(464) DESCRIBE `ports` 0.0014381408691406
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00034499168395996
(466) DESCRIBE `ports` 0.0014212131500244
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00031113624572754
(468) DESCRIBE `ports` 0.0015139579772949
(469) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00034093856811523
(470) DESCRIBE `ports` 0.0014619827270508
(471) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00031614303588867
(472) DESCRIBE `ports` 0.0014438629150391
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00034189224243164
(474) DESCRIBE `ports` 0.0014798641204834
(475) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00030803680419922
(476) DESCRIBE `ports` 0.0015511512756348
(477) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00035214424133301
(478) DESCRIBE `ports` 0.0014469623565674
(479) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00031113624572754
(480) DESCRIBE `ports` 0.0014879703521729
(481) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00034499168395996
(482) DESCRIBE `ports` 0.0014510154724121
(483) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.0003211498260498
(484) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69120') AND (sailingdate >= '2019-03-19') 0.0088469982147217
(485) DESCRIBE `avid_specials` 0.0016319751739502
(486) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69120 and class = 'Cruise') OR (item_id = 1108 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 40 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.0014710426330566
(487) DESCRIBE `cruiselines` 0.0021669864654541
(488) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00074291229248047
(489) DESCRIBE `orchid_image` 0.0022780895233154
(490) DESCRIBE `cruiselines` 0.002899169921875
(491) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00046896934509277
(492) DESCRIBE `cruises` 0.0044610500335693
(493) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72919') 0.00060415267944336
(494) DESCRIBE `ships` 0.0045790672302246
(495) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 966))) 0.00074601173400879
(496) DESCRIBE `ships` 0.0048890113830566
(497) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '966') 0.0005791187286377
(498) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035405158996582
(499) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034594535827637
(500) DESCRIBE `itineraries` 0.0020198822021484
(501) DESCRIBE `ports` 0.0030989646911621
(502) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0011758804321289
(503) DESCRIBE `ports` 0.0023579597473145
(504) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00060009956359863
(505) DESCRIBE `ports` 0.0020639896392822
(506) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00054693222045898
(507) DESCRIBE `sailingdates` 0.0018210411071777
(508) DESCRIBE `ports` 0.0021440982818604
(509) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00034213066101074
(510) DESCRIBE `ports` 0.00189208984375
(511) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00060486793518066
(512) DESCRIBE `ports` 0.0023751258850098
(513) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.000823974609375
(514) DESCRIBE `ports` 0.002331018447876
(515) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.0010480880737305
(516) DESCRIBE `ports` 0.0017571449279785
(517) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 581))) 0.00041985511779785
(518) DESCRIBE `ports` 0.002126932144165
(519) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '581') 0.00050592422485352
(520) DESCRIBE `ports` 0.0021419525146484
(521) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.0005180835723877
(522) DESCRIBE `ports` 0.0018470287322998
(523) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00046920776367188
(524) DESCRIBE `ports` 0.0019669532775879
(525) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.000579833984375
(526) DESCRIBE `ports` 0.0020418167114258
(527) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00045204162597656
(528) DESCRIBE `ports` 0.0016789436340332
(529) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00051116943359375
(530) DESCRIBE `ports` 0.0020139217376709
(531) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00047588348388672
(532) DESCRIBE `ports` 0.001967191696167
(533) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00052309036254883
(534) DESCRIBE `ports` 0.0020911693572998
(535) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00042891502380371
(536) DESCRIBE `ports` 0.0018939971923828
(537) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1106))) 0.00049018859863281
(538) DESCRIBE `ports` 0.0019099712371826
(539) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1106') 0.00046205520629883
(540) DESCRIBE `ports` 0.001924991607666
(541) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3268))) 0.00052499771118164
(542) DESCRIBE `ports` 0.0019230842590332
(543) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3268') 0.00043106079101562
(544) DESCRIBE `ports` 0.0018250942230225
(545) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00053215026855469
(546) DESCRIBE `ports` 0.0018060207366943
(547) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00037789344787598
(548) DESCRIBE `ports` 0.0018141269683838
(549) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00045108795166016
(550) DESCRIBE `ports` 0.0016040802001953
(551) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00031900405883789
(552) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '72919') AND (sailingdate >= '2019-03-19') 0.0056428909301758
(553) DESCRIBE `avid_specials` 0.0015199184417725
(554) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72919 and class = 'Cruise') OR (item_id = 966 AND class = 'Ship') OR (item_id = 91 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.0011980533599854
(555) DESCRIBE `cruiselines` 0.0026109218597412
(556) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00052309036254883
(557) DESCRIBE `orchid_image` 0.0018959045410156
(558) DESCRIBE `cruiselines` 0.0026500225067139
(559) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00043487548828125
(560) DESCRIBE `cruises` 0.004021167755127
(561) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72834') 0.00050711631774902
(562) DESCRIBE `ships` 0.0037870407104492
(563) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 850))) 0.00065898895263672
(564) DESCRIBE `ships` 0.0038609504699707
(565) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '850') 0.00043582916259766
(566) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035190582275391
(567) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00056910514831543
(568) DESCRIBE `itineraries` 0.0017869472503662
(569) DESCRIBE `ports` 0.0019938945770264
(570) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00038695335388184
(571) DESCRIBE `ports` 0.00154709815979
(572) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00026607513427734
(573) DESCRIBE `ports` 0.0014050006866455
(574) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.0003361701965332
(575) DESCRIBE `sailingdates` 0.0015101432800293
(576) DESCRIBE `ports` 0.0019609928131104
(577) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00044798851013184
(578) DESCRIBE `ports` 0.0016028881072998
(579) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00040197372436523
(580) DESCRIBE `ports` 0.0017678737640381
(581) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00036978721618652
(582) DESCRIBE `ports` 0.0016710758209229
(583) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00044989585876465
(584) DESCRIBE `ports` 0.0017328262329102
(585) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00040602684020996
(586) DESCRIBE `ports` 0.0018141269683838
(587) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00054097175598145
(588) DESCRIBE `ports` 0.0018851757049561
(589) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 275))) 0.00035691261291504
(590) DESCRIBE `ports` 0.0015289783477783
(591) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '275') 0.00034999847412109
(592) DESCRIBE `ports` 0.0015568733215332
(593) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00041604042053223
(594) DESCRIBE `ports` 0.0016500949859619
(595) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00031089782714844
(596) DESCRIBE `ports` 0.001317024230957
(597) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1493))) 0.00067996978759766
(598) DESCRIBE `ports` 0.0016570091247559
(599) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1493') 0.00034189224243164
(600) DESCRIBE `ports` 0.0018069744110107
(601) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.00063300132751465
(602) DESCRIBE `ports` 0.0015830993652344
(603) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.00035810470581055
(604) DESCRIBE `ports` 0.0017480850219727
(605) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00032591819763184
(606) DESCRIBE `ports` 0.0016520023345947
(607) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00032496452331543
(608) DESCRIBE `ports` 0.0013339519500732
(609) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00035619735717773
(610) DESCRIBE `ports` 0.0016739368438721
(611) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.0004122257232666
(612) DESCRIBE `ports` 0.0018208026885986
(613) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00039100646972656
(614) DESCRIBE `ports` 0.0016701221466064
(615) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00041389465332031
(616) DESCRIBE `ports` 0.001737117767334
(617) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 557))) 0.00044417381286621
(618) DESCRIBE `ports` 0.0018529891967773
(619) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '557') 0.0004270076751709
(620) DESCRIBE `ports` 0.0022871494293213
(621) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00045394897460938
(622) DESCRIBE `ports` 0.0016160011291504
(623) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00040984153747559
(624) DESCRIBE `ports` 0.0018599033355713
(625) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00043892860412598
(626) DESCRIBE `ports` 0.0018711090087891
(627) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00044703483581543
(628) DESCRIBE `ports` 0.0018019676208496
(629) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00043702125549316
(630) DESCRIBE `ports` 0.0015809535980225
(631) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00067496299743652
(632) DESCRIBE `ports` 0.0019640922546387
(633) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 751))) 0.00049495697021484
(634) DESCRIBE `ports` 0.0017349720001221
(635) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '751') 0.00037288665771484
(636) DESCRIBE `ports` 0.0017220973968506
(637) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00042891502380371
(638) DESCRIBE `ports` 0.0016741752624512
(639) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00037908554077148
(640) DESCRIBE `ports` 0.0017950534820557
(641) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 522))) 0.00046396255493164
(642) DESCRIBE `ports` 0.0018210411071777
(643) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '522') 0.00038599967956543
(644) DESCRIBE `ports` 0.0018198490142822
(645) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 220))) 0.00035810470581055
(646) DESCRIBE `ports` 0.0017070770263672
(647) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '220') 0.00036811828613281
(648) DESCRIBE `ports` 0.0013749599456787
(649) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00035500526428223
(650) DESCRIBE `ports` 0.0022339820861816
(651) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.0004270076751709
(652) DESCRIBE `ports` 0.001554012298584
(653) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00038909912109375
(654) DESCRIBE `ports` 0.0014519691467285
(655) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00029706954956055
(656) DESCRIBE `ports` 0.0014359951019287
(657) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 382))) 0.00032401084899902
(658) DESCRIBE `ports` 0.0013308525085449
(659) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '382') 0.00030994415283203
(660) DESCRIBE `ports` 0.0013229846954346
(661) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00029897689819336
(662) DESCRIBE `ports` 0.001338005065918
(663) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00027894973754883
(664) DESCRIBE `ports` 0.00152587890625
(665) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00040221214294434
(666) DESCRIBE `ports` 0.0018279552459717
(667) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.0003349781036377
(668) DESCRIBE `ports` 0.0016028881072998
(669) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00033998489379883
(670) DESCRIBE `ports` 0.0013351440429688
(671) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00031304359436035
(672) DESCRIBE `ports` 0.0016062259674072
(673) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00037002563476562
(674) DESCRIBE `ports` 0.0015201568603516
(675) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00033307075500488
(676) DESCRIBE `ports` 0.0014729499816895
(677) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00037002563476562
(678) DESCRIBE `ports` 0.0015270709991455
(679) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00033283233642578
(680) DESCRIBE `ports` 0.0014779567718506
(681) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00036001205444336
(682) DESCRIBE `ports` 0.0014359951019287
(683) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00038599967956543
(684) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '72834') AND (sailingdate >= '2019-03-19') 0.0085880756378174
(685) DESCRIBE `avid_specials` 0.0019941329956055
(686) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72834 and class = 'Cruise') OR (item_id = 850 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 26 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
(687) DESCRIBE `cruiselines` 0.0028350353240967
(688) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00026798248291016
(689) DESCRIBE `orchid_image` 0.0020051002502441
(690) DESCRIBE `cruiselines` 0.0018148422241211
(691) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00029897689819336
(692) DESCRIBE `cruises` 0.0025808811187744
(693) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '61525') 0.00040602684020996
(694) DESCRIBE `ships` 0.0028219223022461
(695) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 850))) 0.00036787986755371
(696) DESCRIBE `ships` 0.0027101039886475
(697) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '850') 0.00029397010803223
(698) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0002598762512207
(699) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00030994415283203
(700) DESCRIBE `itineraries` 0.0018479824066162
(701) DESCRIBE `ports` 0.0020959377288818
(702) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00049805641174316
(703) DESCRIBE `ports` 0.0018899440765381
(704) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00035595893859863
(705) DESCRIBE `ports` 0.0017640590667725
(706) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00040698051452637
(707) DESCRIBE `sailingdates` 0.0015270709991455
(708) DESCRIBE `ports` 0.00136399269104
(709) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00040292739868164
(710) DESCRIBE `ports` 0.0013961791992188
(711) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00030398368835449
(712) DESCRIBE `ports` 0.0014867782592773
(713) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00037384033203125
(714) DESCRIBE `ports` 0.00142502784729
(715) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00038599967956543
(716) DESCRIBE `ports` 0.0015430450439453
(717) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00041699409484863
(718) DESCRIBE `ports` 0.0018050670623779
(719) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00035619735717773
(720) DESCRIBE `ports` 0.0018241405487061
(721) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 275))) 0.00043678283691406
(722) DESCRIBE `ports` 0.001514196395874
(723) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '275') 0.00043702125549316
(724) DESCRIBE `ports` 0.0018050670623779
(725) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00041389465332031
(726) DESCRIBE `ports` 0.0019359588623047
(727) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00041794776916504
(728) DESCRIBE `ports` 0.026551008224487
(729) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1493))) 0.00054693222045898
(730) DESCRIBE `ports` 0.0018990039825439
(731) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1493') 0.00033783912658691
(732) DESCRIBE `ports` 0.0016279220581055
(733) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.00036406517028809
(734) DESCRIBE `ports` 0.0014140605926514
(735) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.00037598609924316
(736) DESCRIBE `ports` 0.0018179416656494
(737) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00043606758117676
(738) DESCRIBE `ports` 0.0018649101257324
(739) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00037717819213867
(740) DESCRIBE `ports` 0.0018448829650879
(741) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00046205520629883
(742) DESCRIBE `ports` 0.0019388198852539
(743) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00042200088500977
(744) DESCRIBE `ports` 0.0019419193267822
(745) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00048112869262695
(746) DESCRIBE `ports` 0.0018749237060547
(747) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00037193298339844
(748) DESCRIBE `ports` 0.001492977142334
(749) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 557))) 0.00032806396484375
(750) DESCRIBE `ports` 0.0017290115356445
(751) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '557') 0.00037813186645508
(752) DESCRIBE `ports` 0.0018799304962158
(753) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00040411949157715
(754) DESCRIBE `ports` 0.0015699863433838
(755) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00043797492980957
(756) DESCRIBE `ports` 0.001755952835083
(757) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00043010711669922
(758) DESCRIBE `ports` 0.001917839050293
(759) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00043487548828125
(760) DESCRIBE `ports` 0.0019102096557617
(761) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 751))) 0.00054097175598145
(762) DESCRIBE `ports` 0.0020349025726318
(763) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '751') 0.00045204162597656
(764) DESCRIBE `ports` 0.0018479824066162
(765) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00041079521179199
(766) DESCRIBE `ports` 0.0017011165618896
(767) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.0004270076751709
(768) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '61525') AND (sailingdate >= '2019-03-19') 0.0086698532104492
(769) DESCRIBE `avid_specials` 0.0014410018920898
(770) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 61525 and class = 'Cruise') OR (item_id = 850 AND class = 'Ship') OR (item_id = 91 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.0017640590667725
(771) DESCRIBE `cruiselines` 0.0026760101318359
(772) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00049495697021484
(773) DESCRIBE `orchid_image` 0.002000093460083
(774) DESCRIBE `cruiselines` 0.0028212070465088
(775) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00048089027404785
(776) DESCRIBE `cruises` 0.0036540031433105
(777) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72843') 0.00072598457336426
(778) DESCRIBE `ships` 0.0041530132293701
(779) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 508))) 0.00066399574279785
(780) DESCRIBE `ships` 0.0039989948272705
(781) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '508') 0.00035595893859863
(782) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00029993057250977
(783) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00025796890258789
(784) DESCRIBE `itineraries` 0.0012989044189453
(785) DESCRIBE `ports` 0.0013289451599121
(786) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00038599967956543
(787) DESCRIBE `ports` 0.0014770030975342
(788) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.0003659725189209
(789) DESCRIBE `ports` 0.0014779567718506
(790) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00032401084899902
(791) DESCRIBE `sailingdates` 0.0012679100036621
(792) DESCRIBE `ports` 0.0015511512756348
(793) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00036406517028809
(794) DESCRIBE `ports` 0.0014870166778564
(795) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00054311752319336
(796) DESCRIBE `ports` 0.0017120838165283
(797) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 532))) 0.00038003921508789
(798) DESCRIBE `ports` 0.0013871192932129
(799) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '532') 0.00030016899108887
(800) DESCRIBE `ports` 0.0013937950134277
(801) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 379))) 0.00031685829162598
(802) DESCRIBE `ports` 0.00177001953125
(803) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '379') 0.00030517578125
(804) DESCRIBE `ports` 0.0016047954559326
(805) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 246))) 0.00035595893859863
(806) DESCRIBE `ports` 0.0013689994812012
(807) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '246') 0.00028395652770996
(808) DESCRIBE `ports` 0.0014009475708008
(809) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 599))) 0.00033092498779297
(810) DESCRIBE `ports` 0.0017359256744385
(811) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '599') 0.00032997131347656
(812) DESCRIBE `ports` 0.0015170574188232
(813) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 598))) 0.00040912628173828
(814) DESCRIBE `ports` 0.0015251636505127
(815) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '598') 0.00037002563476562
(816) DESCRIBE `ports` 0.0015578269958496
(817) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 685))) 0.00042915344238281
(818) DESCRIBE `ports` 0.0022158622741699
(819) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '685') 0.00042581558227539
(820) DESCRIBE `ports` 0.0018229484558105
(821) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 391))) 0.00043487548828125
(822) DESCRIBE `ports` 0.0015859603881836
(823) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '391') 0.00033211708068848
(824) DESCRIBE `ports` 0.0013039112091064
(825) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00031304359436035
(826) DESCRIBE `ports` 0.0014638900756836
(827) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.0002892017364502
(828) DESCRIBE `ports` 0.0017490386962891
(829) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.0003199577331543
(830) DESCRIBE `ports` 0.0017538070678711
(831) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00047993659973145
(832) DESCRIBE `ports` 0.0016598701477051
(833) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00037193298339844
(834) DESCRIBE `ports` 0.001378059387207
(835) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00028705596923828
(836) DESCRIBE `ports` 0.0013291835784912
(837) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00032711029052734
(838) DESCRIBE `ports` 0.0013959407806396
(839) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00029206275939941
(840) DESCRIBE `ports` 0.0015130043029785
(841) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 529))) 0.00029897689819336
(842) DESCRIBE `ports` 0.001399040222168
(843) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '529') 0.00031900405883789
(844) DESCRIBE `ports` 0.0015220642089844
(845) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 557))) 0.00040197372436523
(846) DESCRIBE `ports` 0.0013899803161621
(847) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '557') 0.00029802322387695
(848) DESCRIBE `ports` 0.0013370513916016
(849) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00035405158996582
(850) DESCRIBE `ports` 0.0016229152679443
(851) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00033402442932129
(852) DESCRIBE `ports` 0.0015799999237061
(853) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00044012069702148
(854) DESCRIBE `ports` 0.0013220310211182
(855) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00033998489379883
(856) DESCRIBE `ports` 0.001478910446167
(857) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 751))) 0.00032496452331543
(858) DESCRIBE `ports` 0.0012960433959961
(859) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '751') 0.00027894973754883
(860) DESCRIBE `ports` 0.0013229846954346
(861) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1063))) 0.00029993057250977
(862) DESCRIBE `ports` 0.0015420913696289
(863) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1063') 0.00030016899108887
(864) DESCRIBE `ports` 0.0014121532440186
(865) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 714))) 0.00033116340637207
(866) DESCRIBE `ports` 0.0013720989227295
(867) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '714') 0.00032496452331543
(868) DESCRIBE `ports` 0.0015969276428223
(869) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.0004270076751709
(870) DESCRIBE `ports` 0.0017008781433105
(871) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00033211708068848
(872) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '72843') AND (sailingdate >= '2019-03-19') 0.0065319538116455
(873) DESCRIBE `avid_specials` 0.0015709400177002
(874) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72843 and class = 'Cruise') OR (item_id = 508 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 28 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.0013840198516846
(875) DESCRIBE `cruiselines` 0.002302885055542
(876) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.0005040168762207
(877) DESCRIBE `orchid_image` 0.0017530918121338
(878) DESCRIBE `cruiselines` 0.0025770664215088
(879) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00047016143798828
(880) DESCRIBE `ships` 0.0037851333618164
(881) SELECT `ships`.* FROM `ships` WHERE (id IN ('1319', '850', '966', '508', '1108', '394')) ORDER BY FIND_IN_SET(id, '1319,850,966,508,1108,394') 0.001223087310791
(882) DESCRIBE `cruisetypes` 0.0016250610351562
(883) DESCRIBE `destinations` 0.0024828910827637
(884) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '12', '40', '37', '2', '26', '43', '38', '35', '28', '21', '48', '11', '49', '25', '8', '10', '45', '30', '52', '34', '32', '55')) ORDER BY FIND_IN_SET(id, '22,12,40,37,2,26,43,38,35,28,21,48,11,49,25,8,10,45,30,52,34,32,55') 0.0022380352020264
(885) DESCRIBE `cruiselines` 0.0027601718902588
(886) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00053715705871582
(887) DESCRIBE `cruiselines` 0.002593994140625
(888) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00041794776916504