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

Total elapsed time: 0.74143838882446

# Query Time
(1) connect 0.00085687637329102
(2) DESCRIBE `cruises` 0.0031759738922119
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (82172, 82063, 82063, 82124, 82125, 82171, 68831, 68831, 82064, 82064)) ORDER BY FIND_IN_SET(id, '82172,82063,82063,82124,82125,82171,68831,68831,82064,82064') 0.0016889572143555
(4) DESCRIBE `cruises` 0.0031111240386963
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82172') 0.00033116340637207
(6) DESCRIBE `ships` 0.0026569366455078
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1526))) 0.00045895576477051
(8) DESCRIBE `ships` 0.0024359226226807
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1526') 0.00031805038452148
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00029587745666504
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00024986267089844
(12) DESCRIBE `itineraries` 0.0013549327850342
(13) DESCRIBE `ports` 0.0012791156768799
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.0002751350402832
(15) DESCRIBE `ports` 0.0012581348419189
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00027990341186523
(17) DESCRIBE `ports` 0.001352071762085
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.0002751350402832
(19) DESCRIBE `sailingdates` 0.0011348724365234
(20) DESCRIBE `ports` 0.0012838840484619
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00031805038452148
(22) DESCRIBE `ports` 0.0011589527130127
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00026893615722656
(24) DESCRIBE `ports` 0.0013258457183838
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00033092498779297
(26) DESCRIBE `ports` 0.0012807846069336
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00027585029602051
(28) DESCRIBE `ports` 0.001288890838623
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00028300285339355
(30) DESCRIBE `ports` 0.0013668537139893
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00026798248291016
(32) DESCRIBE `ports` 0.0012269020080566
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00028896331787109
(34) DESCRIBE `ports` 0.001270055770874
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00026607513427734
(36) DESCRIBE `ports` 0.0012750625610352
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00030303001403809
(38) DESCRIBE `ports` 0.0012249946594238
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00027084350585938
(40) DESCRIBE `ports` 0.0012280941009521
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.0003211498260498
(42) DESCRIBE `ports` 0.0012941360473633
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00027108192443848
(44) DESCRIBE `ports` 0.001230001449585
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00037193298339844
(46) DESCRIBE `ports` 0.0014209747314453
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00031399726867676
(48) DESCRIBE `ports` 0.0013840198516846
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6129))) 0.0002751350402832
(50) DESCRIBE `ports` 0.0012550354003906
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6129') 0.00029611587524414
(52) DESCRIBE `ports` 0.0013220310211182
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.0002899169921875
(54) DESCRIBE `ports` 0.0017158985137939
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00027799606323242
(56) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '82172') AND (sailingdate >= '2020-02-01') 0.01347017288208
(57) DESCRIBE `avid_specials` 0.0014669895172119
(58) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 82172 and class = 'Cruise') OR (item_id = 1526 AND class = 'Ship') OR (item_id = 212 AND class = 'CruiseLine') OR (item_id = 39 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.00094199180603027
(59) DESCRIBE `cruiselines` 0.0018441677093506
(60) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00032711029052734
(61) DESCRIBE `orchid_image` 0.001453161239624
(62) DESCRIBE `cruiselines` 0.0015020370483398
(63) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00031495094299316
(64) DESCRIBE `specials` 0.0036520957946777
(65) DESCRIBE `specials` 0.0035719871520996
(66) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1534175') 0.00034904479980469
(67) DESCRIBE `ships` 0.0031669139862061
(68) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1526))) 0.00029778480529785
(69) DESCRIBE `ships` 0.0030028820037842
(70) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1526') 0.0004429817199707
(71) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00027203559875488
(72) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00024986267089844
(73) DESCRIBE `itineraries` 0.0016779899597168
(74) DESCRIBE `ports` 0.0013289451599121
(75) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00033998489379883
(76) DESCRIBE `ports` 0.0013589859008789
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00028896331787109
(78) DESCRIBE `ports` 0.0012388229370117
(79) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00028300285339355
(80) DESCRIBE `specialsailingdates` 0.0010340213775635
(81) DESCRIBE `sailingdates` 0.0011520385742188
(82) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515290))) 0.00032687187194824
(83) DESCRIBE `sailingdates` 0.0012259483337402
(84) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515291))) 0.00029897689819336
(85) DESCRIBE `sailingdates` 0.0012750625610352
(86) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515292))) 0.00028514862060547
(87) DESCRIBE `sailingdates` 0.0012259483337402
(88) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515296))) 0.0002748966217041
(89) DESCRIBE `sailingdates` 0.0011930465698242
(90) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515304))) 0.00029897689819336
(91) DESCRIBE `sailingdates` 0.0012199878692627
(92) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515305))) 0.00030708312988281
(93) DESCRIBE `sailingdates` 0.0011181831359863
(94) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515308))) 0.00027012825012207
(95) DESCRIBE `sailingdates` 0.0012140274047852
(96) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515325))) 0.00026917457580566
(97) DESCRIBE `sailingdates` 0.0012829303741455
(98) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515330))) 0.00027298927307129
(99) DESCRIBE `sailingdates` 0.0011839866638184
(100) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515331))) 0.00039196014404297
(101) DESCRIBE `sailingdates` 0.001554012298584
(102) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515332))) 0.00036311149597168
(103) DESCRIBE `sailingdates` 0.001533031463623
(104) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515333))) 0.00037789344787598
(105) DESCRIBE `ports` 0.0017020702362061
(106) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00041413307189941
(107) DESCRIBE `ports` 0.0017061233520508
(108) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00030183792114258
(109) DESCRIBE `ports` 0.0016999244689941
(110) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.0003969669342041
(111) DESCRIBE `ports` 0.0018310546875
(112) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00037002563476562
(113) DESCRIBE `ports` 0.0016980171203613
(114) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6129))) 0.00035810470581055
(115) DESCRIBE `ports` 0.0016400814056396
(116) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6129') 0.00034594535827637
(117) DESCRIBE `ports` 0.0016591548919678
(118) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00040388107299805
(119) DESCRIBE `ports` 0.001708984375
(120) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00035285949707031
(121) DESCRIBE `ports` 0.0017318725585938
(122) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00038695335388184
(123) DESCRIBE `ports` 0.001662015914917
(124) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00036001205444336
(125) DESCRIBE `ports` 0.0016460418701172
(126) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 156))) 0.00037693977355957
(127) DESCRIBE `ports` 0.0017268657684326
(128) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '156') 0.00035285949707031
(129) DESCRIBE `ports` 0.0020971298217773
(130) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00057601928710938
(131) DESCRIBE `ports` 0.0018110275268555
(132) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 1.5974044799805E-5
(133) DESCRIBE `ports` 0.0016820430755615
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00043487548828125
(135) DESCRIBE `ports` 0.0011661052703857
(136) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00033211708068848
(137) DESCRIBE `ports` 0.0018219947814941
(138) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00039100646972656
(139) DESCRIBE `ports` 0.0017077922821045
(140) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.0003669261932373
(141) DESCRIBE `cruises` 0.0032751560211182
(142) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 82063))) 0.00060296058654785
(143) DESCRIBE `avid_specials` 0.0015292167663574
(144) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1534175 and class = 'Special') OR (item_id = 82063 and class = 'Cruise') OR (item_id = 1526 AND class = 'Ship') OR (item_id = 212 AND class = 'CruiseLine') OR (item_id = 39 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.0017461776733398
(145) DESCRIBE `cruiselines` 0.0024099349975586
(146) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00043201446533203
(147) DESCRIBE `orchid_image` 0.0018241405487061
(148) DESCRIBE `cruiselines` 0.0023729801177979
(149) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00037813186645508
(150) DESCRIBE `cruises` 0.0031828880310059
(151) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82063') 0.00040507316589355
(152) DESCRIBE `ships` 0.0035409927368164
(153) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1526))) 0.0005340576171875
(154) DESCRIBE `ships` 0.0033988952636719
(155) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1526') 0.00040316581726074
(156) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034284591674805
(157) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00033688545227051
(158) DESCRIBE `itineraries` 0.0018000602722168
(159) DESCRIBE `ports` 0.0019321441650391
(160) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00049591064453125
(161) DESCRIBE `ports` 0.0014619827270508
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00031900405883789
(163) DESCRIBE `ports` 0.0013611316680908
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00042390823364258
(165) DESCRIBE `sailingdates` 0.0015120506286621
(166) DESCRIBE `ports` 0.0013468265533447
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00041890144348145
(168) DESCRIBE `ports` 0.0014009475708008
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 5.6028366088867E-5
(170) DESCRIBE `ports` 0.0012660026550293
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00032496452331543
(172) DESCRIBE `ports` 0.0013971328735352
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00029206275939941
(174) DESCRIBE `ports` 0.0013129711151123
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6129))) 0.00034713745117188
(176) DESCRIBE `ports` 0.0013070106506348
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6129') 0.00031709671020508
(178) DESCRIBE `ports` 0.0013649463653564
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00063991546630859
(180) DESCRIBE `ports` 0.0013251304626465
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00028705596923828
(182) DESCRIBE `ports` 0.0013260841369629
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00024199485778809
(184) DESCRIBE `ports` 0.001255989074707
(185) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00028586387634277
(186) DESCRIBE `ports` 0.0016469955444336
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 156))) 0.00033307075500488
(188) DESCRIBE `ports` 0.0014400482177734
(189) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '156') 0.00052213668823242
(190) DESCRIBE `ports` 0.0012609958648682
(191) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00030088424682617
(192) DESCRIBE `ports` 0.0012810230255127
(193) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 5.0067901611328E-5
(194) DESCRIBE `ports` 0.0013048648834229
(195) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00030207633972168
(196) DESCRIBE `ports` 0.0014231204986572
(197) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00027298927307129
(198) DESCRIBE `ports` 0.0018868446350098
(199) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00035309791564941
(200) DESCRIBE `ports` 0.0013117790222168
(201) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00034403800964355
(202) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '82063') AND (sailingdate >= '2020-02-01') 0.0058300495147705
(203) DESCRIBE `avid_specials` 0.0012590885162354
(204) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 82063 and class = 'Cruise') OR (item_id = 1526 AND class = 'Ship') OR (item_id = 212 AND class = 'CruiseLine') OR (item_id = 39 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.0010731220245361
(205) DESCRIBE `cruiselines` 0.0018739700317383
(206) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00032806396484375
(207) DESCRIBE `orchid_image` 0.0014081001281738
(208) DESCRIBE `cruiselines` 0.001906156539917
(209) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00028204917907715
(210) DESCRIBE `cruises` 0.0026950836181641
(211) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82124') 0.00034999847412109
(212) DESCRIBE `ships` 0.0025889873504639
(213) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1013))) 0.00035285949707031
(214) DESCRIBE `ships` 0.0025701522827148
(215) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1013') 0.00028109550476074
(216) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026893615722656
(217) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025486946105957
(218) DESCRIBE `itineraries` 0.0013198852539062
(219) DESCRIBE `ports` 0.0012781620025635
(220) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00035214424133301
(221) DESCRIBE `ports` 0.0013558864593506
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00040102005004883
(223) DESCRIBE `ports` 0.0014150142669678
(224) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00030016899108887
(225) DESCRIBE `sailingdates` 0.0011570453643799
(226) DESCRIBE `ports` 0.0014200210571289
(227) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00032901763916016
(228) DESCRIBE `ports` 0.0012898445129395
(229) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00028491020202637
(230) DESCRIBE `ports` 0.0014259815216064
(231) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00033998489379883
(232) DESCRIBE `ports` 0.0016419887542725
(233) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00032997131347656
(234) DESCRIBE `ports` 0.001270055770874
(235) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00036811828613281
(236) DESCRIBE `ports` 0.0013370513916016
(237) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00028705596923828
(238) DESCRIBE `ports` 0.0013248920440674
(239) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00033712387084961
(240) DESCRIBE `ports` 0.0012519359588623
(241) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00030899047851562
(242) DESCRIBE `ports` 0.0013899803161621
(243) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00032997131347656
(244) DESCRIBE `ports` 0.0013480186462402
(245) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00029397010803223
(246) DESCRIBE `ports` 0.0013458728790283
(247) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00030708312988281
(248) DESCRIBE `ports` 0.0015699863433838
(249) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00033283233642578
(250) DESCRIBE `ports` 0.001568078994751
(251) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 156))) 0.00039005279541016
(252) DESCRIBE `ports` 0.0016798973083496
(253) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '156') 0.00041484832763672
(254) DESCRIBE `ports` 0.0016541481018066
(255) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00039410591125488
(256) DESCRIBE `ports` 0.0014381408691406
(257) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00029397010803223
(258) DESCRIBE `ports` 0.0015668869018555
(259) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00036811828613281
(260) DESCRIBE `ports` 0.0015168190002441
(261) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00030994415283203
(262) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '82124') AND (sailingdate >= '2020-02-01') 0.0062530040740967
(263) DESCRIBE `avid_specials` 0.0014610290527344
(264) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 82124 and class = 'Cruise') OR (item_id = 1013 AND class = 'Ship') OR (item_id = 212 AND class = 'CruiseLine') OR (item_id = 39 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.0010900497436523
(265) DESCRIBE `cruiselines` 0.0020248889923096
(266) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00037503242492676
(267) DESCRIBE `orchid_image` 0.0015881061553955
(268) DESCRIBE `cruiselines` 0.0023510456085205
(269) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00035786628723145
(270) DESCRIBE `cruises` 0.0025649070739746
(271) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82125') 0.00036096572875977
(272) DESCRIBE `ships` 0.0025529861450195
(273) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1013))) 0.00044012069702148
(274) DESCRIBE `ships` 0.0028131008148193
(275) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1013') 0.0003199577331543
(276) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026988983154297
(277) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002589225769043
(278) DESCRIBE `itineraries` 0.0013132095336914
(279) DESCRIBE `ports` 0.0014679431915283
(280) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00040006637573242
(281) DESCRIBE `ports` 0.0013599395751953
(282) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00030183792114258
(283) DESCRIBE `ports` 0.00094008445739746
(284) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00035619735717773
(285) DESCRIBE `sailingdates` 0.0012578964233398
(286) DESCRIBE `ports` 0.0013208389282227
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00033903121948242
(288) DESCRIBE `ports` 0.0013630390167236
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00029301643371582
(290) DESCRIBE `ports` 0.0013370513916016
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00034189224243164
(292) DESCRIBE `ports` 0.0012490749359131
(293) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00030994415283203
(294) DESCRIBE `ports` 0.0013360977172852
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00039100646972656
(296) DESCRIBE `ports` 0.0017800331115723
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00029897689819336
(298) DESCRIBE `ports` 0.0014820098876953
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00035190582275391
(300) DESCRIBE `ports` 0.0012969970703125
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00027894973754883
(302) DESCRIBE `ports` 0.0014019012451172
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00032901763916016
(304) DESCRIBE `ports` 0.0012998580932617
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00028300285339355
(306) DESCRIBE `ports` 0.0013229846954346
(307) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00031685829162598
(308) DESCRIBE `ports` 0.0015208721160889
(309) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00028610229492188
(310) DESCRIBE `ports` 0.0013070106506348
(311) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4585))) 0.00036501884460449
(312) DESCRIBE `ports` 0.0013868808746338
(313) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4585') 0.00031304359436035
(314) DESCRIBE `ports` 0.0014021396636963
(315) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00030899047851562
(316) DESCRIBE `ports` 0.0018289089202881
(317) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00036191940307617
(318) DESCRIBE `ports` 0.0017890930175781
(319) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00042104721069336
(320) DESCRIBE `ports` 0.0017879009246826
(321) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00031399726867676
(322) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '82125') AND (sailingdate >= '2020-02-01') 0.0069210529327393
(323) DESCRIBE `avid_specials` 0.0014197826385498
(324) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 82125 and class = 'Cruise') OR (item_id = 1013 AND class = 'Ship') OR (item_id = 212 AND class = 'CruiseLine') OR (item_id = 39 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.0011382102966309
(325) DESCRIBE `cruiselines` 0.0019659996032715
(326) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00034999847412109
(327) DESCRIBE `orchid_image` 0.0017328262329102
(328) DESCRIBE `cruiselines` 0.0021209716796875
(329) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00041079521179199
(330) DESCRIBE `cruises` 0.0028440952301025
(331) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82171') 0.00033211708068848
(332) DESCRIBE `ships` 0.0025210380554199
(333) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1013))) 0.0003972053527832
(334) DESCRIBE `ships` 0.0032198429107666
(335) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1013') 0.00034093856811523
(336) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030398368835449
(337) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025796890258789
(338) DESCRIBE `itineraries` 0.0013251304626465
(339) DESCRIBE `ports` 0.0015578269958496
(340) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00048995018005371
(341) DESCRIBE `ports` 0.0017130374908447
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00017690658569336
(343) DESCRIBE `ports` 0.001356840133667
(344) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.0003819465637207
(345) DESCRIBE `sailingdates` 0.001291036605835
(346) DESCRIBE `ports` 0.0015008449554443
(347) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00034809112548828
(348) DESCRIBE `ports` 0.0012719631195068
(349) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00031709671020508
(350) DESCRIBE `ports` 0.0012969970703125
(351) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00031304359436035
(352) DESCRIBE `ports` 0.001802921295166
(353) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00036287307739258
(354) DESCRIBE `ports` 0.0018539428710938
(355) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6129))) 0.00029802322387695
(356) DESCRIBE `ports` 0.0013580322265625
(357) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6129') 0.0003058910369873
(358) DESCRIBE `ports` 0.0013229846954346
(359) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00038790702819824
(360) DESCRIBE `ports` 0.0014100074768066
(361) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00030708312988281
(362) DESCRIBE `ports` 0.0014290809631348
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00055694580078125
(364) DESCRIBE `ports` 0.0014669895172119
(365) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.0003058910369873
(366) DESCRIBE `ports` 0.0015289783477783
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 156))) 0.00042009353637695
(368) DESCRIBE `ports` 0.0012860298156738
(369) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '156') 0.00028800964355469
(370) DESCRIBE `ports` 0.0012929439544678
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00031614303588867
(372) DESCRIBE `ports` 0.0013139247894287
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00046896934509277
(374) DESCRIBE `ports` 0.0014100074768066
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00038313865661621
(376) DESCRIBE `ports` 0.0014259815216064
(377) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00031113624572754
(378) DESCRIBE `ports` 0.001338005065918
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00033807754516602
(380) DESCRIBE `ports` 0.0016319751739502
(381) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00059103965759277
(382) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '82171') AND (sailingdate >= '2020-02-01') 0.0073339939117432
(383) DESCRIBE `avid_specials` 0.0013599395751953
(384) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 82171 and class = 'Cruise') OR (item_id = 1013 AND class = 'Ship') OR (item_id = 212 AND class = 'CruiseLine') OR (item_id = 39 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.0010690689086914
(385) DESCRIBE `cruiselines` 0.001924991607666
(386) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00033903121948242
(387) DESCRIBE `orchid_image` 0.0018410682678223
(388) DESCRIBE `cruiselines` 0.001838207244873
(389) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00030112266540527
(390) DESCRIBE `cruises` 0.0027508735656738
(391) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68831') 0.0005340576171875
(392) DESCRIBE `ships` 0.0024611949920654
(393) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1013))) 0.00075387954711914
(394) DESCRIBE `ships` 0.0025930404663086
(395) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1013') 0.00028109550476074
(396) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028109550476074
(397) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032305717468262
(398) DESCRIBE `itineraries` 0.0013368129730225
(399) DESCRIBE `ports` 0.0013039112091064
(400) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00033998489379883
(401) DESCRIBE `ports` 0.0014081001281738
(402) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.0003199577331543
(403) DESCRIBE `ports` 0.0013260841369629
(404) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00029492378234863
(405) DESCRIBE `sailingdates` 0.0011990070343018
(406) DESCRIBE `ports` 0.0016889572143555
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00041294097900391
(408) DESCRIBE `ports` 0.0013480186462402
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00028896331787109
(410) DESCRIBE `ports` 0.0013010501861572
(411) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00031113624572754
(412) DESCRIBE `ports` 0.0012481212615967
(413) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00033712387084961
(414) DESCRIBE `ports` 0.001248836517334
(415) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00028896331787109
(416) DESCRIBE `ports` 0.0012648105621338
(417) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00036311149597168
(418) DESCRIBE `ports` 0.0012669563293457
(419) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.0003199577331543
(420) DESCRIBE `ports` 0.001460075378418
(421) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00027108192443848
(422) DESCRIBE `ports` 0.0013101100921631
(423) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00031399726867676
(424) DESCRIBE `ports` 0.0014050006866455
(425) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.0002741813659668
(426) DESCRIBE `ports` 0.0012738704681396
(427) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00034904479980469
(428) DESCRIBE `ports` 0.0012478828430176
(429) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00029301643371582
(430) DESCRIBE `ports` 0.0012338161468506
(431) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4585))) 0.00041294097900391
(432) DESCRIBE `ports` 0.0016839504241943
(433) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4585') 0.00037384033203125
(434) DESCRIBE `ports` 0.0017631053924561
(435) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.0003809928894043
(436) DESCRIBE `ports` 0.0018219947814941
(437) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.0003809928894043
(438) DESCRIBE `ports` 0.0014588832855225
(439) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00030303001403809
(440) DESCRIBE `ports` 0.0012550354003906
(441) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00028204917907715
(442) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '68831') AND (sailingdate >= '2020-02-01') 0.0050978660583496
(443) DESCRIBE `avid_specials` 0.0012369155883789
(444) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68831 and class = 'Cruise') OR (item_id = 1013 AND class = 'Ship') OR (item_id = 212 AND class = 'CruiseLine') OR (item_id = 39 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.0011401176452637
(445) DESCRIBE `cruiselines` 0.0019130706787109
(446) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00033307075500488
(447) DESCRIBE `orchid_image` 0.0014290809631348
(448) DESCRIBE `cruiselines` 0.0018620491027832
(449) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00029802322387695
(450) DESCRIBE `specials` 0.0036640167236328
(451) DESCRIBE `specials` 0.00357985496521
(452) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1534180') 0.0003960132598877
(453) DESCRIBE `ships` 0.0024740695953369
(454) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1013))) 0.00035500526428223
(455) DESCRIBE `ships` 0.0025069713592529
(456) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1013') 0.00028896331787109
(457) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027203559875488
(458) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00024890899658203
(459) DESCRIBE `itineraries` 0.0014851093292236
(460) DESCRIBE `ports` 0.0012679100036621
(461) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00033116340637207
(462) DESCRIBE `ports` 0.0012829303741455
(463) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00027990341186523
(464) DESCRIBE `ports` 0.0012359619140625
(465) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00031089782714844
(466) DESCRIBE `specialsailingdates` 0.001054048538208
(467) DESCRIBE `sailingdates` 0.001133918762207
(468) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515685))) 0.00053691864013672
(469) DESCRIBE `sailingdates` 0.0010919570922852
(470) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515686))) 0.00026893615722656
(471) DESCRIBE `sailingdates` 0.0011239051818848
(472) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515690))) 0.00029397010803223
(473) DESCRIBE `sailingdates` 0.0011970996856689
(474) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515691))) 0.00026607513427734
(475) DESCRIBE `sailingdates` 0.0011970996856689
(476) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515696))) 0.00026607513427734
(477) DESCRIBE `sailingdates` 0.0012001991271973
(478) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515697))) 0.00027990341186523
(479) DESCRIBE `sailingdates` 0.0012960433959961
(480) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515698))) 0.00026583671569824
(481) DESCRIBE `sailingdates` 0.0012879371643066
(482) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515699))) 0.00026798248291016
(483) DESCRIBE `sailingdates` 0.001323938369751
(484) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515288))) 0.00036096572875977
(485) DESCRIBE `sailingdates` 0.0011608600616455
(486) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515704))) 0.00027680397033691
(487) DESCRIBE `sailingdates` 0.0011379718780518
(488) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515711))) 0.00027585029602051
(489) DESCRIBE `sailingdates` 0.0011589527130127
(490) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515712))) 0.00030112266540527
(491) DESCRIBE `sailingdates` 0.0011107921600342
(492) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515713))) 0.00028681755065918
(493) DESCRIBE `sailingdates` 0.0011169910430908
(494) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515718))) 0.00027298927307129
(495) DESCRIBE `sailingdates` 0.0011780261993408
(496) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515719))) 0.00026392936706543
(497) DESCRIBE `sailingdates` 0.001101016998291
(498) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515720))) 0.0002739429473877
(499) DESCRIBE `sailingdates` 0.0010931491851807
(500) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515721))) 0.00031399726867676
(501) DESCRIBE `sailingdates` 0.0011470317840576
(502) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515725))) 0.00029492378234863
(503) DESCRIBE `ports` 0.0012857913970947
(504) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00031900405883789
(505) DESCRIBE `ports` 0.0013267993927002
(506) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00027990341186523
(507) DESCRIBE `ports` 0.0012872219085693
(508) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00030708312988281
(509) DESCRIBE `ports` 0.0012531280517578
(510) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00026512145996094
(511) DESCRIBE `ports` 0.0013179779052734
(512) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00029397010803223
(513) DESCRIBE `ports` 0.0012359619140625
(514) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00031709671020508
(515) DESCRIBE `ports` 0.0012369155883789
(516) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00029587745666504
(517) DESCRIBE `ports` 0.0012471675872803
(518) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00031089782714844
(519) DESCRIBE `ports` 0.001262903213501
(520) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00031185150146484
(521) DESCRIBE `ports` 0.0012748241424561
(522) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00027203559875488
(523) DESCRIBE `ports` 0.0013260841369629
(524) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00029182434082031
(525) DESCRIBE `ports` 0.0013539791107178
(526) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00026512145996094
(527) DESCRIBE `ports` 0.0013210773468018
(528) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4585))) 0.0003049373626709
(529) DESCRIBE `ports` 0.0013749599456787
(530) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4585') 0.00029182434082031
(531) DESCRIBE `ports` 0.001453161239624
(532) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00029516220092773
(533) DESCRIBE `ports` 0.0012500286102295
(534) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00026607513427734
(535) DESCRIBE `ports` 0.0013790130615234
(536) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00030899047851562
(537) DESCRIBE `ports` 0.0013580322265625
(538) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.0003199577331543
(539) DESCRIBE `cruises` 0.002532958984375
(540) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 68831))) 0.00054311752319336
(541) DESCRIBE `avid_specials` 0.0012550354003906
(542) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1534180 and class = 'Special') OR (item_id = 68831 and class = 'Cruise') OR (item_id = 1013 AND class = 'Ship') OR (item_id = 212 AND class = 'CruiseLine') OR (item_id = 39 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.0010058879852295
(543) DESCRIBE `cruiselines` 0.0019071102142334
(544) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00032711029052734
(545) DESCRIBE `orchid_image` 0.0018320083618164
(546) DESCRIBE `cruiselines` 0.001863956451416
(547) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00032711029052734
(548) DESCRIBE `specials` 0.0044519901275635
(549) DESCRIBE `specials` 0.004918098449707
(550) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1534121') 0.0004889965057373
(551) DESCRIBE `ships` 0.0037260055541992
(552) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1526))) 0.00066900253295898
(553) DESCRIBE `ships` 0.0039467811584473
(554) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1526') 0.00045299530029297
(555) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00027704238891602
(556) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025796890258789
(557) DESCRIBE `itineraries` 0.0016980171203613
(558) DESCRIBE `ports` 0.0018801689147949
(559) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00046396255493164
(560) DESCRIBE `ports` 0.0018520355224609
(561) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00042986869812012
(562) DESCRIBE `ports` 0.0018818378448486
(563) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00042581558227539
(564) DESCRIBE `specialsailingdates` 0.0015208721160889
(565) DESCRIBE `sailingdates` 0.0016100406646729
(566) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515297))) 0.00049805641174316
(567) DESCRIBE `ports` 0.0018091201782227
(568) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00043582916259766
(569) DESCRIBE `ports` 0.0017681121826172
(570) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00039887428283691
(571) DESCRIBE `ports` 0.0019328594207764
(572) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00042414665222168
(573) DESCRIBE `ports` 0.0018370151519775
(574) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00037598609924316
(575) DESCRIBE `ports` 0.0018131732940674
(576) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00040292739868164
(577) DESCRIBE `ports` 0.0017850399017334
(578) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00040602684020996
(579) DESCRIBE `ports` 0.0018291473388672
(580) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00044584274291992
(581) DESCRIBE `ports` 0.0019690990447998
(582) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00040888786315918
(583) DESCRIBE `ports` 0.0018329620361328
(584) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00043416023254395
(585) DESCRIBE `ports` 0.0019369125366211
(586) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00042986869812012
(587) DESCRIBE `ports` 0.0019450187683105
(588) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00044012069702148
(589) DESCRIBE `ports` 0.0018091201782227
(590) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00040316581726074
(591) DESCRIBE `ports` 0.0018441677093506
(592) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 156))) 0.00047206878662109
(593) DESCRIBE `ports` 0.0015239715576172
(594) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '156') 0.00036001205444336
(595) DESCRIBE `ports` 0.0017259120941162
(596) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00043320655822754
(597) DESCRIBE `ports` 0.0016889572143555
(598) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00036787986755371
(599) DESCRIBE `ports` 0.0017850399017334
(600) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00049400329589844
(601) DESCRIBE `ports` 0.0017790794372559
(602) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00039100646972656
(603) DESCRIBE `cruises` 0.0034689903259277
(604) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 82064))) 0.00075602531433105
(605) DESCRIBE `avid_specials` 0.0014100074768066
(606) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1534121 and class = 'Special') OR (item_id = 82064 and class = 'Cruise') OR (item_id = 1526 AND class = 'Ship') OR (item_id = 212 AND class = 'CruiseLine') OR (item_id = 39 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.0016181468963623
(607) DESCRIBE `cruiselines` 0.0030059814453125
(608) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.0011699199676514
(609) DESCRIBE `orchid_image` 0.0017111301422119
(610) DESCRIBE `cruiselines` 0.0019400119781494
(611) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00032901763916016
(612) DESCRIBE `cruises` 0.0025079250335693
(613) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82064') 0.00033402442932129
(614) DESCRIBE `ships` 0.0026471614837646
(615) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1526))) 0.00044703483581543
(616) DESCRIBE `ships` 0.0028700828552246
(617) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1526') 0.00033092498779297
(618) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00027012825012207
(619) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025701522827148
(620) DESCRIBE `itineraries` 0.0013039112091064
(621) DESCRIBE `ports` 0.0013120174407959
(622) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00036287307739258
(623) DESCRIBE `ports` 0.0015230178833008
(624) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 2.6941299438477E-5
(625) DESCRIBE `ports` 0.0012760162353516
(626) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00028610229492188
(627) DESCRIBE `sailingdates` 0.0014190673828125
(628) DESCRIBE `ports` 0.0012998580932617
(629) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.0004570484161377
(630) DESCRIBE `ports` 0.001427173614502
(631) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00031709671020508
(632) DESCRIBE `ports` 0.0014901161193848
(633) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0
(634) DESCRIBE `ports` 0.001276969909668
(635) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00028610229492188
(636) DESCRIBE `ports` 0.0017399787902832
(637) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00029993057250977
(638) DESCRIBE `ports` 0.00130295753479
(639) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00028491020202637
(640) DESCRIBE `ports` 0.0012528896331787
(641) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00030803680419922
(642) DESCRIBE `ports` 0.0012919902801514
(643) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00028800964355469
(644) DESCRIBE `ports` 0.0020952224731445
(645) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00049090385437012
(646) DESCRIBE `ports` 0.0018081665039062
(647) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00029993057250977
(648) DESCRIBE `ports` 0.0013918876647949
(649) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00032305717468262
(650) DESCRIBE `ports` 0.0012819766998291
(651) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00037002563476562
(652) DESCRIBE `ports` 0.0015048980712891
(653) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 156))) 0.0003211498260498
(654) DESCRIBE `ports` 0.0013859272003174
(655) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '156') 0.00028395652770996
(656) DESCRIBE `ports` 0.0013859272003174
(657) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00034999847412109
(658) DESCRIBE `ports` 0.0015149116516113
(659) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00033378601074219
(660) DESCRIBE `ports` 0.0014770030975342
(661) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00037622451782227
(662) DESCRIBE `ports` 0.0014090538024902
(663) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00032711029052734
(664) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '82064') AND (sailingdate >= '2020-02-01') 0.0055079460144043
(665) DESCRIBE `avid_specials` 0.0014030933380127
(666) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 82064 and class = 'Cruise') OR (item_id = 1526 AND class = 'Ship') OR (item_id = 212 AND class = 'CruiseLine') OR (item_id = 39 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.0010590553283691
(667) DESCRIBE `cruiselines` 0.0018808841705322
(668) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.0003669261932373
(669) DESCRIBE `orchid_image` 0.001521110534668
(670) DESCRIBE `cruiselines` 0.0018901824951172
(671) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00030899047851562
(672) DESCRIBE `ships` 0.002830982208252
(673) SELECT `ships`.* FROM `ships` WHERE (id IN ('1163', '1526', '1013', '1791')) ORDER BY FIND_IN_SET(id, '1163,1526,1013,1791') 0.00094199180603027
(674) DESCRIBE `cruisetypes` 0.0012829303741455
(675) DESCRIBE `destinations` 0.0020401477813721
(676) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('39', '34')) ORDER BY FIND_IN_SET(id, '39,34') 0.00060510635375977
(677) DESCRIBE `cruiselines` 0.0020668506622314
(678) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.0003659725189209
(679) DESCRIBE `cruiselines` 0.00189208984375
(680) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00035405158996582