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

Total elapsed time: 0.30935072898865

# Query Time
(1) connect 0.00083398818969727
(2) DESCRIBE `cruises` 0.0021109580993652
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (55703, 65886, 65887, 65888, 41778, 41780, 63370, 65889, 50857, 41776)) ORDER BY FIND_IN_SET(id, '55703,65886,65887,65888,41778,41780,63370,65889,50857,41776') 0.0012969970703125
(4) DESCRIBE `cruises` 0.0020711421966553
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '55703') 0.00032901763916016
(6) DESCRIBE `ships` 0.0018420219421387
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00042510032653809
(8) DESCRIBE `ships` 0.0017731189727783
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00033688545227051
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018906593322754
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017499923706055
(12) DESCRIBE `itineraries` 0.0010478496551514
(13) DESCRIBE `ports` 0.0012691020965576
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00032711029052734
(15) DESCRIBE `ports` 0.0010581016540527
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00033187866210938
(17) DESCRIBE `ports` 0.00090599060058594
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00026583671569824
(19) DESCRIBE `sailingdates` 0.0012128353118896
(20) DESCRIBE `ports` 0.0013489723205566
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00034499168395996
(22) DESCRIBE `ports` 0.0010209083557129
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00026106834411621
(24) DESCRIBE `ports` 0.0010001659393311
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4450))) 0.00027585029602051
(26) DESCRIBE `ports` 0.00091695785522461
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4450') 0.00022792816162109
(28) DESCRIBE `ports` 0.00090503692626953
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030994415283203
(30) DESCRIBE `ports` 0.00097203254699707
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00038385391235352
(32) DESCRIBE `avid_specials` 0.0024588108062744
(33) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 55703 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 8 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.0024189949035645
(34) DESCRIBE `cruiselines` 0.0016419887542725
(35) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00044703483581543
(36) DESCRIBE `orchid_image` 0.0012249946594238
(37) DESCRIBE `cruiselines` 0.001439094543457
(38) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00032496452331543
(39) DESCRIBE `cruises` 0.0019559860229492
(40) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65886') 0.00039792060852051
(41) DESCRIBE `ships` 0.002025842666626
(42) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00051212310791016
(43) DESCRIBE `ships` 0.0020301342010498
(44) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00051617622375488
(45) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021576881408691
(46) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020098686218262
(47) DESCRIBE `itineraries` 0.00099706649780273
(48) DESCRIBE `ports` 0.0010261535644531
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030303001403809
(50) DESCRIBE `ports` 0.00092887878417969
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00026798248291016
(52) DESCRIBE `ports` 0.0011739730834961
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00030517578125
(54) DESCRIBE `sailingdates` 0.00089192390441895
(55) DESCRIBE `ports` 0.00096988677978516
(56) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029993057250977
(57) DESCRIBE `ports` 0.00092506408691406
(58) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00023794174194336
(59) DESCRIBE `ports` 0.00085687637329102
(60) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2895))) 0.00028109550476074
(61) DESCRIBE `ports` 0.00087404251098633
(62) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2895') 0.00023412704467773
(63) DESCRIBE `ports` 0.00084900856018066
(64) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 497))) 0.00026893615722656
(65) DESCRIBE `ports` 0.00074100494384766
(66) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '497') 0.00022101402282715
(67) DESCRIBE `ports` 0.00088691711425781
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1440))) 0.00026416778564453
(69) DESCRIBE `ports` 0.00083208084106445
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1440') 0.00018596649169922
(71) DESCRIBE `ports` 0.00091791152954102
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.00033092498779297
(73) DESCRIBE `ports` 0.00093889236450195
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.00024008750915527
(75) DESCRIBE `ports` 0.00089597702026367
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.00027704238891602
(77) DESCRIBE `ports` 0.0010550022125244
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.00027203559875488
(79) DESCRIBE `ports` 0.0010809898376465
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 504))) 0.00030016899108887
(81) DESCRIBE `ports` 0.00098705291748047
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '504') 0.00026988983154297
(83) DESCRIBE `ports` 0.00090193748474121
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00028181076049805
(85) DESCRIBE `ports` 0.001060962677002
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00028204917907715
(87) DESCRIBE `avid_specials` 0.00091910362243652
(88) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65886 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 35 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.0018470287322998
(89) DESCRIBE `cruiselines` 0.0015830993652344
(90) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.0003509521484375
(91) DESCRIBE `orchid_image` 0.0011110305786133
(92) DESCRIBE `cruiselines` 0.0015559196472168
(93) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00028800964355469
(94) DESCRIBE `cruises` 0.0019228458404541
(95) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65887') 0.00026106834411621
(96) DESCRIBE `ships` 0.0018990039825439
(97) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00037407875061035
(98) DESCRIBE `ships` 0.0019640922546387
(99) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00033903121948242
(100) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020384788513184
(101) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019407272338867
(102) DESCRIBE `itineraries` 0.0010759830474854
(103) DESCRIBE `ports` 0.0010838508605957
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00034809112548828
(105) DESCRIBE `ports` 0.0010101795196533
(106) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00028419494628906
(107) DESCRIBE `ports` 0.0009300708770752
(108) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00024700164794922
(109) DESCRIBE `sailingdates` 0.00083088874816895
(110) DESCRIBE `ports` 0.00096702575683594
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00031399726867676
(112) DESCRIBE `ports` 0.00091981887817383
(113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00022578239440918
(114) DESCRIBE `ports` 0.00089311599731445
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 185))) 0.00024890899658203
(116) DESCRIBE `ports` 0.000885009765625
(117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '185') 0.00026297569274902
(118) DESCRIBE `ports` 0.0010299682617188
(119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1440))) 0.00029611587524414
(120) DESCRIBE `ports` 0.00090909004211426
(121) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1440') 0.0002291202545166
(122) DESCRIBE `ports` 0.00089716911315918
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1037))) 0.00022292137145996
(124) DESCRIBE `ports` 0.00081896781921387
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1037') 0.00020694732666016
(126) DESCRIBE `ports` 0.00081896781921387
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 497))) 0.0003049373626709
(128) DESCRIBE `ports` 0.0011389255523682
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '497') 0.0003359317779541
(130) DESCRIBE `ports` 0.00098204612731934
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 734))) 0.0002739429473877
(132) DESCRIBE `ports` 0.00084185600280762
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '734') 0.00022006034851074
(134) DESCRIBE `ports` 0.00081801414489746
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4208))) 0.00024700164794922
(136) DESCRIBE `ports` 0.00085306167602539
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4208') 0.00026416778564453
(138) DESCRIBE `ports` 0.00093507766723633
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0002739429473877
(140) DESCRIBE `ports` 0.00096487998962402
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00026488304138184
(142) DESCRIBE `avid_specials` 0.00082707405090332
(143) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65887 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 35 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.0015029907226562
(144) DESCRIBE `cruiselines` 0.0014669895172119
(145) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00035309791564941
(146) DESCRIBE `orchid_image` 0.0012209415435791
(147) DESCRIBE `cruiselines` 0.0013129711151123
(148) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00023388862609863
(149) DESCRIBE `cruises` 0.0014641284942627
(150) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65888') 0.0002739429473877
(151) DESCRIBE `ships` 0.0015859603881836
(152) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00029420852661133
(153) DESCRIBE `ships` 0.0011758804321289
(154) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00030994415283203
(155) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016403198242188
(156) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001518726348877
(157) DESCRIBE `itineraries` 0.00077009201049805
(158) DESCRIBE `ports` 0.00069403648376465
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0002288818359375
(160) DESCRIBE `ports` 0.00076794624328613
(161) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00020003318786621
(162) DESCRIBE `ports` 0.00061392784118652
(163) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00017809867858887
(164) DESCRIBE `sailingdates` 0.00068497657775879
(165) DESCRIBE `ports` 0.00077486038208008
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031304359436035
(167) DESCRIBE `ports` 0.00085997581481934
(168) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00021696090698242
(169) DESCRIBE `ports` 0.00080299377441406
(170) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00024294853210449
(171) DESCRIBE `ports` 0.00084900856018066
(172) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.0002129077911377
(173) DESCRIBE `ports` 0.0008091926574707
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 437))) 0.00026202201843262
(175) DESCRIBE `ports` 0.00092101097106934
(176) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '437') 0.00021791458129883
(177) DESCRIBE `ports` 0.0008399486541748
(178) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00027799606323242
(179) DESCRIBE `ports` 0.00082898139953613
(180) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00028014183044434
(181) DESCRIBE `ports` 0.001039981842041
(182) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00025701522827148
(183) DESCRIBE `ports` 0.00093603134155273
(184) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00023102760314941
(185) DESCRIBE `ports` 0.00087094306945801
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030303001403809
(187) DESCRIBE `ports` 0.00097393989562988
(188) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00024104118347168
(189) DESCRIBE `avid_specials` 0.00080013275146484
(190) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65888 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 43 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.0013968944549561
(191) DESCRIBE `cruiselines` 0.0012669563293457
(192) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00031208992004395
(193) DESCRIBE `orchid_image` 0.0012080669403076
(194) DESCRIBE `cruiselines` 0.0015149116516113
(195) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00029611587524414
(196) DESCRIBE `cruises` 0.0021650791168213
(197) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '41778') 0.0003349781036377
(198) DESCRIBE `ships` 0.0019760131835938
(199) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00042390823364258
(200) DESCRIBE `ships` 0.0020899772644043
(201) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00031089782714844
(202) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021004676818848
(203) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019502639770508
(204) DESCRIBE `itineraries` 0.0011000633239746
(205) DESCRIBE `ports` 0.0012459754943848
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030207633972168
(207) DESCRIBE `ports` 0.00089216232299805
(208) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00023198127746582
(209) DESCRIBE `ports` 0.0009000301361084
(210) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00022697448730469
(211) DESCRIBE `sailingdates` 0.00078010559082031
(212) DESCRIBE `ports` 0.0011348724365234
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029993057250977
(214) DESCRIBE `ports` 0.00088214874267578
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0002129077911377
(216) DESCRIBE `ports` 0.00087904930114746
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.000244140625
(218) DESCRIBE `ports` 0.00088691711425781
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00023698806762695
(220) DESCRIBE `avid_specials` 0.00090289115905762
(221) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 41778 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 8 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.00160813331604
(222) DESCRIBE `cruiselines` 0.0013329982757568
(223) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00030183792114258
(224) DESCRIBE `orchid_image` 0.00095820426940918
(225) DESCRIBE `cruiselines` 0.0011360645294189
(226) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00025415420532227
(227) DESCRIBE `cruises` 0.0015270709991455
(228) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '41780') 0.00025105476379395
(229) DESCRIBE `ships` 0.0015811920166016
(230) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.0003049373626709
(231) DESCRIBE `ships` 0.001460075378418
(232) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.000244140625
(233) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016307830810547
(234) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00015687942504883
(235) DESCRIBE `itineraries` 0.00090694427490234
(236) DESCRIBE `ports` 0.00069904327392578
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00033712387084961
(238) DESCRIBE `ports` 0.00092911720275879
(239) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00025010108947754
(240) DESCRIBE `ports` 0.0006718635559082
(241) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00019502639770508
(242) DESCRIBE `sailingdates` 0.00056600570678711
(243) DESCRIBE `ports` 0.00097203254699707
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00021791458129883
(245) DESCRIBE `ports` 0.0007319450378418
(246) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0001838207244873
(247) DESCRIBE `ports` 0.00076889991760254
(248) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00020194053649902
(249) DESCRIBE `ports` 0.00061988830566406
(250) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00019598007202148
(251) DESCRIBE `ports` 0.00074410438537598
(252) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00023102760314941
(253) DESCRIBE `ports` 0.0008540153503418
(254) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00021195411682129
(255) DESCRIBE `ports` 0.00086498260498047
(256) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00024509429931641
(257) DESCRIBE `ports` 0.00084304809570312
(258) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00021100044250488
(259) DESCRIBE `ports` 0.00070285797119141
(260) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00020909309387207
(261) DESCRIBE `ports` 0.00059103965759277
(262) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00016117095947266
(263) DESCRIBE `avid_specials` 0.0005340576171875
(264) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 41780 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 43 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.00089597702026367
(265) DESCRIBE `cruiselines` 0.0010180473327637
(266) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00025796890258789
(267) DESCRIBE `orchid_image` 0.00074601173400879
(268) DESCRIBE `cruiselines` 0.0010871887207031
(269) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00025391578674316
(270) DESCRIBE `cruises` 0.0014920234680176
(271) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63370') 0.00022506713867188
(272) DESCRIBE `ships` 0.0014119148254395
(273) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00024700164794922
(274) DESCRIBE `ships` 0.0013718605041504
(275) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00025105476379395
(276) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00024890899658203
(277) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018405914306641
(278) DESCRIBE `itineraries` 0.00082111358642578
(279) DESCRIBE `ports` 0.00082993507385254
(280) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00024795532226562
(281) DESCRIBE `ports` 0.00078415870666504
(282) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00022196769714355
(283) DESCRIBE `ports` 0.00079917907714844
(284) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00020694732666016
(285) DESCRIBE `sailingdates` 0.00070405006408691
(286) DESCRIBE `ports` 0.00079107284545898
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00023484230041504
(288) DESCRIBE `ports` 0.00078415870666504
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00020194053649902
(290) DESCRIBE `ports` 0.00078105926513672
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00021910667419434
(292) DESCRIBE `ports` 0.00078916549682617
(293) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00020599365234375
(294) DESCRIBE `ports` 0.000885009765625
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00022196769714355
(296) DESCRIBE `ports` 0.00083398818969727
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00019717216491699
(298) DESCRIBE `ports` 0.00078892707824707
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00022315979003906
(300) DESCRIBE `ports` 0.00079703330993652
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00019693374633789
(302) DESCRIBE `ports` 0.00078701972961426
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00022196769714355
(304) DESCRIBE `ports` 0.00078797340393066
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.0001978874206543
(306) DESCRIBE `ports` 0.0007789134979248
(307) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00022411346435547
(308) DESCRIBE `ports` 0.00095391273498535
(309) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0002281665802002
(310) DESCRIBE `avid_specials` 0.00071191787719727
(311) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63370 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 43 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.001439094543457
(312) DESCRIBE `cruiselines` 0.0012190341949463
(313) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00027894973754883
(314) DESCRIBE `orchid_image` 0.00087690353393555
(315) DESCRIBE `cruiselines` 0.001133918762207
(316) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.0002291202545166
(317) DESCRIBE `cruises` 0.0015578269958496
(318) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65889') 0.00024580955505371
(319) DESCRIBE `ships` 0.0015580654144287
(320) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00030708312988281
(321) DESCRIBE `ships` 0.0015270709991455
(322) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00027084350585938
(323) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021004676818848
(324) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021195411682129
(325) DESCRIBE `itineraries` 0.0009620189666748
(326) DESCRIBE `ports` 0.00091099739074707
(327) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00027012825012207
(328) DESCRIBE `ports` 0.00071907043457031
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00018596649169922
(330) DESCRIBE `ports` 0.0006561279296875
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00017404556274414
(332) DESCRIBE `sailingdates` 0.00062108039855957
(333) DESCRIBE `ports` 0.0007321834564209
(334) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00022411346435547
(335) DESCRIBE `ports` 0.00085997581481934
(336) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00020003318786621
(337) DESCRIBE `ports` 0.00080585479736328
(338) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00018405914306641
(339) DESCRIBE `ports` 0.0009300708770752
(340) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.0001981258392334
(341) DESCRIBE `ports` 0.00062298774719238
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00023603439331055
(343) DESCRIBE `ports` 0.00060009956359863
(344) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00016307830810547
(345) DESCRIBE `ports` 0.00058698654174805
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 437))) 0.00018095970153809
(347) DESCRIBE `ports` 0.00078082084655762
(348) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '437') 0.00016307830810547
(349) DESCRIBE `ports` 0.00058889389038086
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00018692016601562
(351) DESCRIBE `ports` 0.0007469654083252
(352) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.0001990795135498
(353) DESCRIBE `ports` 0.00081610679626465
(354) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00027108192443848
(355) DESCRIBE `ports` 0.00071597099304199
(356) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00016999244689941
(357) DESCRIBE `avid_specials` 0.0007319450378418
(358) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65889 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 43 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.0012879371643066
(359) DESCRIBE `cruiselines` 0.0013220310211182
(360) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00022292137145996
(361) DESCRIBE `orchid_image` 0.00097298622131348
(362) DESCRIBE `cruiselines` 0.0012719631195068
(363) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00026392936706543
(364) DESCRIBE `cruises` 0.0015659332275391
(365) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '50857') 0.00026798248291016
(366) DESCRIBE `ships` 0.0016889572143555
(367) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00035500526428223
(368) DESCRIBE `ships` 0.0018069744110107
(369) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.0002739429473877
(370) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018501281738281
(371) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019478797912598
(372) DESCRIBE `itineraries` 0.001007080078125
(373) DESCRIBE `ports` 0.00089597702026367
(374) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00028705596923828
(375) DESCRIBE `ports` 0.00084495544433594
(376) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00024318695068359
(377) DESCRIBE `ports` 0.00081896781921387
(378) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00021982192993164
(379) DESCRIBE `sailingdates` 0.00077390670776367
(380) DESCRIBE `ports` 0.0011570453643799
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00028300285339355
(382) DESCRIBE `ports` 0.00083398818969727
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00022411346435547
(384) DESCRIBE `ports` 0.00087499618530273
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00026679039001465
(386) DESCRIBE `ports` 0.00091981887817383
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00023508071899414
(388) DESCRIBE `ports` 0.00082898139953613
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00023508071899414
(390) DESCRIBE `ports` 0.00062012672424316
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00017404556274414
(392) DESCRIBE `ports` 0.00075912475585938
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00025200843811035
(394) DESCRIBE `ports` 0.00068783760070801
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.0002129077911377
(396) DESCRIBE `ports` 0.00085592269897461
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00019192695617676
(398) DESCRIBE `ports` 0.00087213516235352
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00017094612121582
(400) DESCRIBE `ports` 0.00059604644775391
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00018310546875
(402) DESCRIBE `ports` 0.00080299377441406
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00017285346984863
(404) DESCRIBE `avid_specials` 0.00076103210449219
(405) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 50857 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 43 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.0011370182037354
(406) DESCRIBE `cruiselines` 0.0010068416595459
(407) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00021505355834961
(408) DESCRIBE `orchid_image` 0.00076699256896973
(409) DESCRIBE `cruiselines` 0.00087404251098633
(410) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00019311904907227
(411) DESCRIBE `cruises` 0.0011360645294189
(412) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '41776') 0.00024700164794922
(413) DESCRIBE `ships` 0.0015368461608887
(414) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00032305717468262
(415) DESCRIBE `ships` 0.0016839504241943
(416) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00024795532226562
(417) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020194053649902
(418) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019097328186035
(419) DESCRIBE `itineraries` 0.00086307525634766
(420) DESCRIBE `ports` 0.00064516067504883
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00022101402282715
(422) DESCRIBE `ports` 0.00071811676025391
(423) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00026702880859375
(424) DESCRIBE `ports` 0.00070500373840332
(425) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00020384788513184
(426) DESCRIBE `sailingdates` 0.00054001808166504
(427) DESCRIBE `ports` 0.0008699893951416
(428) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00023794174194336
(429) DESCRIBE `ports` 0.0008549690246582
(430) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00019598007202148
(431) DESCRIBE `ports` 0.00086402893066406
(432) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00024294853210449
(433) DESCRIBE `ports` 0.00085997581481934
(434) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00021910667419434
(435) DESCRIBE `ports` 0.00090694427490234
(436) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00023698806762695
(437) DESCRIBE `ports` 0.00086593627929688
(438) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00021100044250488
(439) DESCRIBE `ports` 0.00088906288146973
(440) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00024509429931641
(441) DESCRIBE `ports` 0.00075793266296387
(442) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00017213821411133
(443) DESCRIBE `ports` 0.00064611434936523
(444) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00021600723266602
(445) DESCRIBE `ports` 0.00059604644775391
(446) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00017905235290527
(447) DESCRIBE `avid_specials` 0.00054311752319336
(448) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 41776 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 43 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.0010261535644531
(449) DESCRIBE `cruiselines` 0.00089383125305176
(450) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00021600723266602
(451) DESCRIBE `orchid_image` 0.00072312355041504
(452) DESCRIBE `cruiselines` 0.00087189674377441
(453) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00020503997802734
(454) DESCRIBE `ships` 0.0014569759368896
(455) SELECT `ships`.* FROM `ships` WHERE (id IN ('4', '288', '1722')) ORDER BY FIND_IN_SET(id, '4,288,1722') 0.00054502487182617
(456) DESCRIBE `cruisetypes` 0.00060486793518066
(457) DESCRIBE `destinations` 0.00078487396240234
(458) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '8', '35')) ORDER BY FIND_IN_SET(id, '43,8,35') 0.00032711029052734
(459) DESCRIBE `cruiselines` 0.00090694427490234
(460) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00022721290588379
(461) DESCRIBE `cruiselines` 0.0008699893951416
(462) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00019001960754395