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

Total elapsed time: 2.9667477607727

# Query Time
(1) connect 0.18984699249268
(2) DESCRIBE `cruises` 0.0060079097747803
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (72903, 72876, 72837, 72812, 72900, 72933, 72859, 66202, 72898, 72853)) ORDER BY FIND_IN_SET(id, '72903,72876,72837,72812,72900,72933,72859,66202,72898,72853') 0.0031929016113281
(4) DESCRIBE `cruises` 0.032788991928101
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72903') 0.012235879898071
(6) DESCRIBE `ships` 0.058418989181519
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1319))) 0.0010318756103516
(8) DESCRIBE `ships` 0.078951120376587
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1319') 0.01338791847229
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00054216384887695
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00051307678222656
(12) DESCRIBE `itineraries` 0.0088479518890381
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '72903') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.011790037155151
(14) DESCRIBE `ports` 0.0038459300994873
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0028600692749023
(16) DESCRIBE `ports` 0.012979030609131
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0042080879211426
(18) DESCRIBE `ports` 0.0051460266113281
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.0083680152893066
(20) DESCRIBE `sailingdates` 0.0052189826965332
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '72903') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.015208959579468
(22) DESCRIBE `ports` 0.0037369728088379
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0035920143127441
(24) DESCRIBE `ports` 0.034723997116089
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.0022048950195312
(26) DESCRIBE `ports` 0.0075907707214355
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.0072870254516602
(28) DESCRIBE `ports` 0.016357183456421
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00360107421875
(30) DESCRIBE `ports` 0.0037879943847656
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2405))) 0.0045878887176514
(32) DESCRIBE `ports` 0.0093610286712646
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2405') 0.0044379234313965
(34) DESCRIBE `ports` 0.0061748027801514
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.012104034423828
(36) DESCRIBE `ports` 0.0029220581054688
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.011938095092773
(38) DESCRIBE `ports` 0.0069458484649658
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1198))) 0.02655291557312
(40) DESCRIBE `ports` 0.015551090240479
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1198') 0.00065207481384277
(42) DESCRIBE `ports` 0.002769947052002
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.017239093780518
(44) DESCRIBE `ports` 0.0024731159210205
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.0076179504394531
(46) DESCRIBE `ports` 0.011017084121704
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00071001052856445
(48) DESCRIBE `ports` 0.0044350624084473
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.0090258121490479
(50) DESCRIBE `ports` 0.0054259300231934
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.013510942459106
(52) DESCRIBE `ports` 0.0055129528045654
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.021507978439331
(54) DESCRIBE `ports` 0.026399850845337
(55) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0079178810119629
(56) DESCRIBE `ports` 0.0035839080810547
(57) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00075292587280273
(58) DESCRIBE `ports` 0.0048880577087402
(59) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0007469654083252
(60) DESCRIBE `ports` 0.0032119750976562
(61) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0012350082397461
(62) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '72903') AND (sailingdate >= '2019-03-19') 0.025156021118164
(63) DESCRIBE `avid_specials` 0.002554178237915
(64) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72903 and class = 'Cruise') OR (item_id = 1319 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0025060176849365
(65) DESCRIBE `cruiselines` 0.0037939548492432
(66) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00072097778320312
(67) DESCRIBE `orchid_image` 0.0029971599578857
(68) DESCRIBE `cruiselines` 0.0038299560546875
(69) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00064992904663086
(70) DESCRIBE `cruises` 0.0052170753479004
(71) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72876') 0.0016298294067383
(72) DESCRIBE `ships` 0.0083858966827393
(73) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 508))) 0.01337718963623
(74) DESCRIBE `ships` 0.017908096313477
(75) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '508') 0.00077199935913086
(76) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00063109397888184
(77) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00049901008605957
(78) DESCRIBE `itineraries` 0.0040218830108643
(79) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '72876') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0013041496276855
(80) DESCRIBE `ports` 0.0029540061950684
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00074195861816406
(82) DESCRIBE `ports` 0.0026209354400635
(83) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.0015618801116943
(84) DESCRIBE `ports` 0.0053119659423828
(85) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00070905685424805
(86) DESCRIBE `sailingdates` 0.0027570724487305
(87) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '72876') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0014300346374512
(88) DESCRIBE `ports` 0.0026850700378418
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00070905685424805
(90) DESCRIBE `ports` 0.002601146697998
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00057601928710938
(92) DESCRIBE `ports` 0.002622127532959
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 517))) 0.00060915946960449
(94) DESCRIBE `ports` 0.0025639533996582
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '517') 0.00055193901062012
(96) DESCRIBE `ports` 0.0027310848236084
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 642))) 0.00089287757873535
(98) DESCRIBE `ports` 0.0033779144287109
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '642') 0.00063800811767578
(100) DESCRIBE `ports` 0.0029799938201904
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00084495544433594
(102) DESCRIBE `ports` 0.0029630661010742
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00045895576477051
(104) DESCRIBE `ports` 0.0026819705963135
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00060701370239258
(106) DESCRIBE `ports` 0.0027430057525635
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00060009956359863
(108) DESCRIBE `ports` 0.0025320053100586
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00058102607727051
(110) DESCRIBE `ports` 0.0027091503143311
(111) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00059700012207031
(112) DESCRIBE `ports` 0.0028369426727295
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.0006718635559082
(114) DESCRIBE `ports` 0.0029149055480957
(115) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00066399574279785
(116) DESCRIBE `ports` 0.0029470920562744
(117) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00075197219848633
(118) DESCRIBE `ports` 0.0028469562530518
(119) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00069403648376465
(120) DESCRIBE `ports` 0.002938985824585
(121) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1703))) 0.00067996978759766
(122) DESCRIBE `ports` 0.0027780532836914
(123) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1703') 0.00062704086303711
(124) DESCRIBE `ports` 0.0025150775909424
(125) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 452))) 0.00069594383239746
(126) DESCRIBE `ports` 0.0024769306182861
(127) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '452') 0.00059008598327637
(128) DESCRIBE `ports` 0.0024280548095703
(129) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00066208839416504
(130) DESCRIBE `ports` 0.0030269622802734
(131) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00072598457336426
(132) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '72876') AND (sailingdate >= '2019-03-19') 0.0097188949584961
(133) DESCRIBE `avid_specials` 0.0070359706878662
(134) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72876 and class = 'Cruise') OR (item_id = 508 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 49 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.0042250156402588
(135) DESCRIBE `cruiselines` 0.0037591457366943
(136) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00065708160400391
(137) DESCRIBE `orchid_image` 0.0060698986053467
(138) DESCRIBE `cruiselines` 0.004364013671875
(139) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.0012340545654297
(140) DESCRIBE `cruises` 0.0050618648529053
(141) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72837') 0.00078201293945312
(142) DESCRIBE `ships` 0.0067310333251953
(143) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 850))) 0.00098085403442383
(144) DESCRIBE `ships` 0.011631011962891
(145) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '850') 0.00076889991760254
(146) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00049400329589844
(147) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00069785118103027
(148) DESCRIBE `itineraries` 0.0034999847412109
(149) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '72837') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0011870861053467
(150) DESCRIBE `ports` 0.0034971237182617
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.0029280185699463
(152) DESCRIBE `ports` 0.0043280124664307
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00084400177001953
(154) DESCRIBE `ports` 0.0035841464996338
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00066494941711426
(156) DESCRIBE `sailingdates` 0.004443883895874
(157) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '72837') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0010890960693359
(158) DESCRIBE `ports` 0.0042800903320312
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00069999694824219
(160) DESCRIBE `ports` 0.0027849674224854
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00070285797119141
(162) DESCRIBE `ports` 0.0028858184814453
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00076389312744141
(164) DESCRIBE `ports` 0.002830982208252
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.0008080005645752
(166) DESCRIBE `ports` 0.0030720233917236
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00066900253295898
(168) DESCRIBE `ports` 0.0029520988464355
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00070309638977051
(170) DESCRIBE `ports` 0.0030200481414795
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00067305564880371
(172) DESCRIBE `ports` 0.002964973449707
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00070095062255859
(174) DESCRIBE `ports` 0.0026769638061523
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00063991546630859
(176) DESCRIBE `ports` 0.0027251243591309
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00078821182250977
(178) DESCRIBE `ports` 0.0028750896453857
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 518))) 0.00084090232849121
(180) DESCRIBE `ports` 0.0028510093688965
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '518') 0.00059986114501953
(182) DESCRIBE `ports` 0.0025920867919922
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1703))) 0.0006558895111084
(184) DESCRIBE `ports` 0.0026509761810303
(185) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1703') 0.00057411193847656
(186) DESCRIBE `ports` 0.0035109519958496
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 452))) 0.001021146774292
(188) DESCRIBE `ports` 0.0028998851776123
(189) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '452') 0.0006558895111084
(190) DESCRIBE `ports` 0.0032439231872559
(191) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00066685676574707
(192) DESCRIBE `ports` 0.0027661323547363
(193) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00063800811767578
(194) DESCRIBE `ports` 0.0026071071624756
(195) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00090312957763672
(196) DESCRIBE `ports` 0.0028538703918457
(197) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00071811676025391
(198) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '72837') AND (sailingdate >= '2019-03-19') 0.010023832321167
(199) DESCRIBE `avid_specials` 0.0027828216552734
(200) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72837 and class = 'Cruise') OR (item_id = 850 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 26 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0026869773864746
(201) DESCRIBE `cruiselines` 0.0061359405517578
(202) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.0007929801940918
(203) DESCRIBE `orchid_image` 0.0027809143066406
(204) DESCRIBE `cruiselines` 0.004209041595459
(205) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.0009918212890625
(206) DESCRIBE `cruises` 0.0050809383392334
(207) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72812') 0.00089097023010254
(208) DESCRIBE `ships` 0.005540132522583
(209) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1108))) 0.00083184242248535
(210) DESCRIBE `ships` 0.0051450729370117
(211) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1108') 0.0007929801940918
(212) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00064802169799805
(213) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0005030632019043
(214) DESCRIBE `itineraries` 0.0029568672180176
(215) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '72812') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0011699199676514
(216) DESCRIBE `ports` 0.0033960342407227
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00088191032409668
(218) DESCRIBE `ports` 0.0032260417938232
(219) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00088191032409668
(220) DESCRIBE `ports` 0.0032131671905518
(221) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00073003768920898
(222) DESCRIBE `sailingdates` 0.0025730133056641
(223) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '72812') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0011289119720459
(224) DESCRIBE `ports` 0.0031528472900391
(225) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00074100494384766
(226) DESCRIBE `ports` 0.0033340454101562
(227) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00069093704223633
(228) DESCRIBE `ports` 0.0031189918518066
(229) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 364))) 0.00076198577880859
(230) DESCRIBE `ports` 0.0030839443206787
(231) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '364') 0.00071406364440918
(232) DESCRIBE `ports` 0.0030879974365234
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 364))) 0.00077009201049805
(234) DESCRIBE `ports` 0.0029778480529785
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '364') 0.00062704086303711
(236) DESCRIBE `ports` 0.0029060840606689
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 364))) 0.00082302093505859
(238) DESCRIBE `ports` 0.0030689239501953
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '364') 0.00055599212646484
(240) DESCRIBE `ports` 0.0027210712432861
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 363))) 0.00096511840820312
(242) DESCRIBE `ports` 0.003136157989502
(243) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '363') 0.00069284439086914
(244) DESCRIBE `ports` 0.0031359195709229
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 363))) 0.00075507164001465
(246) DESCRIBE `ports` 0.0031259059906006
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '363') 0.00090789794921875
(248) DESCRIBE `ports` 0.0029869079589844
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00086092948913574
(250) DESCRIBE `ports` 0.0030121803283691
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00075912475585938
(252) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '72812') AND (sailingdate >= '2019-03-19') 0.0098090171813965
(253) DESCRIBE `avid_specials` 0.0028350353240967
(254) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72812 and class = 'Cruise') OR (item_id = 1108 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 10 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.0069098472595215
(255) DESCRIBE `cruiselines` 0.010843992233276
(256) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00083088874816895
(257) DESCRIBE `orchid_image` 0.0034198760986328
(258) DESCRIBE `cruiselines` 0.004086971282959
(259) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.0006561279296875
(260) DESCRIBE `cruises` 0.0071430206298828
(261) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72900') 0.0011410713195801
(262) DESCRIBE `ships` 0.0066800117492676
(263) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 394))) 0.00086283683776855
(264) DESCRIBE `ships` 0.0078940391540527
(265) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '394') 0.0014331340789795
(266) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0012509822845459
(267) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00059413909912109
(268) DESCRIBE `itineraries` 0.0026681423187256
(269) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '72900') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0010149478912354
(270) DESCRIBE `ports` 0.0029370784759521
(271) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00072598457336426
(272) DESCRIBE `ports` 0.0028648376464844
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00081801414489746
(274) DESCRIBE `ports` 0.0034399032592773
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00094485282897949
(276) DESCRIBE `sailingdates` 0.0043981075286865
(277) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '72900') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0011739730834961
(278) DESCRIBE `ports` 0.0054209232330322
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00087618827819824
(280) DESCRIBE `ports` 0.0029129981994629
(281) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00092887878417969
(282) DESCRIBE `ports` 0.0029170513153076
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00098991394042969
(284) DESCRIBE `ports` 0.0046839714050293
(285) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00074911117553711
(286) DESCRIBE `ports` 0.0036139488220215
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.0037369728088379
(288) DESCRIBE `ports` 0.0034739971160889
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00072598457336426
(290) DESCRIBE `ports` 0.0033068656921387
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00073790550231934
(292) DESCRIBE `ports` 0.0029010772705078
(293) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00060296058654785
(294) DESCRIBE `ports` 0.0024089813232422
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 553))) 0.00087094306945801
(296) DESCRIBE `ports` 0.0023510456085205
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '553') 0.00059700012207031
(298) DESCRIBE `ports` 0.0037801265716553
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 295))) 0.00065207481384277
(300) DESCRIBE `ports` 0.0058670043945312
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '295') 0.00077509880065918
(302) DESCRIBE `ports` 0.0046849250793457
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 29))) 0.0018260478973389
(304) DESCRIBE `ports` 0.01086688041687
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '29') 0.00064897537231445
(306) DESCRIBE `ports` 0.0031049251556396
(307) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00081801414489746
(308) DESCRIBE `ports` 0.0030210018157959
(309) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00068497657775879
(310) DESCRIBE `ports` 0.0028259754180908
(311) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 112))) 0.0010600090026855
(312) DESCRIBE `ports` 0.0032260417938232
(313) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '112') 0.001121997833252
(314) DESCRIBE `ports` 0.0032780170440674
(315) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.0045809745788574
(316) DESCRIBE `ports` 0.0045099258422852
(317) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00093197822570801
(318) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '72900') AND (sailingdate >= '2019-03-19') 0.0085339546203613
(319) DESCRIBE `avid_specials` 0.0074830055236816
(320) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72900 and class = 'Cruise') OR (item_id = 394 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 2 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.0034360885620117
(321) DESCRIBE `cruiselines` 0.0048520565032959
(322) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.0010011196136475
(323) DESCRIBE `orchid_image` 0.0039160251617432
(324) DESCRIBE `cruiselines` 0.0076408386230469
(325) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00062704086303711
(326) DESCRIBE `cruises` 0.0090129375457764
(327) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72933') 0.0010120868682861
(328) DESCRIBE `ships` 0.010113000869751
(329) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 966))) 0.00096583366394043
(330) DESCRIBE `ships` 0.005871057510376
(331) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '966') 0.00078988075256348
(332) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00055217742919922
(333) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00055909156799316
(334) DESCRIBE `itineraries` 0.0030360221862793
(335) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '72933') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0040559768676758
(336) DESCRIBE `ports` 0.0088660717010498
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.0011050701141357
(338) DESCRIBE `ports` 0.0048820972442627
(339) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00074601173400879
(340) DESCRIBE `ports` 0.0080838203430176
(341) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.0029361248016357
(342) DESCRIBE `sailingdates` 0.007904052734375
(343) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '72933') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.001194953918457
(344) DESCRIBE `ports` 0.003122091293335
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.0019769668579102
(346) DESCRIBE `ports` 0.0052990913391113
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00085186958312988
(348) DESCRIBE `ports` 0.0070741176605225
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 517))) 0.011229038238525
(350) DESCRIBE `ports` 0.0036661624908447
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '517') 0.0006558895111084
(352) DESCRIBE `ports` 0.0039470195770264
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.0012609958648682
(354) DESCRIBE `ports` 0.0063419342041016
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.00074601173400879
(356) DESCRIBE `ports` 0.0060999393463135
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00095295906066895
(358) DESCRIBE `ports` 0.0027081966400146
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00066804885864258
(360) DESCRIBE `ports` 0.0033011436462402
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2126))) 0.0010590553283691
(362) DESCRIBE `ports` 0.0057270526885986
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2126') 0.00075602531433105
(364) DESCRIBE `ports` 0.0063421726226807
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 220))) 0.00079011917114258
(366) DESCRIBE `ports` 0.0037848949432373
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '220') 0.00069189071655273
(368) DESCRIBE `ports` 0.0029020309448242
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 574))) 0.00077104568481445
(370) DESCRIBE `ports` 0.002830982208252
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '574') 0.00060319900512695
(372) DESCRIBE `ports` 0.0024900436401367
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00064516067504883
(374) DESCRIBE `ports` 0.002960205078125
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00069713592529297
(376) DESCRIBE `ports` 0.0028769969940186
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 754))) 0.00070905685424805
(378) DESCRIBE `ports` 0.0032351016998291
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '754') 0.00066590309143066
(380) DESCRIBE `ports` 0.0027050971984863
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 755))) 0.0007169246673584
(382) DESCRIBE `ports` 0.0035052299499512
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '755') 0.0015039443969727
(384) DESCRIBE `ports` 0.0040900707244873
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 572))) 0.0037028789520264
(386) DESCRIBE `ports` 0.0053901672363281
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '572') 0.00074219703674316
(388) DESCRIBE `ports` 0.0048480033874512
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 229))) 0.0024318695068359
(390) DESCRIBE `ports` 0.0052950382232666
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '229') 0.00068998336791992
(392) DESCRIBE `ports` 0.0031030178070068
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 229))) 0.0014479160308838
(394) DESCRIBE `ports` 0.0031521320343018
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '229') 0.00071191787719727
(396) DESCRIBE `ports` 0.0029950141906738
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 229))) 0.0010850429534912
(398) DESCRIBE `ports` 0.013504981994629
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '229') 0.0015461444854736
(400) DESCRIBE `ports` 0.0069990158081055
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 785))) 0.00083398818969727
(402) DESCRIBE `ports` 0.004033088684082
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '785') 0.00082015991210938
(404) DESCRIBE `ports` 0.0068488121032715
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2108))) 0.00095701217651367
(406) DESCRIBE `ports` 0.0033948421478271
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2108') 0.00068902969360352
(408) DESCRIBE `ports` 0.0037500858306885
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2412))) 0.00068998336791992
(410) DESCRIBE `ports` 0.0034329891204834
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2412') 0.00070691108703613
(412) DESCRIBE `ports` 0.004594087600708
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1936))) 0.00076103210449219
(414) DESCRIBE `ports` 0.0069360733032227
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1936') 0.0010068416595459
(416) DESCRIBE `ports` 0.0045468807220459
(417) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1706))) 0.00095605850219727
(418) DESCRIBE `ports` 0.0032269954681396
(419) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1706') 0.00093221664428711
(420) DESCRIBE `ports` 0.0039339065551758
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 117))) 0.00077104568481445
(422) DESCRIBE `ports` 0.0028631687164307
(423) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '117') 0.00078582763671875
(424) DESCRIBE `ports` 0.0039458274841309
(425) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) 0.0012331008911133
(426) DESCRIBE `ports` 0.0033209323883057
(427) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') 0.00073003768920898
(428) DESCRIBE `ports` 0.0028049945831299
(429) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 333))) 0.00070714950561523
(430) DESCRIBE `ports` 0.0028359889984131
(431) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '333') 0.00058698654174805
(432) DESCRIBE `ports` 0.0025720596313477
(433) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 119))) 0.00060796737670898
(434) DESCRIBE `ports` 0.0027279853820801
(435) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '119') 0.00065112113952637
(436) DESCRIBE `ports` 0.0028078556060791
(437) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00070309638977051
(438) DESCRIBE `ports` 0.0027070045471191
(439) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00059700012207031
(440) DESCRIBE `ports` 0.0026350021362305
(441) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00063085556030273
(442) DESCRIBE `ports` 0.0027430057525635
(443) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00070881843566895
(444) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '72933') AND (sailingdate >= '2019-03-19') 0.010389804840088
(445) DESCRIBE `avid_specials` 0.0029070377349854
(446) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72933 and class = 'Cruise') OR (item_id = 966 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 49 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.0021967887878418
(447) DESCRIBE `cruiselines` 0.0037178993225098
(448) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00068283081054688
(449) DESCRIBE `orchid_image` 0.0030651092529297
(450) DESCRIBE `cruiselines` 0.0038371086120605
(451) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00072884559631348
(452) DESCRIBE `cruises` 0.0054419040679932
(453) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72859') 0.0007941722869873
(454) DESCRIBE `ships` 0.0058920383453369
(455) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 966))) 0.0010490417480469
(456) DESCRIBE `ships` 0.0061218738555908
(457) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '966') 0.00075006484985352
(458) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00075387954711914
(459) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0030779838562012
(460) DESCRIBE `itineraries` 0.0041790008544922
(461) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '72859') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0015630722045898
(462) DESCRIBE `ports` 0.0036599636077881
(463) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.0048890113830566
(464) DESCRIBE `ports` 0.0046858787536621
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00080204010009766
(466) DESCRIBE `ports` 0.0029220581054688
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00069808959960938
(468) DESCRIBE `sailingdates` 0.0028419494628906
(469) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '72859') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0011179447174072
(470) DESCRIBE `ports` 0.002716064453125
(471) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.0015890598297119
(472) DESCRIBE `ports` 0.0033609867095947
(473) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00075697898864746
(474) DESCRIBE `ports` 0.0069079399108887
(475) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 517))) 0.0018711090087891
(476) DESCRIBE `ports` 0.013147830963135
(477) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '517') 0.00071287155151367
(478) DESCRIBE `ports` 0.0029280185699463
(479) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.00075507164001465
(480) DESCRIBE `ports` 0.0028238296508789
(481) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.00065898895263672
(482) DESCRIBE `ports` 0.0029079914093018
(483) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00075602531433105
(484) DESCRIBE `ports` 0.0049779415130615
(485) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.0023150444030762
(486) DESCRIBE `ports` 0.0034511089324951
(487) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2126))) 0.0010619163513184
(488) DESCRIBE `ports` 0.003385066986084
(489) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2126') 0.00081396102905273
(490) DESCRIBE `ports` 0.0051810741424561
(491) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 220))) 0.00084996223449707
(492) DESCRIBE `ports` 0.0029759407043457
(493) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '220') 0.0015690326690674
(494) DESCRIBE `ports` 0.0031619071960449
(495) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 574))) 0.0013511180877686
(496) DESCRIBE `ports` 0.0064740180969238
(497) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '574') 0.00071191787719727
(498) DESCRIBE `ports` 0.0026009082794189
(499) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00069403648376465
(500) DESCRIBE `ports` 0.003371000289917
(501) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.0023739337921143
(502) DESCRIBE `ports` 0.0034410953521729
(503) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 754))) 0.00083088874816895
(504) DESCRIBE `ports` 0.0029709339141846
(505) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '754') 0.00060582160949707
(506) DESCRIBE `ports` 0.0053048133850098
(507) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 755))) 0.00068998336791992
(508) DESCRIBE `ports` 0.0027470588684082
(509) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '755') 0.00058817863464355
(510) DESCRIBE `ports` 0.0027799606323242
(511) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 572))) 0.00069808959960938
(512) DESCRIBE `ports` 0.0032510757446289
(513) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '572') 0.0031180381774902
(514) DESCRIBE `ports` 0.003046989440918
(515) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 229))) 0.00066614151000977
(516) DESCRIBE `ports` 0.003615140914917
(517) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '229') 0.00084614753723145
(518) DESCRIBE `ports` 0.0051169395446777
(519) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 229))) 0.00074505805969238
(520) DESCRIBE `ports` 0.0042650699615479
(521) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '229') 0.00077009201049805
(522) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '72859') AND (sailingdate >= '2019-03-19') 0.012241125106812
(523) DESCRIBE `avid_specials` 0.0025618076324463
(524) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72859 and class = 'Cruise') OR (item_id = 966 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 49 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.0020461082458496
(525) DESCRIBE `cruiselines` 0.0046358108520508
(526) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.0018000602722168
(527) DESCRIBE `orchid_image` 0.0039808750152588
(528) DESCRIBE `cruiselines` 0.0050728321075439
(529) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00073385238647461
(530) DESCRIBE `cruises` 0.0083920955657959
(531) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66202') 0.00074005126953125
(532) DESCRIBE `ships` 0.008091926574707
(533) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1108))) 0.00086283683776855
(534) DESCRIBE `ships` 0.0054049491882324
(535) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1108') 0.0009000301361084
(536) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00052618980407715
(537) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00052595138549805
(538) DESCRIBE `itineraries` 0.0027861595153809
(539) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66202') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0012428760528564
(540) DESCRIBE `ports` 0.0031590461730957
(541) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.0073668956756592
(542) DESCRIBE `ports` 0.002830982208252
(543) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00078082084655762
(544) DESCRIBE `ports` 0.0029339790344238
(545) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00056314468383789
(546) DESCRIBE `sailingdates` 0.0021600723266602
(547) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66202') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0099308490753174
(548) DESCRIBE `ports` 0.0068778991699219
(549) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00066494941711426
(550) DESCRIBE `ports` 0.0029101371765137
(551) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00065183639526367
(552) DESCRIBE `ports` 0.020064115524292
(553) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 118))) 0.00086498260498047
(554) DESCRIBE `ports` 0.013739109039307
(555) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '118') 0.0006711483001709
(556) DESCRIBE `ports` 0.0035159587860107
(557) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.0067288875579834
(558) DESCRIBE `ports` 0.0041210651397705
(559) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.0012271404266357
(560) DESCRIBE `ports` 0.0031650066375732
(561) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 119))) 0.0087461471557617
(562) DESCRIBE `ports` 0.0031380653381348
(563) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '119') 0.00063705444335938
(564) DESCRIBE `ports` 0.010154008865356
(565) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 333))) 0.0007319450378418
(566) DESCRIBE `ports` 0.0028150081634521
(567) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '333') 0.00058388710021973
(568) DESCRIBE `ports` 0.019604921340942
(569) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) 0.00066590309143066
(570) DESCRIBE `ports` 0.0026741027832031
(571) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') 0.00064396858215332
(572) DESCRIBE `ports` 0.0089128017425537
(573) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3558))) 0.0013279914855957
(574) DESCRIBE `ports` 0.010886907577515
(575) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3558') 0.0062499046325684
(576) DESCRIBE `ports` 0.0054988861083984
(577) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3096))) 0.0044009685516357
(578) DESCRIBE `ports` 0.0047879219055176
(579) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3096') 0.0011029243469238
(580) DESCRIBE `ports` 0.003680944442749
(581) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.0012919902801514
(582) DESCRIBE `ports` 0.0039911270141602
(583) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.00093913078308105
(584) DESCRIBE `ports` 0.0059511661529541
(585) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.00064516067504883
(586) DESCRIBE `ports` 0.0043048858642578
(587) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '116') 0.00094699859619141
(588) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66202') AND (sailingdate >= '2019-03-19') 0.016003131866455
(589) DESCRIBE `avid_specials` 0.0035140514373779
(590) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66202 and class = 'Cruise') OR (item_id = 1108 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 11 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.0025877952575684
(591) DESCRIBE `cruiselines` 0.0047719478607178
(592) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.017767906188965
(593) DESCRIBE `orchid_image` 0.0046179294586182
(594) DESCRIBE `cruiselines` 0.00649094581604
(595) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00056195259094238
(596) DESCRIBE `cruises` 0.0060250759124756
(597) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72898') 0.00064587593078613
(598) DESCRIBE `ships` 0.0068600177764893
(599) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1319))) 0.00082111358642578
(600) DESCRIBE `ships` 0.0053439140319824
(601) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1319') 0.001209020614624
(602) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00068497657775879
(603) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00044989585876465
(604) DESCRIBE `itineraries` 0.0058059692382812
(605) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '72898') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0010659694671631
(606) DESCRIBE `ports` 0.0039658546447754
(607) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00070405006408691
(608) DESCRIBE `ports` 0.0034878253936768
(609) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00098800659179688
(610) DESCRIBE `ports` 0.003324031829834
(611) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0006568431854248
(612) DESCRIBE `sailingdates` 0.0023589134216309
(613) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '72898') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00095105171203613
(614) DESCRIBE `ports` 0.0033230781555176
(615) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00076818466186523
(616) DESCRIBE `ports` 0.0030899047851562
(617) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00066781044006348
(618) DESCRIBE `ports` 0.004396915435791
(619) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0013880729675293
(620) DESCRIBE `ports` 0.003197193145752
(621) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00052690505981445
(622) DESCRIBE `ports` 0.0025858879089355
(623) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2511))) 0.00078606605529785
(624) DESCRIBE `ports` 0.0044159889221191
(625) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2511') 0.0010170936584473
(626) DESCRIBE `ports` 0.002795934677124
(627) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 764))) 0.00059413909912109
(628) DESCRIBE `ports` 0.0028929710388184
(629) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '764') 0.00061297416687012
(630) DESCRIBE `ports` 0.0043540000915527
(631) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3293))) 0.00068402290344238
(632) DESCRIBE `ports` 0.0032899379730225
(633) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3293') 0.0010478496551514
(634) DESCRIBE `ports` 0.0032510757446289
(635) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2405))) 0.00064611434936523
(636) DESCRIBE `ports` 0.0035881996154785
(637) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2405') 0.00090694427490234
(638) DESCRIBE `ports` 0.0039448738098145
(639) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2062))) 0.00057101249694824
(640) DESCRIBE `ports` 0.0038869380950928
(641) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2062') 0.00067996978759766
(642) DESCRIBE `ports` 0.0030920505523682
(643) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00063991546630859
(644) DESCRIBE `ports` 0.0025570392608643
(645) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00050902366638184
(646) DESCRIBE `ports` 0.0025999546051025
(647) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1119))) 0.00086402893066406
(648) DESCRIBE `ports` 0.0033791065216064
(649) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1119') 0.00065088272094727
(650) DESCRIBE `ports` 0.0036230087280273
(651) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 386))) 0.00072288513183594
(652) DESCRIBE `ports` 0.0034208297729492
(653) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '386') 0.00063800811767578
(654) DESCRIBE `ports` 0.002985954284668
(655) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00058102607727051
(656) DESCRIBE `ports` 0.0046188831329346
(657) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00066900253295898
(658) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '72898') AND (sailingdate >= '2019-03-19') 0.01134204864502
(659) DESCRIBE `avid_specials` 0.0028641223907471
(660) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72898 and class = 'Cruise') OR (item_id = 1319 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0021710395812988
(661) DESCRIBE `cruiselines` 0.0037648677825928
(662) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00072813034057617
(663) DESCRIBE `orchid_image` 0.0031030178070068
(664) DESCRIBE `cruiselines` 0.0043749809265137
(665) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00062108039855957
(666) DESCRIBE `cruises` 0.0061640739440918
(667) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72853') 0.0011601448059082
(668) DESCRIBE `ships` 0.0058369636535645
(669) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 850))) 0.00084400177001953
(670) DESCRIBE `ships` 0.0079901218414307
(671) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '850') 0.00068187713623047
(672) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00054192543029785
(673) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00053286552429199
(674) DESCRIBE `itineraries` 0.0032961368560791
(675) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '72853') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0013940334320068
(676) DESCRIBE `ports` 0.0038220882415771
(677) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.0008080005645752
(678) DESCRIBE `ports` 0.0030078887939453
(679) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00072193145751953
(680) DESCRIBE `ports` 0.0034630298614502
(681) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00092291831970215
(682) DESCRIBE `sailingdates` 0.003464937210083
(683) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '72853') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0010478496551514
(684) DESCRIBE `ports` 0.0033159255981445
(685) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00074219703674316
(686) DESCRIBE `ports` 0.0027520656585693
(687) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00061988830566406
(688) DESCRIBE `ports` 0.0027182102203369
(689) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00061988830566406
(690) DESCRIBE `ports` 0.0031969547271729
(691) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00066280364990234
(692) DESCRIBE `ports` 0.0033149719238281
(693) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00071406364440918
(694) DESCRIBE `ports` 0.0024900436401367
(695) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00060009956359863
(696) DESCRIBE `ports` 0.0049729347229004
(697) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00066399574279785
(698) DESCRIBE `ports` 0.0028090476989746
(699) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00081300735473633
(700) DESCRIBE `ports` 0.0040969848632812
(701) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00078988075256348
(702) DESCRIBE `ports` 0.0045361518859863
(703) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00093388557434082
(704) DESCRIBE `ports` 0.0042290687561035
(705) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00091409683227539
(706) DESCRIBE `ports` 0.0034430027008057
(707) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00083804130554199
(708) DESCRIBE `ports` 0.0044748783111572
(709) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00078010559082031
(710) DESCRIBE `ports` 0.0036768913269043
(711) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00094199180603027
(712) DESCRIBE `ports` 0.0026519298553467
(713) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 382))) 0.00076913833618164
(714) DESCRIBE `ports` 0.0035190582275391
(715) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '382') 0.00070500373840332
(716) DESCRIBE `ports` 0.0032839775085449
(717) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 452))) 0.0017769336700439
(718) DESCRIBE `ports` 0.0033369064331055
(719) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '452') 0.00072908401489258
(720) DESCRIBE `ports` 0.0028221607208252
(721) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00063610076904297
(722) DESCRIBE `ports` 0.0026919841766357
(723) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.0005950927734375
(724) DESCRIBE `ports` 0.0036749839782715
(725) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2126))) 0.0011489391326904
(726) DESCRIBE `ports` 0.0043380260467529
(727) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2126') 0.00061702728271484
(728) DESCRIBE `ports` 0.0026350021362305
(729) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 220))) 0.00075197219848633
(730) DESCRIBE `ports` 0.0027401447296143
(731) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '220') 0.00086593627929688
(732) DESCRIBE `ports` 0.0052459239959717
(733) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.00105881690979
(734) DESCRIBE `ports` 0.0062298774719238
(735) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.00093984603881836
(736) DESCRIBE `ports` 0.0048830509185791
(737) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 218))) 0.00088596343994141
(738) DESCRIBE `ports` 0.0053098201751709
(739) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '218') 0.00073504447937012
(740) DESCRIBE `ports` 0.0035278797149658
(741) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 248))) 0.0007779598236084
(742) DESCRIBE `ports` 0.0076930522918701
(743) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '248') 0.0017800331115723
(744) DESCRIBE `ports` 0.0032138824462891
(745) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 751))) 0.0013840198516846
(746) DESCRIBE `ports` 0.0037868022918701
(747) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '751') 0.0011968612670898
(748) DESCRIBE `ports` 0.0091879367828369
(749) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 568))) 0.00067400932312012
(750) DESCRIBE `ports` 0.0063009262084961
(751) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '568') 0.00075793266296387
(752) DESCRIBE `ports` 0.0029301643371582
(753) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 567))) 0.00069403648376465
(754) DESCRIBE `ports` 0.0048038959503174
(755) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '567') 0.00074005126953125
(756) DESCRIBE `ports` 0.0044200420379639
(757) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.0012819766998291
(758) DESCRIBE `ports` 0.0076780319213867
(759) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00078392028808594
(760) DESCRIBE `ports` 0.0036430358886719
(761) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00082206726074219
(762) DESCRIBE `ports` 0.007688045501709
(763) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00079798698425293
(764) DESCRIBE `ports` 0.0037939548492432
(765) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1870))) 0.00057792663574219
(766) DESCRIBE `ports` 0.0089559555053711
(767) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1870') 0.001558780670166
(768) DESCRIBE `ports` 0.0040609836578369
(769) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 557))) 0.00083589553833008
(770) DESCRIBE `ports` 0.0036680698394775
(771) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '557') 0.0006709098815918
(772) DESCRIBE `ports` 0.0034570693969727
(773) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2987))) 0.00072288513183594
(774) DESCRIBE `ports` 0.0027151107788086
(775) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2987') 0.0005650520324707
(776) DESCRIBE `ports` 0.0027039051055908
(777) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00083589553833008
(778) DESCRIBE `ports` 0.0036678314208984
(779) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00058698654174805
(780) DESCRIBE `ports` 0.002255916595459
(781) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00053691864013672
(782) DESCRIBE `ports` 0.0024468898773193
(783) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00069379806518555
(784) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '72853') AND (sailingdate >= '2019-03-19') 0.01068902015686
(785) DESCRIBE `avid_specials` 0.004216194152832
(786) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72853 and class = 'Cruise') OR (item_id = 850 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 26 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0027520656585693
(787) DESCRIBE `cruiselines` 0.0042219161987305
(788) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00077986717224121
(789) DESCRIBE `orchid_image` 0.0033690929412842
(790) DESCRIBE `cruiselines` 0.0057718753814697
(791) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00074005126953125
(792) DESCRIBE `ships` 0.008587121963501
(793) SELECT `ships`.* FROM `ships` WHERE (id IN ('850', '1319', '1108', '966', '508', '394')) ORDER BY FIND_IN_SET(id, '850,1319,1108,966,508,394') 0.0020802021026611
(794) DESCRIBE `cruisetypes` 0.0021660327911377
(795) SELECT DISTINCT `cruisetypes`.* FROM `cruisetypes` LEFT JOIN `cruises_and_specials` ON cruisetypes.id = cruises_and_specials.cruisetype_id WHERE (cruisetypes.id = cruises_and_specials.cruisetype_id) AND (cruises_and_specials.cruiseline_id = '91') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC 0.050963878631592
(796) DESCRIBE `destinations` 0.0035929679870605
(797) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '12', '40', '37', '43', '35', '38', '2', '26', '28', '48', '11', '21', '45', '8', '30', '49', '52', '10', '25', '34', '32', '55')) ORDER BY FIND_IN_SET(id, '22,12,40,37,43,35,38,2,26,28,48,11,21,45,8,30,49,52,10,25,34,32,55') 0.0032260417938232
(798) DESCRIBE `cruiselines` 0.0049369335174561
(799) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00078296661376953
(800) DESCRIBE `cruiselines` 0.0043098926544189
(801) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00076103210449219