or, enquire about your chosen options

  1. Catch Up on Cruising: Latest News in bite size!
  2. Fantastic Fly/Cruise/Stay Packages with Blue Lagoon Cruises
  3. Catch up on Cruising: Latest news in bite size
  4. First Time Cruisers review of Carnival Spirit
  5. REVIEW: Norwegian Star – Greek Isles and Croatia Cruise

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

Total elapsed time: 0.40252757072449

# Query Time
(1) connect 0.00054788589477539
(2) DESCRIBE `cruises` 0.0024230480194092
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (53605, 66993, 46637, 34056, 66953, 66955, 66996, 66994, 66997, 60589)) ORDER BY FIND_IN_SET(id, '53605,66993,46637,34056,66953,66955,66996,66994,66997,60589') 0.0013160705566406
(4) DESCRIBE `cruises` 0.0020949840545654
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '53605') 0.00030016899108887
(6) DESCRIBE `ships` 0.0012738704681396
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 770))) 0.00024509429931641
(8) DESCRIBE `ships` 0.0012528896331787
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '770') 0.00017690658569336
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017285346984863
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016880035400391
(12) DESCRIBE `itineraries` 0.00066900253295898
(13) DESCRIBE `ports` 0.00077605247497559
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00037598609924316
(15) DESCRIBE `ports` 0.0011138916015625
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00019502639770508
(17) DESCRIBE `ports` 0.00066995620727539
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.0001828670501709
(19) DESCRIBE `sailingdates` 0.00063395500183105
(20) DESCRIBE `ports` 0.00077295303344727
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00024199485778809
(22) DESCRIBE `ports` 0.0006868839263916
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00019001960754395
(24) DESCRIBE `ports` 0.00066614151000977
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00020790100097656
(26) DESCRIBE `ports` 0.00066590309143066
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00018191337585449
(28) DESCRIBE `ports` 0.00068306922912598
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.00020003318786621
(30) DESCRIBE `ports` 0.00066494941711426
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.00018095970153809
(32) DESCRIBE `ports` 0.000885009765625
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00020909309387207
(34) DESCRIBE `ports` 0.00075507164001465
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00023484230041504
(36) DESCRIBE `ports` 0.00066900253295898
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00027704238891602
(38) DESCRIBE `ports` 0.00073099136352539
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00018501281738281
(40) DESCRIBE `ports` 0.00066590309143066
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00020098686218262
(42) DESCRIBE `ports` 0.0006718635559082
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00023579597473145
(44) DESCRIBE `ports` 0.00084805488586426
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00021195411682129
(46) DESCRIBE `ports` 0.00073099136352539
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00024080276489258
(48) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '53605') AND (sailingdate >= '2018-04-01') AND (sailingdate <= '2018-12-31') 0.0055110454559326
(49) DESCRIBE `avid_specials` 0.00077199935913086
(50) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 53605 and class = 'Cruise') OR (item_id = 770 AND class = 'Ship') OR (item_id = 20 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.00097084045410156
(51) DESCRIBE `cruiselines` 0.0011250972747803
(52) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00024604797363281
(53) DESCRIBE `orchid_image` 0.00088000297546387
(54) DESCRIBE `cruiselines` 0.0011370182037354
(55) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00023412704467773
(56) DESCRIBE `cruises` 0.0015020370483398
(57) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66993') 0.00021719932556152
(58) DESCRIBE `ships` 0.0015139579772949
(59) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 448))) 0.00027894973754883
(60) DESCRIBE `ships` 0.0013761520385742
(61) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '448') 0.00018692016601562
(62) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017499923706055
(63) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016403198242188
(64) DESCRIBE `itineraries` 0.00069808959960938
(65) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66993') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00058102607727051
(66) DESCRIBE `ports` 0.0007469654083252
(67) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00021600723266602
(68) DESCRIBE `ports` 0.00066113471984863
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00020980834960938
(70) DESCRIBE `ports` 0.00065708160400391
(71) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00017786026000977
(72) DESCRIBE `sailingdates` 0.0005950927734375
(73) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66993') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00051999092102051
(74) DESCRIBE `ports` 0.00071382522583008
(75) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0002138614654541
(76) DESCRIBE `ports` 0.00085306167602539
(77) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00020909309387207
(78) DESCRIBE `ports` 0.00068497657775879
(79) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00021815299987793
(80) DESCRIBE `ports` 0.00067019462585449
(81) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00019001960754395
(82) DESCRIBE `ports` 0.00065302848815918
(83) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.0002131462097168
(84) DESCRIBE `ports` 0.00065803527832031
(85) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00018715858459473
(86) DESCRIBE `ports` 0.00068211555480957
(87) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 198))) 0.00020003318786621
(88) DESCRIBE `ports` 0.0006711483001709
(89) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '198') 0.00017499923706055
(90) DESCRIBE `ports` 0.00065088272094727
(91) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00019216537475586
(92) DESCRIBE `ports` 0.00066995620727539
(93) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00017309188842773
(94) DESCRIBE `ports` 0.00065398216247559
(95) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3963))) 0.0001990795135498
(96) DESCRIBE `ports` 0.00065016746520996
(97) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3963') 0.00018620491027832
(98) DESCRIBE `ports` 0.00068902969360352
(99) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00019502639770508
(100) DESCRIBE `ports` 0.00065898895263672
(101) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00018596649169922
(102) DESCRIBE `ports` 0.0006558895111084
(103) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00020003318786621
(104) DESCRIBE `ports` 0.0006568431854248
(105) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00018596649169922
(106) DESCRIBE `ports` 0.00065493583679199
(107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00019097328186035
(108) DESCRIBE `ports` 0.00065493583679199
(109) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00017690658569336
(110) DESCRIBE `ports` 0.00065398216247559
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00020599365234375
(112) DESCRIBE `ports` 0.00066018104553223
(113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00017285346984863
(114) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66993') AND (sailingdate >= '2018-04-01') AND (sailingdate <= '2018-12-31') 0.0053620338439941
(115) DESCRIBE `avid_specials` 0.00081610679626465
(116) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66993 and class = 'Cruise') OR (item_id = 448 AND class = 'Ship') OR (item_id = 20 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.00097298622131348
(117) DESCRIBE `cruiselines` 0.0010330677032471
(118) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00024318695068359
(119) DESCRIBE `orchid_image` 0.00075387954711914
(120) DESCRIBE `cruiselines` 0.00098896026611328
(121) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00018715858459473
(122) DESCRIBE `cruises` 0.0012528896331787
(123) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '46637') 0.00021004676818848
(124) DESCRIBE `ships` 0.0012609958648682
(125) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 770))) 0.00024199485778809
(126) DESCRIBE `ships` 0.0012309551239014
(127) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '770') 0.00017309188842773
(128) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017404556274414
(129) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016903877258301
(130) DESCRIBE `itineraries` 0.00066590309143066
(131) DESCRIBE `ports` 0.00067496299743652
(132) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00022792816162109
(133) DESCRIBE `ports` 0.00066399574279785
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00018978118896484
(135) DESCRIBE `ports` 0.0006561279296875
(136) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00017499923706055
(137) DESCRIBE `sailingdates` 0.00062203407287598
(138) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '46637') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00075817108154297
(139) DESCRIBE `ports` 0.00083088874816895
(140) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00022602081298828
(141) DESCRIBE `ports` 0.0006718635559082
(142) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00019097328186035
(143) DESCRIBE `ports` 0.00071096420288086
(144) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00021100044250488
(145) DESCRIBE `ports` 0.00067305564880371
(146) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00018095970153809
(147) DESCRIBE `ports` 0.00065088272094727
(148) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00020599365234375
(149) DESCRIBE `ports` 0.00064897537231445
(150) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00018477439880371
(151) DESCRIBE `ports` 0.00065088272094727
(152) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.0002129077911377
(153) DESCRIBE `ports` 0.00064706802368164
(154) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.0001978874206543
(155) DESCRIBE `ports` 0.00064992904663086
(156) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.00019311904907227
(157) DESCRIBE `ports` 0.00070881843566895
(158) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.00017404556274414
(159) DESCRIBE `ports` 0.00066614151000977
(160) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00019288063049316
(161) DESCRIBE `ports` 0.00065708160400391
(162) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00017309188842773
(163) DESCRIBE `ports` 0.00066089630126953
(164) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00019097328186035
(165) DESCRIBE `ports` 0.00066113471984863
(166) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.0001828670501709
(167) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '46637') AND (sailingdate >= '2018-04-01') AND (sailingdate <= '2018-12-31') 0.0050580501556396
(168) DESCRIBE `avid_specials` 0.00065398216247559
(169) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 46637 and class = 'Cruise') OR (item_id = 770 AND class = 'Ship') OR (item_id = 20 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.0010149478912354
(170) DESCRIBE `cruiselines` 0.0010159015655518
(171) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00022101402282715
(172) DESCRIBE `orchid_image` 0.00084400177001953
(173) DESCRIBE `cruiselines` 0.00096416473388672
(174) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.0001990795135498
(175) DESCRIBE `cruises` 0.0015430450439453
(176) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '34056') 0.00024819374084473
(177) DESCRIBE `ships` 0.0014290809631348
(178) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 448))) 0.00026702880859375
(179) DESCRIBE `ships` 0.001366138458252
(180) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '448') 0.00020313262939453
(181) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00039005279541016
(182) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018310546875
(183) DESCRIBE `itineraries` 0.00066709518432617
(184) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '34056') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00054216384887695
(185) DESCRIBE `ports` 0.00072908401489258
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00022101402282715
(187) DESCRIBE `ports` 0.0013730525970459
(188) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00032496452331543
(189) DESCRIBE `ports` 0.00099492073059082
(190) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00023388862609863
(191) DESCRIBE `sailingdates` 0.00084304809570312
(192) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '34056') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00052309036254883
(193) DESCRIBE `ports` 0.00079202651977539
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00022387504577637
(195) DESCRIBE `ports` 0.00068187713623047
(196) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00019311904907227
(197) DESCRIBE `ports` 0.00066709518432617
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00019598007202148
(199) DESCRIBE `ports` 0.0008540153503418
(200) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00018906593322754
(201) DESCRIBE `ports` 0.00080418586730957
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00021910667419434
(203) DESCRIBE `ports` 0.00066304206848145
(204) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00017404556274414
(205) DESCRIBE `ports` 0.00066494941711426
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00019001960754395
(207) DESCRIBE `ports` 0.00066304206848145
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0001828670501709
(209) DESCRIBE `ports` 0.00065803527832031
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2565))) 0.00019979476928711
(211) DESCRIBE `ports` 0.00066804885864258
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2565') 0.00019097328186035
(213) DESCRIBE `ports` 0.00065994262695312
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00019502639770508
(215) DESCRIBE `ports` 0.00065994262695312
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00018310546875
(217) DESCRIBE `ports` 0.00066804885864258
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00020194053649902
(219) DESCRIBE `ports` 0.00066113471984863
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00017213821411133
(221) DESCRIBE `ports` 0.00066184997558594
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 370))) 0.00019311904907227
(223) DESCRIBE `ports` 0.00066590309143066
(224) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '370') 0.00017905235290527
(225) DESCRIBE `ports` 0.00065898895263672
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00019288063049316
(227) DESCRIBE `ports` 0.00066304206848145
(228) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00017213821411133
(229) DESCRIBE `ports` 0.00069689750671387
(230) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00020694732666016
(231) DESCRIBE `ports` 0.00065779685974121
(232) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00017285346984863
(233) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '34056') AND (sailingdate >= '2018-04-01') AND (sailingdate <= '2018-12-31') 0.0055820941925049
(234) DESCRIBE `avid_specials` 0.00086808204650879
(235) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 34056 and class = 'Cruise') OR (item_id = 448 AND class = 'Ship') OR (item_id = 20 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.0010128021240234
(236) DESCRIBE `cruiselines` 0.00097894668579102
(237) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00023698806762695
(238) DESCRIBE `orchid_image` 0.00075697898864746
(239) DESCRIBE `cruiselines` 0.00092196464538574
(240) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00019001960754395
(241) DESCRIBE `cruises` 0.0022280216217041
(242) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66953') 0.00026893615722656
(243) DESCRIBE `ships` 0.0024158954620361
(244) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00044798851013184
(245) DESCRIBE `ships` 0.0023078918457031
(246) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00033211708068848
(247) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019288063049316
(248) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016689300537109
(249) DESCRIBE `itineraries` 0.00067496299743652
(250) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66953') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0005500316619873
(251) DESCRIBE `ports` 0.0010628700256348
(252) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00029206275939941
(253) DESCRIBE `ports` 0.00086092948913574
(254) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00025677680969238
(255) DESCRIBE `ports` 0.00092816352844238
(256) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00023603439331055
(257) DESCRIBE `sailingdates` 0.00063896179199219
(258) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66953') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00048089027404785
(259) DESCRIBE `ports` 0.00072503089904785
(260) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00020694732666016
(261) DESCRIBE `ports` 0.00066304206848145
(262) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00017809867858887
(263) DESCRIBE `ports` 0.0007472038269043
(264) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00019717216491699
(265) DESCRIBE `ports` 0.00065398216247559
(266) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00017786026000977
(267) DESCRIBE `ports` 0.00065803527832031
(268) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00020098686218262
(269) DESCRIBE `ports` 0.00089097023010254
(270) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00023889541625977
(271) DESCRIBE `ports` 0.00067877769470215
(272) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00021600723266602
(273) DESCRIBE `ports` 0.00066900253295898
(274) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00018095970153809
(275) DESCRIBE `ports` 0.00067400932312012
(276) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00020003318786621
(277) DESCRIBE `ports` 0.00065803527832031
(278) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00017809867858887
(279) DESCRIBE `ports` 0.00065708160400391
(280) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00020003318786621
(281) DESCRIBE `ports` 0.00066995620727539
(282) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00017809867858887
(283) DESCRIBE `ports` 0.00065708160400391
(284) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00019693374633789
(285) DESCRIBE `ports` 0.00068783760070801
(286) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00018000602722168
(287) DESCRIBE `ports` 0.00065898895263672
(288) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2613))) 0.00020098686218262
(289) DESCRIBE `ports` 0.00066113471984863
(290) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2613') 0.00017285346984863
(291) DESCRIBE `ports` 0.00067996978759766
(292) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00019598007202148
(293) DESCRIBE `ports` 0.00066113471984863
(294) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00017809867858887
(295) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66953') AND (sailingdate >= '2018-04-01') AND (sailingdate <= '2018-12-31') 0.0050938129425049
(296) DESCRIBE `avid_specials` 0.00066494941711426
(297) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66953 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 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.0009310245513916
(298) DESCRIBE `cruiselines` 0.00098490715026855
(299) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00021600723266602
(300) DESCRIBE `orchid_image` 0.00075292587280273
(301) DESCRIBE `cruiselines` 0.00090789794921875
(302) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00017809867858887
(303) DESCRIBE `cruises` 0.00124192237854
(304) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66955') 0.00018811225891113
(305) DESCRIBE `ships` 0.0012571811676025
(306) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00024104118347168
(307) DESCRIBE `ships` 0.0012218952178955
(308) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00018596649169922
(309) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017690658569336
(310) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001680850982666
(311) DESCRIBE `itineraries` 0.00067591667175293
(312) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66955') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00034499168395996
(313) DESCRIBE `ports` 0.00068998336791992
(314) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00020694732666016
(315) DESCRIBE `ports` 0.00066304206848145
(316) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00019502639770508
(317) DESCRIBE `ports` 0.00066089630126953
(318) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00017905235290527
(319) DESCRIBE `sailingdates` 0.00060176849365234
(320) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66955') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00034880638122559
(321) DESCRIBE `ports` 0.00069808959960938
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00019478797912598
(323) DESCRIBE `ports` 0.00069189071655273
(324) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00017595291137695
(325) DESCRIBE `ports` 0.00066089630126953
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00020194053649902
(327) DESCRIBE `ports` 0.00066804885864258
(328) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00017690658569336
(329) DESCRIBE `ports` 0.00067615509033203
(330) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00019693374633789
(331) DESCRIBE `ports` 0.00066113471984863
(332) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00017690658569336
(333) DESCRIBE `ports` 0.00068402290344238
(334) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 370))) 0.00025510787963867
(335) DESCRIBE `ports` 0.00074100494384766
(336) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '370') 0.00018692016601562
(337) DESCRIBE `ports` 0.00076985359191895
(338) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00020503997802734
(339) DESCRIBE `ports` 0.0006721019744873
(340) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00019621849060059
(341) DESCRIBE `ports` 0.0006711483001709
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00021505355834961
(343) DESCRIBE `ports` 0.00066685676574707
(344) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00018000602722168
(345) DESCRIBE `ports` 0.00066208839416504
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00020217895507812
(347) DESCRIBE `ports` 0.00066304206848145
(348) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0001988410949707
(349) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66955') AND (sailingdate >= '2018-04-01') AND (sailingdate <= '2018-12-31') 0.0051708221435547
(350) DESCRIBE `avid_specials` 0.00074982643127441
(351) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66955 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 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.0010359287261963
(352) DESCRIBE `cruiselines` 0.00098109245300293
(353) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00022506713867188
(354) DESCRIBE `orchid_image` 0.00075507164001465
(355) DESCRIBE `cruiselines` 0.00091290473937988
(356) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00018310546875
(357) DESCRIBE `cruises` 0.001251220703125
(358) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66996') 0.00019693374633789
(359) DESCRIBE `ships` 0.0012528896331787
(360) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00024199485778809
(361) DESCRIBE `ships` 0.0012381076812744
(362) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00018501281738281
(363) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017714500427246
(364) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001671314239502
(365) DESCRIBE `itineraries` 0.00068092346191406
(366) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66996') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0004429817199707
(367) DESCRIBE `ports` 0.00070285797119141
(368) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00022292137145996
(369) DESCRIBE `ports` 0.00066709518432617
(370) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00020003318786621
(371) DESCRIBE `ports` 0.0006711483001709
(372) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018215179443359
(373) DESCRIBE `sailingdates` 0.00060296058654785
(374) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66996') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0005791187286377
(375) DESCRIBE `ports` 0.00080609321594238
(376) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00021696090698242
(377) DESCRIBE `ports` 0.0006721019744873
(378) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018095970153809
(379) DESCRIBE `ports` 0.0007178783416748
(380) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00024199485778809
(381) DESCRIBE `ports` 0.00087094306945801
(382) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00017905235290527
(383) DESCRIBE `ports` 0.00073003768920898
(384) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00025200843811035
(385) DESCRIBE `ports` 0.00074291229248047
(386) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00017499923706055
(387) DESCRIBE `ports` 0.0006558895111084
(388) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00019311904907227
(389) DESCRIBE `ports` 0.00066494941711426
(390) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00017309188842773
(391) DESCRIBE `ports` 0.0006859302520752
(392) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.0001981258392334
(393) DESCRIBE `ports` 0.00066089630126953
(394) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00017285346984863
(395) DESCRIBE `ports` 0.00065803527832031
(396) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00019502639770508
(397) DESCRIBE `ports` 0.0006561279296875
(398) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00017094612121582
(399) DESCRIBE `ports` 0.00065016746520996
(400) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00019407272338867
(401) DESCRIBE `ports` 0.00065398216247559
(402) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00019502639770508
(403) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66996') AND (sailingdate >= '2018-04-01') AND (sailingdate <= '2018-12-31') 0.0050671100616455
(404) DESCRIBE `avid_specials` 0.00062918663024902
(405) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66996 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 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.00092720985412598
(406) DESCRIBE `cruiselines` 0.0010030269622803
(407) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00026607513427734
(408) DESCRIBE `orchid_image` 0.00075793266296387
(409) DESCRIBE `cruiselines` 0.00091886520385742
(410) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00018000602722168
(411) DESCRIBE `cruises` 0.0012640953063965
(412) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66994') 0.00019502639770508
(413) DESCRIBE `ships` 0.0012550354003906
(414) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 448))) 0.00023078918457031
(415) DESCRIBE `ships` 0.0013089179992676
(416) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '448') 0.00017595291137695
(417) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018000602722168
(418) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017499923706055
(419) DESCRIBE `itineraries` 0.00066709518432617
(420) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66994') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0003821849822998
(421) DESCRIBE `ports` 0.00070691108703613
(422) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00021004676818848
(423) DESCRIBE `ports` 0.00066781044006348
(424) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0001990795135498
(425) DESCRIBE `ports` 0.00066304206848145
(426) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00018215179443359
(427) DESCRIBE `sailingdates` 0.00060296058654785
(428) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66994') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0003349781036377
(429) DESCRIBE `ports` 0.00068092346191406
(430) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00019001960754395
(431) DESCRIBE `ports` 0.00066280364990234
(432) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00017285346984863
(433) DESCRIBE `ports` 0.00079703330993652
(434) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.0002131462097168
(435) DESCRIBE `ports` 0.00067901611328125
(436) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00018000602722168
(437) DESCRIBE `ports` 0.00066304206848145
(438) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.0001990795135498
(439) DESCRIBE `ports` 0.00070595741271973
(440) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.00018000602722168
(441) DESCRIBE `ports` 0.0006711483001709
(442) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00019598007202148
(443) DESCRIBE `ports` 0.00066184997558594
(444) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00017595291137695
(445) DESCRIBE `ports` 0.00067710876464844
(446) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00020289421081543
(447) DESCRIBE `ports` 0.00066900253295898
(448) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00017786026000977
(449) DESCRIBE `ports` 0.0006568431854248
(450) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00021791458129883
(451) DESCRIBE `ports` 0.00065898895263672
(452) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00017809867858887
(453) DESCRIBE `ports` 0.0006558895111084
(454) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 587))) 0.00020098686218262
(455) DESCRIBE `ports` 0.00065708160400391
(456) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '587') 0.00019407272338867
(457) DESCRIBE `ports` 0.00069785118103027
(458) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00019502639770508
(459) DESCRIBE `ports` 0.00065994262695312
(460) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00017595291137695
(461) DESCRIBE `ports` 0.00066709518432617
(462) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00019502639770508
(463) DESCRIBE `ports` 0.00066304206848145
(464) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00018310546875
(465) DESCRIBE `ports` 0.00065493583679199
(466) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00019383430480957
(467) DESCRIBE `ports` 0.00070595741271973
(468) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00017809867858887
(469) DESCRIBE `ports` 0.00066113471984863
(470) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00019598007202148
(471) DESCRIBE `ports` 0.00065708160400391
(472) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00017714500427246
(473) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66994') AND (sailingdate >= '2018-04-01') AND (sailingdate <= '2018-12-31') 0.0051748752593994
(474) DESCRIBE `avid_specials` 0.00071001052856445
(475) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66994 and class = 'Cruise') OR (item_id = 448 AND class = 'Ship') OR (item_id = 20 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.00093817710876465
(476) DESCRIBE `cruiselines` 0.0010180473327637
(477) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00022983551025391
(478) DESCRIBE `orchid_image` 0.00076103210449219
(479) DESCRIBE `cruiselines` 0.0010769367218018
(480) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00025510787963867
(481) DESCRIBE `cruises` 0.0014078617095947
(482) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66997') 0.00025582313537598
(483) DESCRIBE `ships` 0.001305103302002
(484) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00026392936706543
(485) DESCRIBE `ships` 0.0012450218200684
(486) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00022292137145996
(487) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018620491027832
(488) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016999244689941
(489) DESCRIBE `itineraries` 0.00070810317993164
(490) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66997') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00033783912658691
(491) DESCRIBE `ports` 0.0007021427154541
(492) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00021696090698242
(493) DESCRIBE `ports` 0.00067782402038574
(494) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00020003318786621
(495) DESCRIBE `ports` 0.00068211555480957
(496) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00020694732666016
(497) DESCRIBE `sailingdates` 0.00060296058654785
(498) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66997') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00036907196044922
(499) DESCRIBE `ports` 0.00075006484985352
(500) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00020503997802734
(501) DESCRIBE `ports` 0.00067806243896484
(502) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018095970153809
(503) DESCRIBE `ports` 0.00066804885864258
(504) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00020503997802734
(505) DESCRIBE `ports` 0.00068783760070801
(506) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00017809867858887
(507) DESCRIBE `ports` 0.00066208839416504
(508) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.0001978874206543
(509) DESCRIBE `ports` 0.00066089630126953
(510) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00017809867858887
(511) DESCRIBE `ports` 0.0006859302520752
(512) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1122))) 0.00020384788513184
(513) DESCRIBE `ports` 0.00066494941711426
(514) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1122') 0.00017809867858887
(515) DESCRIBE `ports` 0.00066113471984863
(516) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00023102760314941
(517) DESCRIBE `ports` 0.00073409080505371
(518) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00018000602722168
(519) DESCRIBE `ports` 0.00066709518432617
(520) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00020599365234375
(521) DESCRIBE `ports` 0.00066614151000977
(522) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00018215179443359
(523) DESCRIBE `ports` 0.00068116188049316
(524) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00020813941955566
(525) DESCRIBE `ports` 0.00066900253295898
(526) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00018215179443359
(527) DESCRIBE `ports` 0.00069212913513184
(528) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00020217895507812
(529) DESCRIBE `ports` 0.0006721019744873
(530) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018191337585449
(531) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66997') AND (sailingdate >= '2018-04-01') AND (sailingdate <= '2018-12-31') 0.0051131248474121
(532) DESCRIBE `avid_specials` 0.00090384483337402
(533) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66997 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 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.00097894668579102
(534) DESCRIBE `cruiselines` 0.0010430812835693
(535) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00025796890258789
(536) DESCRIBE `orchid_image` 0.00083518028259277
(537) DESCRIBE `cruiselines` 0.0009300708770752
(538) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00019192695617676
(539) DESCRIBE `cruises` 0.0012590885162354
(540) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '60589') 0.00021910667419434
(541) DESCRIBE `ships` 0.0012941360473633
(542) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00027012825012207
(543) DESCRIBE `ships` 0.0012719631195068
(544) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00024104118347168
(545) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021505355834961
(546) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016903877258301
(547) DESCRIBE `itineraries` 0.00068283081054688
(548) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '60589') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00054121017456055
(549) DESCRIBE `ports` 0.00098180770874023
(550) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00024795532226562
(551) DESCRIBE `ports` 0.00072097778320312
(552) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00022578239440918
(553) DESCRIBE `ports` 0.000762939453125
(554) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00020408630371094
(555) DESCRIBE `sailingdates` 0.00073480606079102
(556) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '60589') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00068402290344238
(557) DESCRIBE `ports` 0.0011320114135742
(558) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00024986267089844
(559) DESCRIBE `ports` 0.0010349750518799
(560) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00033998489379883
(561) DESCRIBE `ports` 0.0011110305786133
(562) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.0003509521484375
(563) DESCRIBE `ports` 0.0011420249938965
(564) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00032591819763184
(565) DESCRIBE `ports` 0.00098395347595215
(566) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00026607513427734
(567) DESCRIBE `ports` 0.00073599815368652
(568) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00018191337585449
(569) DESCRIBE `ports` 0.00066900253295898
(570) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00020909309387207
(571) DESCRIBE `ports` 0.00068902969360352
(572) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00017809867858887
(573) DESCRIBE `ports` 0.00066494941711426
(574) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1106))) 0.00020098686218262
(575) DESCRIBE `ports` 0.00074005126953125
(576) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1106') 0.00018215179443359
(577) DESCRIBE `ports` 0.0006721019744873
(578) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00021791458129883
(579) DESCRIBE `ports` 0.00066590309143066
(580) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018596649169922
(581) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '60589') AND (sailingdate >= '2018-04-01') AND (sailingdate <= '2018-12-31') 0.0058820247650146
(582) DESCRIBE `avid_specials` 0.0010020732879639
(583) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 60589 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 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.0010371208190918
(584) DESCRIBE `cruiselines` 0.0010929107666016
(585) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00024294853210449
(586) DESCRIBE `orchid_image` 0.00077199935913086
(587) DESCRIBE `cruiselines` 0.0009300708770752
(588) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00020694732666016
(589) DESCRIBE `ships` 0.0016121864318848
(590) SELECT `ships`.* FROM `ships` WHERE (id IN ('770', '93', '448')) ORDER BY FIND_IN_SET(id, '770,93,448') 0.00043392181396484
(591) DESCRIBE `cruisetypes` 0.00062084197998047
(592) SELECT DISTINCT `cruisetypes`.* FROM `cruisetypes` LEFT JOIN `cruises_and_specials` ON cruisetypes.id = cruises_and_specials.cruisetype_id WHERE (cruises_and_specials.destination_id = '22') AND (cruises_and_specials.cruiseline_id = '20') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC 0.034013986587524
(593) DESCRIBE `cruiselines` 0.0017139911651611
(594) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00031304359436035
(595) DESCRIBE `destinations` 0.0010969638824463
(596) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 22))) 0.00029110908508301
(597) DESCRIBE `destinations` 0.0011639595031738
(598) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 22))) 0.00030207633972168
(599) DESCRIBE `cruiselines` 0.001060962677002
(600) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00026202201843262