or, enquire about your chosen options

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

Sign up to our newsletter and become the first to know about our latest deals and promotions

 
 

Please note, while cruise details and inclusions are accurate at time of loading they are subject to change due to changes in cruise line practices and policies. Please check details and inclusions at time of booking.

Database Profiling Report

Total queries executed: 834

Total elapsed time: 1.8656280040741

# Query Time
(1) connect 0.0020267963409424
(2) DESCRIBE `cruises` 0.012342214584351
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (78572, 70003, 78402, 70017, 70068, 81916, 69996, 69999, 78508, 78560)) ORDER BY FIND_IN_SET(id, '78572,70003,78402,70017,70068,81916,69996,69999,78508,78560') 0.0077199935913086
(4) DESCRIBE `cruises` 0.023865938186646
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '78572') 0.008735179901123
(6) DESCRIBE `ships` 0.014326095581055
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 983))) 0.020879030227661
(8) DESCRIBE `ships` 0.017709970474243
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '983') 0.0031149387359619
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00045394897460938
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00042891502380371
(12) DESCRIBE `itineraries` 0.0090408325195312
(13) DESCRIBE `ports` 0.0032119750976562
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.010326147079468
(15) DESCRIBE `ports` 0.0030288696289062
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.0007169246673584
(17) DESCRIBE `ports` 0.0028648376464844
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.003964900970459
(19) DESCRIBE `sailingdates` 0.0097420215606689
(20) DESCRIBE `ports` 0.0043649673461914
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.0085678100585938
(22) DESCRIBE `ports` 0.0027408599853516
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00061988830566406
(24) DESCRIBE `ports` 0.0027849674224854
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00063490867614746
(26) DESCRIBE `ports` 0.0029881000518799
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00061607360839844
(28) DESCRIBE `ports` 0.0029270648956299
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.0014839172363281
(30) DESCRIBE `ports` 0.024144887924194
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.0058181285858154
(32) DESCRIBE `ports` 0.0028119087219238
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.0083870887756348
(34) DESCRIBE `ports` 0.0026969909667969
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.0006248950958252
(36) DESCRIBE `ports` 0.003014087677002
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.005601167678833
(38) DESCRIBE `ports` 0.0028510093688965
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.0096900463104248
(40) DESCRIBE `ports` 0.0029890537261963
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2946))) 0.00072193145751953
(42) DESCRIBE `ports` 0.008012056350708
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2946') 0.00068998336791992
(44) DESCRIBE `ports` 0.002863883972168
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1586))) 0.0015740394592285
(46) DESCRIBE `ports` 0.0039360523223877
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1586') 0.00077199935913086
(48) DESCRIBE `ports` 0.011127948760986
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1585))) 0.00090193748474121
(50) DESCRIBE `ports` 0.0095479488372803
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1585') 0.00067996978759766
(52) DESCRIBE `ports` 0.0092408657073975
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1584))) 0.00080490112304688
(54) DESCRIBE `ports` 0.013386011123657
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1584') 0.00073909759521484
(56) DESCRIBE `ports` 0.0029850006103516
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1583))) 0.011719942092896
(58) DESCRIBE `ports` 0.0056979656219482
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1583') 0.0033459663391113
(60) DESCRIBE `ports` 0.0030689239501953
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1582))) 0.01178503036499
(62) DESCRIBE `ports` 0.0031840801239014
(63) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1582') 0.00063991546630859
(64) DESCRIBE `ports` 0.0028200149536133
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1582))) 0.00076603889465332
(66) DESCRIBE `ports` 0.0034780502319336
(67) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1582') 0.00078487396240234
(68) DESCRIBE `ports` 0.0033650398254395
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1582))) 0.00067591667175293
(70) DESCRIBE `ports` 0.0031599998474121
(71) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1582') 0.00061798095703125
(72) DESCRIBE `ports` 0.0034570693969727
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1582))) 0.0010020732879639
(74) DESCRIBE `ports` 0.0080258846282959
(75) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1582') 0.0012180805206299
(76) DESCRIBE `ports` 0.0035510063171387
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1582))) 0.0017240047454834
(78) DESCRIBE `ports` 0.0056400299072266
(79) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1582') 0.00065302848815918
(80) DESCRIBE `avid_specials` 0.0034840106964111
(81) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 78572 and class = 'Cruise') OR (item_id = 983 AND class = 'Ship') OR (item_id = 156 AND class = 'CruiseLine') OR (item_id = 50 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.0039780139923096
(82) DESCRIBE `cruiselines` 0.0057370662689209
(83) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 156))) 0.00074410438537598
(84) DESCRIBE `orchid_image` 0.0041239261627197
(85) DESCRIBE `cruiselines` 0.0053050518035889
(86) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '156') 0.00069689750671387
(87) DESCRIBE `cruises` 0.0055499076843262
(88) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70003') 0.00059413909912109
(89) DESCRIBE `ships` 0.0061569213867188
(90) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1295))) 0.00089192390441895
(91) DESCRIBE `ships` 0.0066981315612793
(92) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1295') 0.00076389312744141
(93) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00053787231445312
(94) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00052309036254883
(95) DESCRIBE `itineraries` 0.0045340061187744
(96) DESCRIBE `ports` 0.0030999183654785
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00056600570678711
(98) DESCRIBE `ports` 0.0034699440002441
(99) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.0010390281677246
(100) DESCRIBE `ports` 0.0030639171600342
(101) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00059390068054199
(102) DESCRIBE `sailingdates` 0.0024979114532471
(103) DESCRIBE `ports` 0.0029470920562744
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.000701904296875
(105) DESCRIBE `ports` 0.0030767917633057
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00061893463134766
(107) DESCRIBE `ports` 0.0029759407043457
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00065183639526367
(109) DESCRIBE `ports` 0.0030219554901123
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00067400932312012
(111) DESCRIBE `ports` 0.003842830657959
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1592))) 0.0006101131439209
(113) DESCRIBE `ports` 0.0033490657806396
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1592') 0.00061607360839844
(115) DESCRIBE `ports` 0.002755880355835
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1564))) 0.00059294700622559
(117) DESCRIBE `ports` 0.0022470951080322
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1564') 0.00064992904663086
(119) DESCRIBE `ports` 0.0027618408203125
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1600))) 0.00079607963562012
(121) DESCRIBE `ports` 0.0028278827667236
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1600') 0.00090479850769043
(123) DESCRIBE `ports` 0.0031139850616455
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1600))) 0.00080299377441406
(125) DESCRIBE `ports` 0.0027310848236084
(126) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1600') 0.00064897537231445
(127) DESCRIBE `ports` 0.0027761459350586
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1570))) 0.00073599815368652
(129) DESCRIBE `ports` 0.0032939910888672
(130) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1570') 0.00084185600280762
(131) DESCRIBE `ports` 0.0029609203338623
(132) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00086784362792969
(133) DESCRIBE `ports` 0.0029759407043457
(134) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.00063896179199219
(135) DESCRIBE `ports` 0.0028719902038574
(136) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1574))) 0.00072503089904785
(137) DESCRIBE `ports` 0.0027170181274414
(138) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1574') 0.00064611434936523
(139) DESCRIBE `ports` 0.0025069713592529
(140) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00059700012207031
(141) DESCRIBE `ports` 0.0029740333557129
(142) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00079703330993652
(143) DESCRIBE `ports` 0.0041651725769043
(144) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2094))) 0.00082111358642578
(145) DESCRIBE `ports` 0.0033321380615234
(146) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2094') 0.00060606002807617
(147) DESCRIBE `ports` 0.0032110214233398
(148) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1576))) 0.0011920928955078
(149) DESCRIBE `ports` 0.0029458999633789
(150) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1576') 0.00064516067504883
(151) DESCRIBE `ports` 0.0027410984039307
(152) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1601))) 0.00073099136352539
(153) DESCRIBE `ports` 0.0026490688323975
(154) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1601') 0.0010139942169189
(155) DESCRIBE `ports` 0.002561092376709
(156) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00066614151000977
(157) DESCRIBE `ports` 0.0024938583374023
(158) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00063419342041016
(159) DESCRIBE `ports` 0.0029439926147461
(160) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00069308280944824
(161) DESCRIBE `ports` 0.0026590824127197
(162) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00099611282348633
(163) DESCRIBE `ports` 0.002493143081665
(164) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00073409080505371
(165) DESCRIBE `ports` 0.0028719902038574
(166) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00063204765319824
(167) DESCRIBE `ports` 0.0033891201019287
(168) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00072598457336426
(169) DESCRIBE `ports` 0.0025498867034912
(170) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00052499771118164
(171) DESCRIBE `avid_specials` 0.0020918846130371
(172) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70003 and class = 'Cruise') OR (item_id = 1295 AND class = 'Ship') OR (item_id = 156 AND class = 'CruiseLine') OR (item_id = 50 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.0023701190948486
(173) DESCRIBE `cruiselines` 0.0037200450897217
(174) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 156))) 0.00074315071105957
(175) DESCRIBE `orchid_image` 0.0030810832977295
(176) DESCRIBE `cruiselines` 0.004011869430542
(177) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '156') 0.00060510635375977
(178) DESCRIBE `cruises` 0.0062739849090576
(179) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '78402') 0.0005640983581543
(180) DESCRIBE `ships` 0.0056250095367432
(181) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1155))) 0.00088906288146973
(182) DESCRIBE `ships` 0.0057878494262695
(183) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1155') 0.00099802017211914
(184) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00046420097351074
(185) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00045108795166016
(186) DESCRIBE `itineraries` 0.003000020980835
(187) DESCRIBE `ports` 0.0027961730957031
(188) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00060915946960449
(189) DESCRIBE `ports` 0.0031111240386963
(190) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.0006711483001709
(191) DESCRIBE `ports` 0.0024919509887695
(192) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00056314468383789
(193) DESCRIBE `sailingdates` 0.0022990703582764
(194) DESCRIBE `ports` 0.0028789043426514
(195) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00049400329589844
(196) DESCRIBE `ports` 0.0019910335540771
(197) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00049090385437012
(198) DESCRIBE `ports` 0.002479076385498
(199) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00099492073059082
(200) DESCRIBE `ports` 0.0030438899993896
(201) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00066494941711426
(202) DESCRIBE `ports` 0.0030229091644287
(203) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.0007178783416748
(204) DESCRIBE `ports` 0.0026998519897461
(205) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00065708160400391
(206) DESCRIBE `ports` 0.0027520656585693
(207) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00071191787719727
(208) DESCRIBE `ports` 0.0027577877044678
(209) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00058102607727051
(210) DESCRIBE `ports` 0.0027680397033691
(211) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1601))) 0.00067591667175293
(212) DESCRIBE `ports` 0.002842903137207
(213) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1601') 0.00060892105102539
(214) DESCRIBE `ports` 0.0030050277709961
(215) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1576))) 0.00087404251098633
(216) DESCRIBE `ports` 0.0030419826507568
(217) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1576') 0.00067496299743652
(218) DESCRIBE `ports` 0.0031280517578125
(219) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.0010290145874023
(220) DESCRIBE `ports` 0.0033500194549561
(221) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00066709518432617
(222) DESCRIBE `ports` 0.0031771659851074
(223) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2094))) 0.00078701972961426
(224) DESCRIBE `ports` 0.0026240348815918
(225) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2094') 0.00067496299743652
(226) DESCRIBE `ports` 0.0029330253601074
(227) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1574))) 0.0010631084442139
(228) DESCRIBE `ports` 0.0036461353302002
(229) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1574') 0.00071597099304199
(230) DESCRIBE `ports` 0.0031888484954834
(231) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00074887275695801
(232) DESCRIBE `ports` 0.0028870105743408
(233) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.00059008598327637
(234) DESCRIBE `ports` 0.0028159618377686
(235) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1570))) 0.00085997581481934
(236) DESCRIBE `ports` 0.0036981105804443
(237) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1570') 0.00073409080505371
(238) DESCRIBE `ports` 0.0027830600738525
(239) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1600))) 0.00075507164001465
(240) DESCRIBE `ports` 0.0023567676544189
(241) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1600') 0.00063300132751465
(242) DESCRIBE `ports` 0.0030050277709961
(243) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1600))) 0.00071406364440918
(244) DESCRIBE `ports` 0.0024099349975586
(245) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1600') 0.00067305564880371
(246) DESCRIBE `ports` 0.0023350715637207
(247) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1564))) 0.00048303604125977
(248) DESCRIBE `ports` 0.0022928714752197
(249) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1564') 0.00051307678222656
(250) DESCRIBE `ports` 0.0027909278869629
(251) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1592))) 0.0007779598236084
(252) DESCRIBE `ports` 0.0027110576629639
(253) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1592') 0.00048303604125977
(254) DESCRIBE `ports` 0.0023050308227539
(255) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00062084197998047
(256) DESCRIBE `ports` 0.0027849674224854
(257) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00060486793518066
(258) DESCRIBE `ports` 0.0027358531951904
(259) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00061798095703125
(260) DESCRIBE `ports` 0.0023810863494873
(261) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00053119659423828
(262) DESCRIBE `avid_specials` 0.0018429756164551
(263) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 78402 and class = 'Cruise') OR (item_id = 1155 AND class = 'Ship') OR (item_id = 156 AND class = 'CruiseLine') OR (item_id = 50 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.0013751983642578
(264) DESCRIBE `cruiselines` 0.0037131309509277
(265) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 156))) 0.00074887275695801
(266) DESCRIBE `orchid_image` 0.0030698776245117
(267) DESCRIBE `cruiselines` 0.0035810470581055
(268) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '156') 0.00069499015808105
(269) DESCRIBE `cruises` 0.0045211315155029
(270) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70017') 0.00052404403686523
(271) DESCRIBE `ships` 0.0039021968841553
(272) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1297))) 0.00079989433288574
(273) DESCRIBE `ships` 0.0039129257202148
(274) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1297') 0.00060200691223145
(275) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00050687789916992
(276) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00046205520629883
(277) DESCRIBE `itineraries` 0.0025761127471924
(278) DESCRIBE `ports` 0.0027220249176025
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00088977813720703
(280) DESCRIBE `ports` 0.0032081604003906
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00054597854614258
(282) DESCRIBE `ports` 0.0023369789123535
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00045895576477051
(284) DESCRIBE `sailingdates` 0.002108097076416
(285) DESCRIBE `ports` 0.002781867980957
(286) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00071287155151367
(287) DESCRIBE `ports` 0.0028588771820068
(288) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00062680244445801
(289) DESCRIBE `ports` 0.0029292106628418
(290) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00075197219848633
(291) DESCRIBE `ports` 0.0030121803283691
(292) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.0006718635559082
(293) DESCRIBE `ports` 0.0030128955841064
(294) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1592))) 0.00069403648376465
(295) DESCRIBE `ports` 0.0027041435241699
(296) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1592') 0.00055718421936035
(297) DESCRIBE `ports` 0.0025019645690918
(298) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1564))) 0.00049996376037598
(299) DESCRIBE `ports` 0.0024960041046143
(300) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1564') 0.000762939453125
(301) DESCRIBE `ports` 0.003154993057251
(302) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1600))) 0.00074195861816406
(303) DESCRIBE `ports` 0.0029120445251465
(304) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1600') 0.00065088272094727
(305) DESCRIBE `ports` 0.0027618408203125
(306) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1600))) 0.00069093704223633
(307) DESCRIBE `ports` 0.0028419494628906
(308) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1600') 0.00058507919311523
(309) DESCRIBE `ports` 0.0029339790344238
(310) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1570))) 0.00064587593078613
(311) DESCRIBE `ports` 0.0028319358825684
(312) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1570') 0.00066900253295898
(313) DESCRIBE `ports` 0.0028409957885742
(314) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00068283081054688
(315) DESCRIBE `ports` 0.0028231143951416
(316) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.00069499015808105
(317) DESCRIBE `ports` 0.0027620792388916
(318) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1574))) 0.00073814392089844
(319) DESCRIBE `ports` 0.0029969215393066
(320) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1574') 0.0006110668182373
(321) DESCRIBE `ports` 0.0028319358825684
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00057601928710938
(323) DESCRIBE `ports` 0.0036170482635498
(324) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00060701370239258
(325) DESCRIBE `ports` 0.0029909610748291
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2094))) 0.00072288513183594
(327) DESCRIBE `ports` 0.0031070709228516
(328) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2094') 0.00058412551879883
(329) DESCRIBE `ports` 0.0028088092803955
(330) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1576))) 0.00075697898864746
(331) DESCRIBE `ports` 0.0029659271240234
(332) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1576') 0.00083422660827637
(333) DESCRIBE `ports` 0.0029430389404297
(334) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1601))) 0.00069403648376465
(335) DESCRIBE `ports` 0.0029959678649902
(336) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1601') 0.00063204765319824
(337) DESCRIBE `ports` 0.0029280185699463
(338) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00077581405639648
(339) DESCRIBE `ports` 0.0029399394989014
(340) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00064492225646973
(341) DESCRIBE `ports` 0.0034089088439941
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.014256000518799
(343) DESCRIBE `ports` 0.0028018951416016
(344) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00051307678222656
(345) DESCRIBE `ports` 0.0025060176849365
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00048208236694336
(347) DESCRIBE `ports` 0.0026278495788574
(348) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.0070779323577881
(349) DESCRIBE `ports` 0.0026021003723145
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00054001808166504
(351) DESCRIBE `ports` 0.0021510124206543
(352) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.0070340633392334
(353) DESCRIBE `avid_specials` 0.0025429725646973
(354) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70017 and class = 'Cruise') OR (item_id = 1297 AND class = 'Ship') OR (item_id = 156 AND class = 'CruiseLine') OR (item_id = 50 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.0026378631591797
(355) DESCRIBE `cruiselines` 0.0070810317993164
(356) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 156))) 0.019275903701782
(357) DESCRIBE `orchid_image` 0.004086971282959
(358) DESCRIBE `cruiselines` 0.0066180229187012
(359) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '156') 0.00072598457336426
(360) DESCRIBE `cruises` 0.0054059028625488
(361) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70068') 0.00088691711425781
(362) DESCRIBE `ships` 0.0058379173278809
(363) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1445))) 0.00095701217651367
(364) DESCRIBE `ships` 0.0056819915771484
(365) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1445') 0.00083708763122559
(366) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00049400329589844
(367) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00049805641174316
(368) DESCRIBE `itineraries` 0.0028541088104248
(369) DESCRIBE `ports` 0.0028319358825684
(370) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00071978569030762
(371) DESCRIBE `ports` 0.0028970241546631
(372) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00071811676025391
(373) DESCRIBE `ports` 0.0029759407043457
(374) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.00068497657775879
(375) DESCRIBE `sailingdates` 0.0026140213012695
(376) DESCRIBE `ports` 0.0026819705963135
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.0006248950958252
(378) DESCRIBE `ports` 0.0020461082458496
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.00044107437133789
(380) DESCRIBE `ports` 0.0023431777954102
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00044488906860352
(382) DESCRIBE `ports` 0.0026791095733643
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.0005490779876709
(384) DESCRIBE `ports` 0.0019891262054443
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1574))) 0.00045895576477051
(386) DESCRIBE `ports` 0.0022108554840088
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1574') 0.00039887428283691
(388) DESCRIBE `ports` 0.0018429756164551
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00051498413085938
(390) DESCRIBE `ports` 0.0021460056304932
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00041103363037109
(392) DESCRIBE `ports` 0.0019500255584717
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1581))) 0.00050997734069824
(394) DESCRIBE `ports` 0.0018692016601562
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1581') 0.00068092346191406
(396) DESCRIBE `ports` 0.0025889873504639
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1576))) 0.00066518783569336
(398) DESCRIBE `ports` 0.0026810169219971
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1576') 0.00060296058654785
(400) DESCRIBE `ports` 0.0027470588684082
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1601))) 0.00069212913513184
(402) DESCRIBE `ports` 0.0028419494628906
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1601') 0.00069594383239746
(404) DESCRIBE `ports` 0.0025231838226318
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00069594383239746
(406) DESCRIBE `ports` 0.0028998851776123
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00063896179199219
(408) DESCRIBE `ports` 0.0030200481414795
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00071096420288086
(410) DESCRIBE `ports` 0.0030338764190674
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00046801567077637
(412) DESCRIBE `ports` 0.0024631023406982
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00063705444335938
(414) DESCRIBE `ports` 0.0023889541625977
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00061702728271484
(416) DESCRIBE `avid_specials` 0.0023679733276367
(417) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70068 and class = 'Cruise') OR (item_id = 1445 AND class = 'Ship') OR (item_id = 156 AND class = 'CruiseLine') OR (item_id = 50 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.0017850399017334
(418) DESCRIBE `cruiselines` 0.0040760040283203
(419) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 156))) 0.00080204010009766
(420) DESCRIBE `orchid_image` 0.0032320022583008
(421) DESCRIBE `cruiselines` 0.0031900405883789
(422) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '156') 0.00059795379638672
(423) DESCRIBE `cruises` 0.0057721138000488
(424) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '81916') 0.00081205368041992
(425) DESCRIBE `ships` 0.0061221122741699
(426) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1348))) 0.0010108947753906
(427) DESCRIBE `ships` 0.0058069229125977
(428) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1348') 0.00089001655578613
(429) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00054311752319336
(430) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00052309036254883
(431) DESCRIBE `itineraries` 0.0031630992889404
(432) DESCRIBE `ports` 0.0033209323883057
(433) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00087094306945801
(434) DESCRIBE `ports` 0.0027050971984863
(435) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00071191787719727
(436) DESCRIBE `ports` 0.0022599697113037
(437) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00060820579528809
(438) DESCRIBE `sailingdates` 0.0020930767059326
(439) DESCRIBE `ports` 0.0024011135101318
(440) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00063800811767578
(441) DESCRIBE `ports` 0.0026481151580811
(442) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00063109397888184
(443) DESCRIBE `ports` 0.0028860569000244
(444) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00073099136352539
(445) DESCRIBE `ports` 0.0027449131011963
(446) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00059390068054199
(447) DESCRIBE `ports` 0.0023250579833984
(448) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00063800811767578
(449) DESCRIBE `ports` 0.0028419494628906
(450) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00058817863464355
(451) DESCRIBE `ports` 0.0027530193328857
(452) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00085592269897461
(453) DESCRIBE `ports` 0.0028359889984131
(454) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00057601928710938
(455) DESCRIBE `ports` 0.0021088123321533
(456) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2775))) 0.00078105926513672
(457) DESCRIBE `ports` 0.0024330615997314
(458) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2775') 0.00067591667175293
(459) DESCRIBE `ports` 0.0020580291748047
(460) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3671))) 0.00061297416687012
(461) DESCRIBE `ports` 0.0020608901977539
(462) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3671') 0.00053286552429199
(463) DESCRIBE `ports` 0.0019810199737549
(464) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0.00055313110351562
(465) DESCRIBE `ports` 0.0027520656585693
(466) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 0.00049710273742676
(467) DESCRIBE `ports` 0.0022079944610596
(468) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00088691711425781
(469) DESCRIBE `ports` 0.0030839443206787
(470) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.0006721019744873
(471) DESCRIBE `ports` 0.0029308795928955
(472) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00067496299743652
(473) DESCRIBE `ports` 0.0029017925262451
(474) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00070285797119141
(475) DESCRIBE `ports` 0.0028879642486572
(476) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4095))) 0.00063991546630859
(477) DESCRIBE `ports` 0.0029399394989014
(478) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4095') 0.00068306922912598
(479) DESCRIBE `ports` 0.0026698112487793
(480) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3488))) 0.00067806243896484
(481) DESCRIBE `ports` 0.0027389526367188
(482) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3488') 0.00060296058654785
(483) DESCRIBE `ports` 0.0025198459625244
(484) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00066900253295898
(485) DESCRIBE `ports` 0.0030148029327393
(486) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2778') 0.0005490779876709
(487) DESCRIBE `ports` 0.0027759075164795
(488) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.0006260871887207
(489) DESCRIBE `ports` 0.002755880355835
(490) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2778') 0.00059008598327637
(491) DESCRIBE `ports` 0.0026981830596924
(492) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00062298774719238
(493) DESCRIBE `ports` 0.0027439594268799
(494) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00050902366638184
(495) DESCRIBE `ports` 0.0027480125427246
(496) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00057387351989746
(497) DESCRIBE `ports` 0.0027859210968018
(498) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00055789947509766
(499) DESCRIBE `ports` 0.002748966217041
(500) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00058102607727051
(501) DESCRIBE `ports` 0.0027430057525635
(502) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00055503845214844
(503) DESCRIBE `ports` 0.0024778842926025
(504) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00055408477783203
(505) DESCRIBE `ports` 0.0020279884338379
(506) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00040197372436523
(507) DESCRIBE `avid_specials` 0.0017268657684326
(508) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 81916 and class = 'Cruise') OR (item_id = 1348 AND class = 'Ship') OR (item_id = 156 AND class = 'CruiseLine') OR (item_id = 54 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.0022079944610596
(509) DESCRIBE `cruiselines` 0.003727912902832
(510) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 156))) 0.00070405006408691
(511) DESCRIBE `orchid_image` 0.0031850337982178
(512) DESCRIBE `cruiselines` 0.0035760402679443
(513) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '156') 0.0006260871887207
(514) DESCRIBE `cruises` 0.0074560642242432
(515) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69996') 0.00075101852416992
(516) DESCRIBE `ships` 0.0051829814910889
(517) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 767))) 0.0010781288146973
(518) DESCRIBE `ships` 0.0058388710021973
(519) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '767') 0.00074315071105957
(520) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00051307678222656
(521) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00060391426086426
(522) DESCRIBE `itineraries` 0.0024769306182861
(523) DESCRIBE `ports` 0.002377986907959
(524) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00060296058654785
(525) DESCRIBE `ports` 0.0023400783538818
(526) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00053191184997559
(527) DESCRIBE `ports` 0.0022149085998535
(528) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00069212913513184
(529) DESCRIBE `sailingdates` 0.0025389194488525
(530) DESCRIBE `ports` 0.0029761791229248
(531) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00071907043457031
(532) DESCRIBE `ports` 0.0029168128967285
(533) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00073409080505371
(534) DESCRIBE `ports` 0.0028560161590576
(535) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00083398818969727
(536) DESCRIBE `ports` 0.003046989440918
(537) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00069904327392578
(538) DESCRIBE `ports` 0.0030419826507568
(539) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00082206726074219
(540) DESCRIBE `ports` 0.0029950141906738
(541) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00075984001159668
(542) DESCRIBE `ports` 0.00295090675354
(543) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00077390670776367
(544) DESCRIBE `ports` 0.0028488636016846
(545) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00061202049255371
(546) DESCRIBE `ports` 0.0025060176849365
(547) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1601))) 0.00077486038208008
(548) DESCRIBE `ports` 0.0025889873504639
(549) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1601') 0.00058507919311523
(550) DESCRIBE `ports` 0.0023369789123535
(551) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1576))) 0.00072908401489258
(552) DESCRIBE `ports` 0.0028560161590576
(553) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1576') 0.00064921379089355
(554) DESCRIBE `ports` 0.0028820037841797
(555) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00066089630126953
(556) DESCRIBE `ports` 0.0030670166015625
(557) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00069093704223633
(558) DESCRIBE `ports` 0.0029900074005127
(559) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2094))) 0.00072288513183594
(560) DESCRIBE `ports` 0.0030901432037354
(561) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2094') 0.00067400932312012
(562) DESCRIBE `ports` 0.0029759407043457
(563) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1574))) 0.0006401538848877
(564) DESCRIBE `ports` 0.0029330253601074
(565) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1574') 0.00068807601928711
(566) DESCRIBE `ports` 0.0023899078369141
(567) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00050687789916992
(568) DESCRIBE `ports` 0.002302885055542
(569) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.0005490779876709
(570) DESCRIBE `ports` 0.0022780895233154
(571) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1570))) 0.00080084800720215
(572) DESCRIBE `ports` 0.0029518604278564
(573) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1570') 0.00066900253295898
(574) DESCRIBE `ports` 0.0031111240386963
(575) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1600))) 0.00080704689025879
(576) DESCRIBE `ports` 0.0026040077209473
(577) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1600') 0.00046801567077637
(578) DESCRIBE `ports` 0.0023400783538818
(579) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1600))) 0.00047397613525391
(580) DESCRIBE `ports` 0.0023560523986816
(581) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1600') 0.00050210952758789
(582) DESCRIBE `ports` 0.0023870468139648
(583) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1564))) 0.00053119659423828
(584) DESCRIBE `ports` 0.0024089813232422
(585) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1564') 0.00052285194396973
(586) DESCRIBE `ports` 0.0025510787963867
(587) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1592))) 0.0006260871887207
(588) DESCRIBE `ports` 0.0026991367340088
(589) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1592') 0.00058412551879883
(590) DESCRIBE `ports` 0.0021817684173584
(591) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00046610832214355
(592) DESCRIBE `ports` 0.0020558834075928
(593) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00052094459533691
(594) DESCRIBE `ports` 0.0026090145111084
(595) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00059390068054199
(596) DESCRIBE `ports` 0.0026469230651855
(597) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00052404403686523
(598) DESCRIBE `avid_specials` 0.0022130012512207
(599) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69996 and class = 'Cruise') OR (item_id = 767 AND class = 'Ship') OR (item_id = 156 AND class = 'CruiseLine') OR (item_id = 50 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.0020148754119873
(600) DESCRIBE `cruiselines` 0.0032651424407959
(601) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 156))) 0.00062203407287598
(602) DESCRIBE `orchid_image` 0.0026240348815918
(603) DESCRIBE `cruiselines` 0.0043501853942871
(604) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '156') 0.00072717666625977
(605) DESCRIBE `cruises` 0.0053951740264893
(606) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69999') 0.00064396858215332
(607) DESCRIBE `ships` 0.006166934967041
(608) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 979))) 0.0021839141845703
(609) DESCRIBE `ships` 0.0052609443664551
(610) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '979') 0.0010459423065186
(611) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00051689147949219
(612) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00047683715820312
(613) DESCRIBE `itineraries` 0.0026998519897461
(614) DESCRIBE `ports` 0.0030460357666016
(615) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00071310997009277
(616) DESCRIBE `ports` 0.0028078556060791
(617) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00066995620727539
(618) DESCRIBE `ports` 0.0026051998138428
(619) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00064611434936523
(620) DESCRIBE `sailingdates` 0.0022730827331543
(621) DESCRIBE `ports` 0.0027780532836914
(622) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00066399574279785
(623) DESCRIBE `ports` 0.0026431083679199
(624) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00060105323791504
(625) DESCRIBE `ports` 0.0026061534881592
(626) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00069403648376465
(627) DESCRIBE `ports` 0.0026938915252686
(628) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00060701370239258
(629) DESCRIBE `ports` 0.006040096282959
(630) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1592))) 0.00078201293945312
(631) DESCRIBE `ports` 0.0028421878814697
(632) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1592') 0.00044608116149902
(633) DESCRIBE `ports` 0.0021820068359375
(634) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1564))) 0.00050711631774902
(635) DESCRIBE `ports` 0.0027649402618408
(636) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1564') 0.00069904327392578
(637) DESCRIBE `ports` 0.0031208992004395
(638) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1600))) 0.00081706047058105
(639) DESCRIBE `ports` 0.0027809143066406
(640) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1600') 0.0006871223449707
(641) DESCRIBE `ports` 0.002112865447998
(642) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1600))) 0.00058913230895996
(643) DESCRIBE `ports` 0.0022830963134766
(644) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1600') 0.00057315826416016
(645) DESCRIBE `ports` 0.0032551288604736
(646) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1570))) 0.00072407722473145
(647) DESCRIBE `ports` 0.0029101371765137
(648) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1570') 0.00059890747070312
(649) DESCRIBE `ports` 0.0028181076049805
(650) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00069403648376465
(651) DESCRIBE `ports` 0.0027379989624023
(652) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.00064396858215332
(653) DESCRIBE `ports` 0.0027530193328857
(654) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1574))) 0.00068211555480957
(655) DESCRIBE `ports` 0.0028910636901855
(656) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1574') 0.00052690505981445
(657) DESCRIBE `ports` 0.0027549266815186
(658) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00072598457336426
(659) DESCRIBE `ports` 0.0026600360870361
(660) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00053000450134277
(661) DESCRIBE `ports` 0.0022921562194824
(662) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2094))) 0.00069212913513184
(663) DESCRIBE `ports` 0.0020129680633545
(664) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2094') 0.0005500316619873
(665) DESCRIBE `ports` 0.002223014831543
(666) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1576))) 0.00066184997558594
(667) DESCRIBE `ports` 0.002856969833374
(668) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1576') 0.00071001052856445
(669) DESCRIBE `ports` 0.0025022029876709
(670) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1601))) 0.00055599212646484
(671) DESCRIBE `ports` 0.002316951751709
(672) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1601') 0.00062417984008789
(673) DESCRIBE `ports` 0.0029289722442627
(674) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00081801414489746
(675) DESCRIBE `ports` 0.003046989440918
(676) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00068211555480957
(677) DESCRIBE `ports` 0.003432035446167
(678) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00067806243896484
(679) DESCRIBE `ports` 0.0021069049835205
(680) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00052809715270996
(681) DESCRIBE `ports` 0.0025019645690918
(682) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00053501129150391
(683) DESCRIBE `ports` 0.0020430088043213
(684) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00055885314941406
(685) DESCRIBE `ports` 0.0025620460510254
(686) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00062704086303711
(687) DESCRIBE `ports` 0.0026910305023193
(688) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00064611434936523
(689) DESCRIBE `avid_specials` 0.0021319389343262
(690) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69999 and class = 'Cruise') OR (item_id = 979 AND class = 'Ship') OR (item_id = 156 AND class = 'CruiseLine') OR (item_id = 50 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.0013279914855957
(691) DESCRIBE `cruiselines` 0.0034830570220947
(692) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 156))) 0.0008080005645752
(693) DESCRIBE `orchid_image` 0.0033490657806396
(694) DESCRIBE `cruiselines` 0.0036599636077881
(695) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '156') 0.00063300132751465
(696) DESCRIBE `cruises` 0.0046610832214355
(697) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '78508') 0.00060009956359863
(698) DESCRIBE `ships` 0.0056149959564209
(699) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 685))) 0.00092601776123047
(700) DESCRIBE `ships` 0.004601001739502
(701) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '685') 0.00065803527832031
(702) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00046205520629883
(703) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00056290626525879
(704) DESCRIBE `itineraries` 0.003122091293335
(705) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '78508') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0024158954620361
(706) DESCRIBE `ports` 0.0031139850616455
(707) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1547))) 0.0005958080291748
(708) DESCRIBE `ports` 0.002716064453125
(709) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1547))) 0.00073599815368652
(710) DESCRIBE `ports` 0.0029869079589844
(711) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1547') 0.00068807601928711
(712) DESCRIBE `sailingdates` 0.0028009414672852
(713) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '78508') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00211501121521
(714) DESCRIBE `ports` 0.0028970241546631
(715) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1547))) 0.000640869140625
(716) DESCRIBE `ports` 0.0024919509887695
(717) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1547') 0.00057411193847656
(718) DESCRIBE `ports` 0.0026659965515137
(719) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1548))) 0.00079202651977539
(720) DESCRIBE `ports` 0.0032730102539062
(721) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1548') 0.00068116188049316
(722) DESCRIBE `ports` 0.0029680728912354
(723) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00082206726074219
(724) DESCRIBE `ports` 0.0029752254486084
(725) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00065398216247559
(726) DESCRIBE `ports` 0.0027511119842529
(727) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00065493583679199
(728) DESCRIBE `ports` 0.0025968551635742
(729) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.0005650520324707
(730) DESCRIBE `ports` 0.002842903137207
(731) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1550))) 0.00087690353393555
(732) DESCRIBE `ports` 0.0026509761810303
(733) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1550') 0.00059604644775391
(734) DESCRIBE `ports` 0.0025391578674316
(735) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1551))) 0.00062680244445801
(736) DESCRIBE `ports` 0.002953052520752
(737) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1551') 0.00064992904663086
(738) DESCRIBE `ports` 0.002877950668335
(739) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1552))) 0.00070405006408691
(740) DESCRIBE `ports` 0.002316951751709
(741) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1552') 0.0004580020904541
(742) DESCRIBE `ports` 0.0021228790283203
(743) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1508))) 0.00053715705871582
(744) DESCRIBE `ports` 0.0019631385803223
(745) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1508') 0.00040483474731445
(746) DESCRIBE `ports` 0.0019009113311768
(747) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1508))) 0.00058603286743164
(748) DESCRIBE `ports` 0.0021569728851318
(749) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1508') 0.00042295455932617
(750) DESCRIBE `ports` 0.0021228790283203
(751) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4503))) 0.00061893463134766
(752) DESCRIBE `ports` 0.0021088123321533
(753) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4503') 0.00047683715820312
(754) DESCRIBE `ports` 0.0023720264434814
(755) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4503))) 0.0005338191986084
(756) DESCRIBE `ports` 0.0021018981933594
(757) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4503') 0.00040197372436523
(758) DESCRIBE `avid_specials` 0.0020489692687988
(759) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 78508 and class = 'Cruise') OR (item_id = 685 AND class = 'Ship') OR (item_id = 156 AND class = 'CruiseLine') OR (item_id = 50 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.0021281242370605
(760) DESCRIBE `cruiselines` 0.0037469863891602
(761) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 156))) 0.00074291229248047
(762) DESCRIBE `orchid_image` 0.0031900405883789
(763) DESCRIBE `cruiselines` 0.0043079853057861
(764) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '156') 0.00068211555480957
(765) DESCRIBE `cruises` 0.0054490566253662
(766) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '78560') 0.00068497657775879
(767) DESCRIBE `ships` 0.0057659149169922
(768) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1156))) 0.00091099739074707
(769) DESCRIBE `ships` 0.005605936050415
(770) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1156') 0.00078010559082031
(771) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00054812431335449
(772) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00052905082702637
(773) DESCRIBE `itineraries` 0.0023860931396484
(774) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '78560') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0013790130615234
(775) DESCRIBE `ports` 0.0023941993713379
(776) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00056004524230957
(777) DESCRIBE `ports` 0.0020790100097656
(778) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00060510635375977
(779) DESCRIBE `ports` 0.0028190612792969
(780) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00061702728271484
(781) DESCRIBE `sailingdates` 0.0019629001617432
(782) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '78560') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0010628700256348
(783) DESCRIBE `ports` 0.0025749206542969
(784) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00069689750671387
(785) DESCRIBE `ports` 0.0030069351196289
(786) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00063204765319824
(787) DESCRIBE `ports` 0.0028440952301025
(788) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2966))) 0.00068402290344238
(789) DESCRIBE `ports` 0.0026838779449463
(790) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2966') 0.00057411193847656
(791) DESCRIBE `ports` 0.0027561187744141
(792) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) 0.00060200691223145
(793) DESCRIBE `ports` 0.0028080940246582
(794) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') 0.00057721138000488
(795) DESCRIBE `ports` 0.0028090476989746
(796) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 714))) 0.0009000301361084
(797) DESCRIBE `ports` 0.0030710697174072
(798) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '714') 0.00060296058654785
(799) DESCRIBE `ports` 0.0028729438781738
(800) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 714))) 0.00069594383239746
(801) DESCRIBE `ports` 0.0028610229492188
(802) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '714') 0.00057196617126465
(803) DESCRIBE `ports` 0.0028131008148193
(804) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1558))) 0.00074410438537598
(805) DESCRIBE `ports` 0.0027179718017578
(806) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1558') 0.00058102607727051
(807) DESCRIBE `ports` 0.0027241706848145
(808) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1554))) 0.00066995620727539
(809) DESCRIBE `ports` 0.0020949840545654
(810) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1554') 0.00063204765319824
(811) DESCRIBE `ports` 0.0023820400238037
(812) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00053787231445312
(813) DESCRIBE `ports` 0.0019431114196777
(814) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00047993659973145
(815) DESCRIBE `ports` 0.002424955368042
(816) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00051593780517578
(817) DESCRIBE `ports` 0.0020139217376709
(818) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00041508674621582
(819) DESCRIBE `avid_specials` 0.0019049644470215
(820) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 78560 and class = 'Cruise') OR (item_id = 1156 AND class = 'Ship') OR (item_id = 156 AND class = 'CruiseLine') OR (item_id = 50 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.001230001449585
(821) DESCRIBE `cruiselines` 0.0035319328308105
(822) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 156))) 0.0018560886383057
(823) DESCRIBE `orchid_image` 0.0023219585418701
(824) DESCRIBE `cruiselines` 0.0028460025787354
(825) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '156') 0.00052595138549805
(826) DESCRIBE `ships` 0.0053770542144775
(827) SELECT `ships`.* FROM `ships` WHERE (id IN ('1348', '1445', '1350', '1444', '982', '1297', '687', '1156', '767', '1155', '1295', '979', '1296', '685', '983')) ORDER BY FIND_IN_SET(id, '1348,1445,1350,1444,982,1297,687,1156,767,1155,1295,979,1296,685,983') 0.0046110153198242
(828) DESCRIBE `cruisetypes` 0.0029349327087402
(829) DESCRIBE `destinations` 0.0038399696350098
(830) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '54')) ORDER BY FIND_IN_SET(id, '50,54') 0.0011250972747803
(831) DESCRIBE `cruiselines` 0.0038630962371826
(832) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 156))) 0.00072503089904785
(833) DESCRIBE `cruiselines` 0.0039641857147217
(834) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 156))) 0.00083589553833008