or, enquire about your chosen options

  1. Carnival Cruise Line teams up with Harlem Globetrotters
  2. Ultra-Luxury Cruising
  3. The Caribbean is still a Preferred Cruise Destination
  4. Catch Up on Cruising: Latest News in bite size!
  5. 8 Romantic Destinations Around the World

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

Total elapsed time: 1.3340797424316

# Query Time
(1) connect 0.0016398429870605
(2) DESCRIBE `cruises` 0.0047969818115234
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (82172, 82063, 82124, 82125, 82171, 68831, 82064, 82123, 82126, 45864)) ORDER BY FIND_IN_SET(id, '82172,82063,82124,82125,82171,68831,82064,82123,82126,45864') 0.0023009777069092
(4) DESCRIBE `cruises` 0.0040121078491211
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82172') 0.00050091743469238
(6) DESCRIBE `ships` 0.0042209625244141
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1526))) 0.00066208839416504
(8) DESCRIBE `ships` 0.0050368309020996
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1526') 0.00060200691223145
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00042390823364258
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00041389465332031
(12) DESCRIBE `itineraries` 0.0023500919342041
(13) DESCRIBE `ports` 0.0026030540466309
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00055503845214844
(15) DESCRIBE `ports` 0.0023529529571533
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00051784515380859
(17) DESCRIBE `ports` 0.0023291110992432
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00050115585327148
(19) DESCRIBE `sailingdates` 0.0020408630371094
(20) DESCRIBE `ports` 0.0025160312652588
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.0005638599395752
(22) DESCRIBE `ports` 0.0022139549255371
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00047016143798828
(24) DESCRIBE `ports` 0.0022377967834473
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00054001808166504
(26) DESCRIBE `ports` 0.0024590492248535
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00049901008605957
(28) DESCRIBE `ports` 0.0022289752960205
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00050711631774902
(30) DESCRIBE `ports` 0.0022168159484863
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00051307678222656
(32) DESCRIBE `ports` 0.0022399425506592
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00073695182800293
(34) DESCRIBE `ports` 0.0022552013397217
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00059199333190918
(36) DESCRIBE `ports` 0.0022838115692139
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00067496299743652
(38) DESCRIBE `ports` 0.0022530555725098
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00054407119750977
(40) DESCRIBE `ports` 0.002223014831543
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00057792663574219
(42) DESCRIBE `ports` 0.0022149085998535
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00047612190246582
(44) DESCRIBE `ports` 0.0022070407867432
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00049996376037598
(46) DESCRIBE `ports` 0.0027530193328857
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00060105323791504
(48) DESCRIBE `ports` 0.0026278495788574
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6129))) 0.00055098533630371
(50) DESCRIBE `ports` 0.0023050308227539
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6129') 0.0004420280456543
(52) DESCRIBE `ports` 0.0019059181213379
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00046706199645996
(54) DESCRIBE `ports` 0.002112865447998
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00042295455932617
(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-01-01') 0.0079870223999023
(57) DESCRIBE `avid_specials` 0.0019328594207764
(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.0011849403381348
(59) DESCRIBE `cruiselines` 0.0028970241546631
(60) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00057005882263184
(61) DESCRIBE `orchid_image` 0.0022680759429932
(62) DESCRIBE `cruiselines` 0.0032849311828613
(63) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00054097175598145
(64) DESCRIBE `cruises` 0.0041110515594482
(65) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82063') 0.00053310394287109
(66) DESCRIBE `ships` 0.0051469802856445
(67) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1526))) 0.0007781982421875
(68) DESCRIBE `ships` 0.0054111480712891
(69) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1526') 0.00080704689025879
(70) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00056600570678711
(71) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00057387351989746
(72) DESCRIBE `itineraries` 0.0031840801239014
(73) DESCRIBE `ports` 0.0030210018157959
(74) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00067996978759766
(75) DESCRIBE `ports` 0.0029280185699463
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00065183639526367
(77) DESCRIBE `ports` 0.002899169921875
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00061702728271484
(79) DESCRIBE `sailingdates` 0.0025808811187744
(80) DESCRIBE `ports` 0.0030310153961182
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00071287155151367
(82) DESCRIBE `ports` 0.0027928352355957
(83) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00059413909912109
(84) DESCRIBE `ports` 0.0028781890869141
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00064182281494141
(86) DESCRIBE `ports` 0.0028760433197021
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00060319900512695
(88) DESCRIBE `ports` 0.0029361248016357
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6129))) 0.00072288513183594
(90) DESCRIBE `ports` 0.002863883972168
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6129') 0.00060582160949707
(92) DESCRIBE `ports` 0.0028829574584961
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.0006709098815918
(94) DESCRIBE `ports` 0.0029208660125732
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00061607360839844
(96) DESCRIBE `ports` 0.0027990341186523
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00075387954711914
(98) DESCRIBE `ports` 0.0027508735656738
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00059390068054199
(100) DESCRIBE `ports` 0.0027000904083252
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 156))) 0.00066304206848145
(102) DESCRIBE `ports` 0.0027871131896973
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '156') 0.00059890747070312
(104) DESCRIBE `ports` 0.0028300285339355
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00063896179199219
(106) DESCRIBE `ports` 0.0028460025787354
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00059604644775391
(108) DESCRIBE `ports` 0.0027320384979248
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00068187713623047
(110) DESCRIBE `ports` 0.0027527809143066
(111) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.0006101131439209
(112) DESCRIBE `ports` 0.0028030872344971
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00061917304992676
(114) DESCRIBE `ports` 0.0028069019317627
(115) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00058507919311523
(116) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '82063') AND (sailingdate >= '2020-01-01') 0.0098159313201904
(117) DESCRIBE `avid_specials` 0.0027689933776855
(118) 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.0022270679473877
(119) DESCRIBE `cruiselines` 0.0040299892425537
(120) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00070786476135254
(121) DESCRIBE `orchid_image` 0.0030460357666016
(122) DESCRIBE `cruiselines` 0.003788948059082
(123) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00060176849365234
(124) DESCRIBE `cruises` 0.0051229000091553
(125) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82124') 0.00062084197998047
(126) DESCRIBE `ships` 0.0055699348449707
(127) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1013))) 0.00086402893066406
(128) DESCRIBE `ships` 0.004835844039917
(129) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1013') 0.00056695938110352
(130) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00045680999755859
(131) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035190582275391
(132) DESCRIBE `itineraries` 0.0020830631256104
(133) DESCRIBE `ports` 0.0021090507507324
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00071597099304199
(135) DESCRIBE `ports` 0.0026538372039795
(136) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.0006411075592041
(137) DESCRIBE `ports` 0.0027449131011963
(138) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00062394142150879
(139) DESCRIBE `sailingdates` 0.0024940967559814
(140) DESCRIBE `ports` 0.002932071685791
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00089001655578613
(142) DESCRIBE `ports` 0.0029439926147461
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00064301490783691
(144) DESCRIBE `ports` 0.0028121471405029
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00067877769470215
(146) DESCRIBE `ports` 0.0027878284454346
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.0005791187286377
(148) DESCRIBE `ports` 0.0026259422302246
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00082993507385254
(150) DESCRIBE `ports` 0.0033121109008789
(151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00069379806518555
(152) DESCRIBE `ports` 0.0030889511108398
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00072002410888672
(154) DESCRIBE `ports` 0.0030360221862793
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00062084197998047
(156) DESCRIBE `ports` 0.0030300617218018
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00070500373840332
(158) DESCRIBE `ports` 0.0029380321502686
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00057506561279297
(160) DESCRIBE `ports` 0.0029819011688232
(161) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00069999694824219
(162) DESCRIBE `ports` 0.0026378631591797
(163) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00056815147399902
(164) DESCRIBE `ports` 0.002924919128418
(165) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 156))) 0.00071597099304199
(166) DESCRIBE `ports` 0.0030500888824463
(167) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '156') 0.00063610076904297
(168) DESCRIBE `ports` 0.0028519630432129
(169) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.0007469654083252
(170) DESCRIBE `ports` 0.0031390190124512
(171) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00059890747070312
(172) DESCRIBE `ports` 0.0030150413513184
(173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00069308280944824
(174) DESCRIBE `ports` 0.0030159950256348
(175) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00064396858215332
(176) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '82124') AND (sailingdate >= '2020-01-01') 0.012814044952393
(177) DESCRIBE `avid_specials` 0.0027809143066406
(178) 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.0027930736541748
(179) DESCRIBE `cruiselines` 0.0044898986816406
(180) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.000762939453125
(181) DESCRIBE `orchid_image` 0.0033559799194336
(182) DESCRIBE `cruiselines` 0.0043079853057861
(183) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00072598457336426
(184) DESCRIBE `cruises` 0.0056540966033936
(185) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82125') 0.00076198577880859
(186) DESCRIBE `ships` 0.0060279369354248
(187) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1013))) 0.0009300708770752
(188) DESCRIBE `ships` 0.0057849884033203
(189) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1013') 0.00075292587280273
(190) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00051403045654297
(191) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0005190372467041
(192) DESCRIBE `itineraries` 0.0028340816497803
(193) DESCRIBE `ports` 0.002953052520752
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00068306922912598
(195) DESCRIBE `ports` 0.0029041767120361
(196) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00063490867614746
(197) DESCRIBE `ports` 0.0028548240661621
(198) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00062918663024902
(199) DESCRIBE `sailingdates` 0.0024039745330811
(200) DESCRIBE `ports` 0.002673864364624
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00065803527832031
(202) DESCRIBE `ports` 0.0027370452880859
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00057506561279297
(204) DESCRIBE `ports` 0.0030820369720459
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.0007789134979248
(206) DESCRIBE `ports` 0.0029318332672119
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00065898895263672
(208) DESCRIBE `ports` 0.0033500194549561
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00083088874816895
(210) DESCRIBE `ports` 0.0028250217437744
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00060892105102539
(212) DESCRIBE `ports` 0.0026841163635254
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00079703330993652
(214) DESCRIBE `ports` 0.0027968883514404
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00064396858215332
(216) DESCRIBE `ports` 0.0027880668640137
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00064396858215332
(218) DESCRIBE `ports` 0.0025749206542969
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00063395500183105
(220) DESCRIBE `ports` 0.0027129650115967
(221) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00064992904663086
(222) DESCRIBE `ports` 0.0027880668640137
(223) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00057196617126465
(224) DESCRIBE `ports` 0.0028071403503418
(225) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4585))) 0.00063395500183105
(226) DESCRIBE `ports` 0.0031390190124512
(227) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4585') 0.00067019462585449
(228) DESCRIBE `ports` 0.0028011798858643
(229) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00062799453735352
(230) DESCRIBE `ports` 0.0027520656585693
(231) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00085616111755371
(232) DESCRIBE `ports` 0.0033328533172607
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00074505805969238
(234) DESCRIBE `ports` 0.0022709369659424
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00049686431884766
(236) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '82125') AND (sailingdate >= '2020-01-01') 0.005418062210083
(237) DESCRIBE `avid_specials` 0.0020079612731934
(238) 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.001446008682251
(239) DESCRIBE `cruiselines` 0.0031208992004395
(240) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00051283836364746
(241) DESCRIBE `orchid_image` 0.0021719932556152
(242) DESCRIBE `cruiselines` 0.0034091472625732
(243) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.0005650520324707
(244) DESCRIBE `cruises` 0.0061109066009521
(245) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82171') 0.0013730525970459
(246) DESCRIBE `ships` 0.0060648918151855
(247) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1013))) 0.0011022090911865
(248) DESCRIBE `ships` 0.0057051181793213
(249) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1013') 0.00062799453735352
(250) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00040006637573242
(251) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0004270076751709
(252) DESCRIBE `itineraries` 0.0022251605987549
(253) DESCRIBE `ports` 0.0032730102539062
(254) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00097894668579102
(255) DESCRIBE `ports` 0.0033180713653564
(256) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.0010230541229248
(257) DESCRIBE `ports` 0.0031578540802002
(258) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00063705444335938
(259) DESCRIBE `sailingdates` 0.0026631355285645
(260) DESCRIBE `ports` 0.0036699771881104
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00073409080505371
(262) DESCRIBE `ports` 0.0029759407043457
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00064301490783691
(264) DESCRIBE `ports` 0.0026869773864746
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00079512596130371
(266) DESCRIBE `ports` 0.0029799938201904
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00082612037658691
(268) DESCRIBE `ports` 0.0030560493469238
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6129))) 0.00065398216247559
(270) DESCRIBE `ports` 0.0027108192443848
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6129') 0.00068902969360352
(272) DESCRIBE `ports` 0.0027849674224854
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.0007481575012207
(274) DESCRIBE `ports` 0.0029840469360352
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00063109397888184
(276) DESCRIBE `ports` 0.0029771327972412
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00083613395690918
(278) DESCRIBE `ports` 0.0061261653900146
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.0032949447631836
(280) DESCRIBE `ports` 0.0033860206604004
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 156))) 0.00087118148803711
(282) DESCRIBE `ports` 0.0029659271240234
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '156') 0.00066184997558594
(284) DESCRIBE `ports` 0.0030040740966797
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.0094699859619141
(286) DESCRIBE `ports` 0.0040271282196045
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00066089630126953
(288) DESCRIBE `ports` 0.0028491020202637
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00067687034606934
(290) DESCRIBE `ports` 0.0029458999633789
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00065803527832031
(292) DESCRIBE `ports` 0.0028598308563232
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.000701904296875
(294) DESCRIBE `ports` 0.0030438899993896
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00086307525634766
(296) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '82171') AND (sailingdate >= '2020-01-01') 0.0094978809356689
(297) DESCRIBE `avid_specials` 0.0026781558990479
(298) 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.0029609203338623
(299) DESCRIBE `cruiselines` 0.0042440891265869
(300) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00091290473937988
(301) DESCRIBE `orchid_image` 0.0033960342407227
(302) DESCRIBE `cruiselines` 0.0037679672241211
(303) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.0007331371307373
(304) DESCRIBE `cruises` 0.0054430961608887
(305) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68831') 0.00069904327392578
(306) DESCRIBE `ships` 0.0057919025421143
(307) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1013))) 0.0013220310211182
(308) DESCRIBE `ships` 0.0056929588317871
(309) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1013') 0.00080299377441406
(310) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00054097175598145
(311) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00055217742919922
(312) DESCRIBE `itineraries` 0.0027420520782471
(313) DESCRIBE `ports` 0.0030069351196289
(314) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00081086158752441
(315) DESCRIBE `ports` 0.0027499198913574
(316) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00085210800170898
(317) DESCRIBE `ports` 0.0031061172485352
(318) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00061202049255371
(319) DESCRIBE `sailingdates` 0.0024230480194092
(320) DESCRIBE `ports` 0.0031161308288574
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00066304206848145
(322) DESCRIBE `ports` 0.0021898746490479
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00068092346191406
(324) DESCRIBE `ports` 0.0027189254760742
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00068902969360352
(326) DESCRIBE `ports` 0.0028390884399414
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00061607360839844
(328) DESCRIBE `ports` 0.0028970241546631
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00072097778320312
(330) DESCRIBE `ports` 0.0027949810028076
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00061583518981934
(332) DESCRIBE `ports` 0.002979040145874
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00065708160400391
(334) DESCRIBE `ports` 0.0026171207427979
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.0006098747253418
(336) DESCRIBE `ports` 0.0027320384979248
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00068187713623047
(338) DESCRIBE `ports` 0.002532958984375
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00080609321594238
(340) DESCRIBE `ports` 0.0029449462890625
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00070095062255859
(342) DESCRIBE `ports` 0.0028188228607178
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00075197219848633
(344) DESCRIBE `ports` 0.0023961067199707
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4585))) 0.0007021427154541
(346) DESCRIBE `ports` 0.0025970935821533
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4585') 0.00055098533630371
(348) DESCRIBE `ports` 0.0026760101318359
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00060081481933594
(350) DESCRIBE `ports` 0.0026731491088867
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00046992301940918
(352) DESCRIBE `ports` 0.0025250911712646
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.0006258487701416
(354) DESCRIBE `ports` 0.0027389526367188
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00079107284545898
(356) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '68831') AND (sailingdate >= '2020-01-01') 0.0097010135650635
(357) DESCRIBE `avid_specials` 0.0028731822967529
(358) 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.0024070739746094
(359) DESCRIBE `cruiselines` 0.0041978359222412
(360) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00082707405090332
(361) DESCRIBE `orchid_image` 0.0033359527587891
(362) DESCRIBE `cruiselines` 0.0046799182891846
(363) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00078797340393066
(364) DESCRIBE `cruises` 0.0058329105377197
(365) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82064') 0.00078105926513672
(366) DESCRIBE `ships` 0.0059099197387695
(367) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1526))) 0.0015220642089844
(368) DESCRIBE `ships` 0.0061519145965576
(369) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1526') 0.00081586837768555
(370) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00047707557678223
(371) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0005030632019043
(372) DESCRIBE `itineraries` 0.0028340816497803
(373) DESCRIBE `ports` 0.0032138824462891
(374) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00077295303344727
(375) DESCRIBE `ports` 0.0030741691589355
(376) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00076198577880859
(377) DESCRIBE `ports` 0.0028970241546631
(378) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00071001052856445
(379) DESCRIBE `sailingdates` 0.0025520324707031
(380) DESCRIBE `ports` 0.0029549598693848
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00070810317993164
(382) DESCRIBE `ports` 0.0028269290924072
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00057816505432129
(384) DESCRIBE `ports` 0.0028030872344971
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00061988830566406
(386) DESCRIBE `ports` 0.0028719902038574
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00061798095703125
(388) DESCRIBE `ports` 0.0027978420257568
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00099897384643555
(390) DESCRIBE `ports` 0.0026180744171143
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00063991546630859
(392) DESCRIBE `ports` 0.0035281181335449
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00084495544433594
(394) DESCRIBE `ports` 0.0031909942626953
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00069499015808105
(396) DESCRIBE `ports` 0.0030710697174072
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00085711479187012
(398) DESCRIBE `ports` 0.0029900074005127
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00070309638977051
(400) DESCRIBE `ports` 0.0029668807983398
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00073599815368652
(402) DESCRIBE `ports` 0.003140926361084
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00072383880615234
(404) DESCRIBE `ports` 0.0031290054321289
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 156))) 0.00072908401489258
(406) DESCRIBE `ports` 0.0029439926147461
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '156') 0.00072693824768066
(408) DESCRIBE `ports` 0.0030579566955566
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00072002410888672
(410) DESCRIBE `ports` 0.0026271343231201
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00070095062255859
(412) DESCRIBE `ports` 0.0026769638061523
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00063800811767578
(414) DESCRIBE `ports` 0.0028369426727295
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00058603286743164
(416) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '82064') AND (sailingdate >= '2020-01-01') 0.0088670253753662
(417) DESCRIBE `avid_specials` 0.0025801658630371
(418) 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.0020639896392822
(419) DESCRIBE `cruiselines` 0.0039157867431641
(420) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00080704689025879
(421) DESCRIBE `orchid_image` 0.0032510757446289
(422) DESCRIBE `cruiselines` 0.0040018558502197
(423) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.0006260871887207
(424) DESCRIBE `cruises` 0.0049769878387451
(425) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82123') 0.00072789192199707
(426) DESCRIBE `ships` 0.0056819915771484
(427) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1163))) 0.00088882446289062
(428) DESCRIBE `ships` 0.0053660869598389
(429) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1163') 0.00068902969360352
(430) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00050497055053711
(431) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00049710273742676
(432) DESCRIBE `itineraries` 0.0027079582214355
(433) DESCRIBE `ports` 0.0026519298553467
(434) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.00065898895263672
(435) DESCRIBE `ports` 0.0025699138641357
(436) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.00067305564880371
(437) DESCRIBE `ports` 0.0025660991668701
(438) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4804') 0.00081181526184082
(439) DESCRIBE `sailingdates` 0.0026609897613525
(440) DESCRIBE `ports` 0.003565788269043
(441) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.00090312957763672
(442) DESCRIBE `ports` 0.0034940242767334
(443) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4804') 0.00071907043457031
(444) DESCRIBE `ports` 0.0031859874725342
(445) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.00070905685424805
(446) DESCRIBE `ports` 0.0026869773864746
(447) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4804') 0.00063610076904297
(448) DESCRIBE `ports` 0.0030961036682129
(449) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1229))) 0.0007321834564209
(450) DESCRIBE `ports` 0.0031058788299561
(451) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1229') 0.00071096420288086
(452) DESCRIBE `ports` 0.0034217834472656
(453) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3828))) 0.00088906288146973
(454) DESCRIBE `ports` 0.021986961364746
(455) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3828') 0.0015358924865723
(456) DESCRIBE `ports` 0.003795862197876
(457) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3829))) 0.00075411796569824
(458) DESCRIBE `ports` 0.002579927444458
(459) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3829') 0.00053191184997559
(460) DESCRIBE `ports` 0.0030369758605957
(461) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00081896781921387
(462) DESCRIBE `ports` 0.0033450126647949
(463) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00072002410888672
(464) DESCRIBE `ports` 0.003119945526123
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4821))) 0.0010449886322021
(466) DESCRIBE `ports` 0.0031270980834961
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4821') 0.0007319450378418
(468) DESCRIBE `ports` 0.0027840137481689
(469) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3036))) 0.00064516067504883
(470) DESCRIBE `ports` 0.0029690265655518
(471) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3036') 0.00068092346191406
(472) DESCRIBE `ports` 0.0042798519134521
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4687))) 0.00071191787719727
(474) DESCRIBE `ports` 0.0027110576629639
(475) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4687') 0.0006110668182373
(476) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '82123') AND (sailingdate >= '2020-01-01') 0.010596036911011
(477) DESCRIBE `avid_specials` 0.0033290386199951
(478) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 82123 and class = 'Cruise') OR (item_id = 1163 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.0033819675445557
(479) DESCRIBE `cruiselines` 0.0054769515991211
(480) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00097894668579102
(481) DESCRIBE `orchid_image` 0.0036571025848389
(482) DESCRIBE `cruiselines` 0.0047459602355957
(483) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00068998336791992
(484) DESCRIBE `cruises` 0.0053238868713379
(485) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82126') 0.00072813034057617
(486) DESCRIBE `ships` 0.0059778690338135
(487) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1013))) 0.0012259483337402
(488) DESCRIBE `ships` 0.010428905487061
(489) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1013') 0.00075912475585938
(490) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00045108795166016
(491) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00070595741271973
(492) DESCRIBE `itineraries` 0.0038440227508545
(493) DESCRIBE `ports` 0.0034518241882324
(494) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00083088874816895
(495) DESCRIBE `ports` 0.0043849945068359
(496) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00087618827819824
(497) DESCRIBE `ports` 0.003148078918457
(498) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00085186958312988
(499) DESCRIBE `sailingdates` 0.0026910305023193
(500) DESCRIBE `ports` 0.0089387893676758
(501) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.0010600090026855
(502) DESCRIBE `ports` 0.0027499198913574
(503) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00063991546630859
(504) DESCRIBE `ports` 0.0026600360870361
(505) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00072097778320312
(506) DESCRIBE `ports` 0.0027520656585693
(507) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00075292587280273
(508) DESCRIBE `ports` 0.0028059482574463
(509) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4585))) 0.00079607963562012
(510) DESCRIBE `ports` 0.003058910369873
(511) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4585') 0.00071597099304199
(512) DESCRIBE `ports` 0.0026521682739258
(513) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00067901611328125
(514) DESCRIBE `ports` 0.0030369758605957
(515) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00063109397888184
(516) DESCRIBE `ports` 0.0029239654541016
(517) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00082802772521973
(518) DESCRIBE `ports` 0.0029480457305908
(519) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00059318542480469
(520) DESCRIBE `ports` 0.0027689933776855
(521) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 156))) 0.00046706199645996
(522) DESCRIBE `ports` 0.0020501613616943
(523) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '156') 0.00050687789916992
(524) DESCRIBE `ports` 0.002716064453125
(525) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00061702728271484
(526) DESCRIBE `ports` 0.0031678676605225
(527) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00066590309143066
(528) DESCRIBE `ports` 0.0030720233917236
(529) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00081110000610352
(530) DESCRIBE `ports` 0.0029339790344238
(531) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00065708160400391
(532) DESCRIBE `ports` 0.0029380321502686
(533) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00069689750671387
(534) DESCRIBE `ports` 0.0029468536376953
(535) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00079989433288574
(536) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '82126') AND (sailingdate >= '2020-01-01') 0.010349035263062
(537) DESCRIBE `avid_specials` 0.0032131671905518
(538) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 82126 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.0022199153900146
(539) DESCRIBE `cruiselines` 0.0037868022918701
(540) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00068497657775879
(541) DESCRIBE `orchid_image` 0.0030519962310791
(542) DESCRIBE `cruiselines` 0.004706859588623
(543) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00070905685424805
(544) DESCRIBE `cruises` 0.0058701038360596
(545) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '45864') 0.00074100494384766
(546) DESCRIBE `ships` 0.0055170059204102
(547) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1163))) 0.00083303451538086
(548) DESCRIBE `ships` 0.0052070617675781
(549) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1163') 0.00061607360839844
(550) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00043988227844238
(551) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00042986869812012
(552) DESCRIBE `itineraries` 0.0024027824401855
(553) DESCRIBE `ports` 0.0030720233917236
(554) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4687))) 0.00073909759521484
(555) DESCRIBE `ports` 0.0031228065490723
(556) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4687))) 0.00068807601928711
(557) DESCRIBE `ports` 0.0024092197418213
(558) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4687') 0.00088596343994141
(559) DESCRIBE `sailingdates` 0.0025839805603027
(560) DESCRIBE `ports` 0.0031089782714844
(561) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4687))) 0.00075292587280273
(562) DESCRIBE `ports` 0.0028719902038574
(563) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4687') 0.00082707405090332
(564) DESCRIBE `ports` 0.0028829574584961
(565) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3036))) 0.00077509880065918
(566) DESCRIBE `ports` 0.0034918785095215
(567) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3036') 0.00080394744873047
(568) DESCRIBE `ports` 0.0031940937042236
(569) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3036))) 0.00074100494384766
(570) DESCRIBE `ports` 0.0032041072845459
(571) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3036') 0.00069212913513184
(572) DESCRIBE `ports` 0.0032048225402832
(573) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4821))) 0.00076889991760254
(574) DESCRIBE `ports` 0.0032298564910889
(575) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4821') 0.0007779598236084
(576) DESCRIBE `ports` 0.0030689239501953
(577) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00072503089904785
(578) DESCRIBE `ports` 0.0028109550476074
(579) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00063204765319824
(580) DESCRIBE `ports` 0.0025179386138916
(581) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3828))) 0.00061988830566406
(582) DESCRIBE `ports` 0.0025491714477539
(583) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3828') 0.00059890747070312
(584) DESCRIBE `ports` 0.0028390884399414
(585) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3829))) 0.00063610076904297
(586) DESCRIBE `ports` 0.0024030208587646
(587) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3829') 0.0005190372467041
(588) DESCRIBE `ports` 0.0024349689483643
(589) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1229))) 0.00043606758117676
(590) DESCRIBE `ports` 0.0018789768218994
(591) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1229') 0.00050497055053711
(592) DESCRIBE `ports` 0.0021319389343262
(593) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.00044918060302734
(594) DESCRIBE `ports` 0.002377986907959
(595) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4804') 0.00045490264892578
(596) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '45864') AND (sailingdate >= '2020-01-01') 0.010712862014771
(597) DESCRIBE `avid_specials` 0.00288987159729
(598) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 45864 and class = 'Cruise') OR (item_id = 1163 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.0023560523986816
(599) DESCRIBE `cruiselines` 0.0037870407104492
(600) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.0006859302520752
(601) DESCRIBE `orchid_image` 0.0022270679473877
(602) DESCRIBE `cruiselines` 0.0029048919677734
(603) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00051593780517578
(604) DESCRIBE `ships` 0.0042259693145752
(605) SELECT `ships`.* FROM `ships` WHERE (id IN ('1526', '1013', '1163', '1791')) ORDER BY FIND_IN_SET(id, '1526,1013,1163,1791') 0.0020320415496826
(606) DESCRIBE `cruisetypes` 0.0024631023406982
(607) DESCRIBE `destinations` 0.0025968551635742
(608) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('39', '34')) ORDER BY FIND_IN_SET(id, '39,34') 0.00073695182800293
(609) DESCRIBE `cruiselines` 0.0029809474945068
(610) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00053691864013672
(611) DESCRIBE `cruiselines` 0.0031919479370117
(612) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00063490867614746