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

Total elapsed time: 0.24737906455994

# Query Time
(1) connect 0.00063705444335938
(2) DESCRIBE `cruises` 0.002202033996582
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (70311, 71396, 67149, 62161, 64368, 67247, 67177, 62580, 65476, 67147)) ORDER BY FIND_IN_SET(id, '70311,71396,67149,62161,64368,67247,67177,62580,65476,67147') 0.0014998912811279
(4) DESCRIBE `cruises` 0.0022068023681641
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70311') 0.0004420280456543
(6) DESCRIBE `ships` 0.0017960071563721
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1284))) 0.00030684471130371
(8) DESCRIBE `ships` 0.001410961151123
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1284') 0.00023484230041504
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00017595291137695
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00016498565673828
(12) DESCRIBE `itineraries` 0.00078105926513672
(13) DESCRIBE `ports` 0.00078320503234863
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00024509429931641
(15) DESCRIBE `ports` 0.00070405006408691
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00020599365234375
(17) DESCRIBE `ports` 0.00067400932312012
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00019693374633789
(19) DESCRIBE `sailingdates` 0.00061392784118652
(20) DESCRIBE `ports` 0.00069689750671387
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.0002129077911377
(22) DESCRIBE `ports` 0.00066781044006348
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00018692016601562
(24) DESCRIBE `ports` 0.00068807601928711
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1901))) 0.00021100044250488
(26) DESCRIBE `ports` 0.00066184997558594
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1901') 0.00018191337585449
(28) DESCRIBE `ports` 0.00066494941711426
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1902))) 0.00020790100097656
(30) DESCRIBE `ports` 0.00070691108703613
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1902') 0.00018501281738281
(32) DESCRIBE `ports` 0.00066685676574707
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 437))) 0.00020313262939453
(34) DESCRIBE `ports` 0.00070095062255859
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '437') 0.0001828670501709
(36) DESCRIBE `ports` 0.00067496299743652
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00020408630371094
(38) DESCRIBE `ports` 0.00066518783569336
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00018191337585449
(40) DESCRIBE `ports` 0.00068998336791992
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00020408630371094
(42) DESCRIBE `ports` 0.0006871223449707
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.0001828670501709
(44) DESCRIBE `ports` 0.00066995620727539
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00022196769714355
(46) DESCRIBE `ports` 0.00069904327392578
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00018405914306641
(48) DESCRIBE `avid_specials` 0.00067305564880371
(49) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70311 and class = 'Cruise') OR (item_id = 1284 AND class = 'Ship') OR (item_id = 37 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.0011138916015625
(50) DESCRIBE `cruiselines` 0.0010020732879639
(51) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00023388862609863
(52) DESCRIBE `orchid_image` 0.00076007843017578
(53) DESCRIBE `cruiselines` 0.0010251998901367
(54) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00019598007202148
(55) DESCRIBE `cruises` 0.0012490749359131
(56) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71396') 0.00021696090698242
(57) DESCRIBE `ships` 0.001352071762085
(58) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1285))) 0.0002601146697998
(59) DESCRIBE `ships` 0.0012941360473633
(60) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1285') 0.00020384788513184
(61) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00018191337585449
(62) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00016999244689941
(63) DESCRIBE `itineraries` 0.00067996978759766
(64) DESCRIBE `ports` 0.00072407722473145
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0002739429473877
(66) DESCRIBE `ports` 0.00067710876464844
(67) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00020694732666016
(68) DESCRIBE `ports` 0.00070095062255859
(69) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00020599365234375
(70) DESCRIBE `sailingdates` 0.00060296058654785
(71) DESCRIBE `ports` 0.00072717666625977
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00025486946105957
(73) DESCRIBE `ports` 0.00069284439086914
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00019097328186035
(75) DESCRIBE `ports` 0.00066900253295898
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00020003318786621
(77) DESCRIBE `ports` 0.00066995620727539
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00021505355834961
(79) DESCRIBE `ports` 0.00070309638977051
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 0.00021004676818848
(81) DESCRIBE `ports` 0.00066804885864258
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.00018596649169922
(83) DESCRIBE `ports` 0.00070095062255859
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00020194053649902
(85) DESCRIBE `ports` 0.00066900253295898
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00018095970153809
(87) DESCRIBE `ports` 0.00068879127502441
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.0001990795135498
(89) DESCRIBE `ports` 0.00072789192199707
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00022292137145996
(91) DESCRIBE `ports` 0.00083398818969727
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.0002140998840332
(93) DESCRIBE `ports` 0.00067901611328125
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00019192695617676
(95) DESCRIBE `ports` 0.00075101852416992
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00020980834960938
(97) DESCRIBE `ports` 0.00066900253295898
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00019192695617676
(99) DESCRIBE `avid_specials` 0.00062990188598633
(100) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 71396 and class = 'Cruise') OR (item_id = 1285 AND class = 'Ship') OR (item_id = 37 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.00098204612731934
(101) DESCRIBE `cruiselines` 0.00096988677978516
(102) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00022482872009277
(103) DESCRIBE `orchid_image` 0.00080299377441406
(104) DESCRIBE `cruiselines` 0.00091814994812012
(105) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00020003318786621
(106) DESCRIBE `cruises` 0.0012469291687012
(107) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67149') 0.00027108192443848
(108) DESCRIBE `ships` 0.0014820098876953
(109) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 765))) 0.00028109550476074
(110) DESCRIBE `ships` 0.0015048980712891
(111) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '765') 0.00022983551025391
(112) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00017499923706055
(113) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00016307830810547
(114) DESCRIBE `itineraries` 0.00069618225097656
(115) DESCRIBE `ports` 0.00069308280944824
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0002591609954834
(117) DESCRIBE `ports` 0.00067400932312012
(118) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00020313262939453
(119) DESCRIBE `ports` 0.00068497657775879
(120) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00018501281738281
(121) DESCRIBE `sailingdates` 0.0006258487701416
(122) DESCRIBE `ports` 0.00073480606079102
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00024604797363281
(124) DESCRIBE `ports` 0.00068402290344238
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00019383430480957
(126) DESCRIBE `ports` 0.00065803527832031
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00021100044250488
(128) DESCRIBE `ports` 0.000701904296875
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00018477439880371
(130) DESCRIBE `ports` 0.00067591667175293
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00020503997802734
(132) DESCRIBE `ports` 0.0007178783416748
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00024199485778809
(134) DESCRIBE `ports` 0.00066804885864258
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 0.00022077560424805
(136) DESCRIBE `ports` 0.00072908401489258
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.00021195411682129
(138) DESCRIBE `ports` 0.00065994262695312
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00020217895507812
(140) DESCRIBE `ports` 0.00066900253295898
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00018191337585449
(142) DESCRIBE `ports` 0.00068902969360352
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00020194053649902
(144) DESCRIBE `ports` 0.0006568431854248
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00017690658569336
(146) DESCRIBE `avid_specials` 0.00063490867614746
(147) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67149 and class = 'Cruise') OR (item_id = 765 AND class = 'Ship') OR (item_id = 37 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.0012450218200684
(148) DESCRIBE `cruiselines` 0.0013749599456787
(149) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00025200843811035
(150) DESCRIBE `orchid_image` 0.00076389312744141
(151) DESCRIBE `cruiselines` 0.00095582008361816
(152) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00025105476379395
(153) DESCRIBE `cruises` 0.00152587890625
(154) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62161') 0.00024008750915527
(155) DESCRIBE `ships` 0.001352071762085
(156) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1402))) 0.00031685829162598
(157) DESCRIBE `ships` 0.0012860298156738
(158) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1402') 0.00022196769714355
(159) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00017786026000977
(160) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00016403198242188
(161) DESCRIBE `itineraries` 0.00072598457336426
(162) DESCRIBE `ports` 0.00069212913513184
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00022196769714355
(164) DESCRIBE `ports` 0.0006709098815918
(165) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0001990795135498
(166) DESCRIBE `ports` 0.0006721019744873
(167) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0001990795135498
(168) DESCRIBE `sailingdates` 0.00066399574279785
(169) DESCRIBE `ports` 0.00086498260498047
(170) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00026106834411621
(171) DESCRIBE `ports` 0.00093197822570801
(172) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0001978874206543
(173) DESCRIBE `ports` 0.00067496299743652
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4450))) 0.00020384788513184
(175) DESCRIBE `ports` 0.00067496299743652
(176) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4450') 0.00019407272338867
(177) DESCRIBE `ports` 0.0006868839263916
(178) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00020909309387207
(179) DESCRIBE `ports` 0.00069189071655273
(180) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018692016601562
(181) DESCRIBE `avid_specials` 0.0006251335144043
(182) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62161 and class = 'Cruise') OR (item_id = 1402 AND class = 'Ship') OR (item_id = 37 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.0011141300201416
(183) DESCRIBE `cruiselines` 0.0012140274047852
(184) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00024604797363281
(185) DESCRIBE `orchid_image` 0.00082492828369141
(186) DESCRIBE `cruiselines` 0.0010359287261963
(187) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.0002291202545166
(188) DESCRIBE `cruises` 0.0012969970703125
(189) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64368') 0.00025105476379395
(190) DESCRIBE `ships` 0.0015969276428223
(191) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 573))) 0.00025606155395508
(192) DESCRIBE `ships` 0.00136399269104
(193) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '573') 0.00022411346435547
(194) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017499923706055
(195) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016212463378906
(196) DESCRIBE `itineraries` 0.00077581405639648
(197) DESCRIBE `ports` 0.00074887275695801
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00023198127746582
(199) DESCRIBE `ports` 0.00070691108703613
(200) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00021195411682129
(201) DESCRIBE `ports` 0.00077700614929199
(202) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00020503997802734
(203) DESCRIBE `sailingdates` 0.00066399574279785
(204) DESCRIBE `ports` 0.00098609924316406
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00026798248291016
(206) DESCRIBE `ports` 0.00091910362243652
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.0002138614654541
(208) DESCRIBE `ports` 0.00068211555480957
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00025200843811035
(210) DESCRIBE `ports` 0.00068402290344238
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00018596649169922
(212) DESCRIBE `ports` 0.00067496299743652
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00021600723266602
(214) DESCRIBE `ports` 0.00068306922912598
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00019001960754395
(216) DESCRIBE `ports` 0.00069785118103027
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 0.00021004676818848
(218) DESCRIBE `ports` 0.00074386596679688
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.00020503997802734
(220) DESCRIBE `ports` 0.00075697898864746
(221) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00021600723266602
(222) DESCRIBE `ports` 0.00067782402038574
(223) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00018501281738281
(224) DESCRIBE `avid_specials` 0.00064301490783691
(225) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 64368 and class = 'Cruise') OR (item_id = 573 AND class = 'Ship') OR (item_id = 37 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.00097799301147461
(226) DESCRIBE `cruiselines` 0.001032829284668
(227) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00026106834411621
(228) DESCRIBE `orchid_image` 0.00081801414489746
(229) DESCRIBE `cruiselines` 0.0010790824890137
(230) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00021696090698242
(231) DESCRIBE `cruises` 0.0012650489807129
(232) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67247') 0.00023102760314941
(233) DESCRIBE `ships` 0.0013101100921631
(234) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1402))) 0.00029087066650391
(235) DESCRIBE `ships` 0.001352071762085
(236) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1402') 0.00020885467529297
(237) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00020098686218262
(238) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00016999244689941
(239) DESCRIBE `itineraries` 0.00068092346191406
(240) DESCRIBE `ports` 0.00069189071655273
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00022220611572266
(242) DESCRIBE `ports` 0.00077009201049805
(243) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00022602081298828
(244) DESCRIBE `ports` 0.00075602531433105
(245) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00019693374633789
(246) DESCRIBE `sailingdates` 0.00061607360839844
(247) DESCRIBE `ports` 0.00087904930114746
(248) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00024795532226562
(249) DESCRIBE `ports` 0.00071001052856445
(250) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00019502639770508
(251) DESCRIBE `ports` 0.00067496299743652
(252) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.0002129077911377
(253) DESCRIBE `ports` 0.00076484680175781
(254) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00034189224243164
(255) DESCRIBE `ports` 0.00089097023010254
(256) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.0002138614654541
(257) DESCRIBE `ports` 0.00067996978759766
(258) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00018882751464844
(259) DESCRIBE `ports` 0.00067591667175293
(260) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 0.00022602081298828
(261) DESCRIBE `ports` 0.00074410438537598
(262) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.00018191337585449
(263) DESCRIBE `ports` 0.00068306922912598
(264) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00020003318786621
(265) DESCRIBE `ports` 0.00069308280944824
(266) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00018906593322754
(267) DESCRIBE `ports` 0.0009148120880127
(268) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.0002288818359375
(269) DESCRIBE `ports` 0.00069093704223633
(270) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00018405914306641
(271) DESCRIBE `ports` 0.00066804885864258
(272) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00020718574523926
(273) DESCRIBE `ports` 0.00066900253295898
(274) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00019598007202148
(275) DESCRIBE `avid_specials` 0.00064587593078613
(276) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67247 and class = 'Cruise') OR (item_id = 1402 AND class = 'Ship') OR (item_id = 37 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.0010027885437012
(277) DESCRIBE `cruiselines` 0.00098490715026855
(278) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00022292137145996
(279) DESCRIBE `orchid_image` 0.00076198577880859
(280) DESCRIBE `cruiselines` 0.00093197822570801
(281) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00018191337585449
(282) DESCRIBE `cruises` 0.0013549327850342
(283) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67177') 0.00019502639770508
(284) DESCRIBE `ships` 0.0012760162353516
(285) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1284))) 0.00023818016052246
(286) DESCRIBE `ships` 0.0012409687042236
(287) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1284') 0.00018000602722168
(288) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00020384788513184
(289) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00017380714416504
(290) DESCRIBE `itineraries` 0.0006721019744873
(291) DESCRIBE `ports` 0.00067496299743652
(292) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.0002140998840332
(293) DESCRIBE `ports` 0.00066900253295898
(294) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00020194053649902
(295) DESCRIBE `ports` 0.0006721019744873
(296) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00018811225891113
(297) DESCRIBE `sailingdates` 0.0006101131439209
(298) DESCRIBE `ports` 0.00073981285095215
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00020599365234375
(300) DESCRIBE `ports` 0.00068211555480957
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00018501281738281
(302) DESCRIBE `ports` 0.00069403648376465
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 499))) 0.00020790100097656
(304) DESCRIBE `ports` 0.00066995620727539
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '499') 0.0001828670501709
(306) DESCRIBE `ports` 0.00066399574279785
(307) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00020217895507812
(308) DESCRIBE `ports` 0.00071501731872559
(309) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.0001828670501709
(310) DESCRIBE `ports` 0.00068402290344238
(311) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 121))) 0.00020289421081543
(312) DESCRIBE `ports` 0.00086593627929688
(313) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '121') 0.00019693374633789
(314) DESCRIBE `ports` 0.00069093704223633
(315) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00021505355834961
(316) DESCRIBE `ports` 0.00067520141601562
(317) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00018310546875
(318) DESCRIBE `avid_specials` 0.0006871223449707
(319) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67177 and class = 'Cruise') OR (item_id = 1284 AND class = 'Ship') OR (item_id = 37 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.0010058879852295
(320) DESCRIBE `cruiselines` 0.00099587440490723
(321) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00022506713867188
(322) DESCRIBE `orchid_image` 0.00079512596130371
(323) DESCRIBE `cruiselines` 0.00091409683227539
(324) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00019598007202148
(325) DESCRIBE `cruises` 0.001276969909668
(326) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62580') 0.00020408630371094
(327) DESCRIBE `ships` 0.0012450218200684
(328) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 765))) 0.00024890899658203
(329) DESCRIBE `ships` 0.0013391971588135
(330) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '765') 0.00019192695617676
(331) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0001838207244873
(332) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0001838207244873
(333) DESCRIBE `itineraries` 0.00068902969360352
(334) DESCRIBE `ports` 0.0006859302520752
(335) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00021600723266602
(336) DESCRIBE `ports` 0.0006709098815918
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00019979476928711
(338) DESCRIBE `ports` 0.00067496299743652
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00018405914306641
(340) DESCRIBE `sailingdates` 0.00060391426086426
(341) DESCRIBE `ports` 0.00075292587280273
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00021195411682129
(343) DESCRIBE `ports` 0.0007171630859375
(344) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00018715858459473
(345) DESCRIBE `ports` 0.00066900253295898
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00023698806762695
(347) DESCRIBE `ports` 0.00067901611328125
(348) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00018715858459473
(349) DESCRIBE `avid_specials` 0.00060915946960449
(350) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62580 and class = 'Cruise') OR (item_id = 765 AND class = 'Ship') OR (item_id = 37 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.00096392631530762
(351) DESCRIBE `cruiselines` 0.001032829284668
(352) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00023412704467773
(353) DESCRIBE `orchid_image` 0.00076794624328613
(354) DESCRIBE `cruiselines` 0.00095081329345703
(355) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00019407272338867
(356) DESCRIBE `cruises` 0.0012550354003906
(357) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65476') 0.00022196769714355
(358) DESCRIBE `ships` 0.0013198852539062
(359) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1285))) 0.00026106834411621
(360) DESCRIBE `ships` 0.0012879371643066
(361) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1285') 0.00018501281738281
(362) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00018596649169922
(363) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00017189979553223
(364) DESCRIBE `itineraries` 0.00067615509033203
(365) DESCRIBE `ports` 0.00080704689025879
(366) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00023794174194336
(367) DESCRIBE `ports` 0.00075888633728027
(368) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00020694732666016
(369) DESCRIBE `ports` 0.00067496299743652
(370) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00021696090698242
(371) DESCRIBE `sailingdates` 0.00065398216247559
(372) DESCRIBE `ports` 0.0006868839263916
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00021100044250488
(374) DESCRIBE `ports` 0.0006859302520752
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018405914306641
(376) DESCRIBE `ports` 0.00068998336791992
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00020098686218262
(378) DESCRIBE `ports` 0.00067496299743652
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018405914306641
(380) DESCRIBE `avid_specials` 0.0006718635559082
(381) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65476 and class = 'Cruise') OR (item_id = 1285 AND class = 'Ship') OR (item_id = 37 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.00097298622131348
(382) DESCRIBE `cruiselines` 0.00096988677978516
(383) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00021505355834961
(384) DESCRIBE `orchid_image` 0.00077104568481445
(385) DESCRIBE `cruiselines` 0.00091099739074707
(386) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00023698806762695
(387) DESCRIBE `cruises` 0.0012919902801514
(388) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67147') 0.00021910667419434
(389) DESCRIBE `ships` 0.0014159679412842
(390) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 765))) 0.0002739429473877
(391) DESCRIBE `ships` 0.0014729499816895
(392) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '765') 0.00022315979003906
(393) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00017905235290527
(394) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00022101402282715
(395) DESCRIBE `itineraries` 0.00098299980163574
(396) DESCRIBE `ports` 0.00072312355041504
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00021100044250488
(398) DESCRIBE `ports` 0.00070595741271973
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00019288063049316
(400) DESCRIBE `ports` 0.00069594383239746
(401) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00020408630371094
(402) DESCRIBE `sailingdates` 0.00078606605529785
(403) DESCRIBE `ports` 0.00075292587280273
(404) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00021505355834961
(405) DESCRIBE `ports` 0.00070095062255859
(406) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00018095970153809
(407) DESCRIBE `ports` 0.00066494941711426
(408) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00020694732666016
(409) DESCRIBE `ports` 0.00068497657775879
(410) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00017499923706055
(411) DESCRIBE `ports` 0.00066804885864258
(412) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00019383430480957
(413) DESCRIBE `ports` 0.00066900253295898
(414) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00024104118347168
(415) DESCRIBE `ports` 0.00087690353393555
(416) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00022196769714355
(417) DESCRIBE `ports` 0.00067305564880371
(418) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00017809867858887
(419) DESCRIBE `ports` 0.00066518783569336
(420) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 0.00019407272338867
(421) DESCRIBE `ports` 0.00066018104553223
(422) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.00020194053649902
(423) DESCRIBE `ports` 0.00066590309143066
(424) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.0001978874206543
(425) DESCRIBE `ports` 0.00066399574279785
(426) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00022506713867188
(427) DESCRIBE `ports` 0.0006568431854248
(428) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00019502639770508
(429) DESCRIBE `ports` 0.00065994262695312
(430) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00017189979553223
(431) DESCRIBE `avid_specials` 0.00063395500183105
(432) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67147 and class = 'Cruise') OR (item_id = 765 AND class = 'Ship') OR (item_id = 37 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.00096607208251953
(433) DESCRIBE `cruiselines` 0.00096487998962402
(434) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00020980834960938
(435) DESCRIBE `orchid_image` 0.00078105926513672
(436) DESCRIBE `cruiselines` 0.00095701217651367
(437) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00019621849060059
(438) DESCRIBE `ships` 0.0015161037445068
(439) SELECT `ships`.* FROM `ships` WHERE (id IN ('573', '1402', '765', '1284', '1285')) ORDER BY FIND_IN_SET(id, '573,1402,765,1284,1285') 0.00050997734069824
(440) DESCRIBE `cruisetypes` 0.00061607360839844
(441) DESCRIBE `destinations` 0.00098395347595215
(442) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('8', '43', '35')) ORDER BY FIND_IN_SET(id, '8,43,35') 0.00043201446533203
(443) DESCRIBE `cruiselines` 0.0010039806365967
(444) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00024008750915527
(445) DESCRIBE `cruiselines` 0.0010669231414795
(446) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00023221969604492