or, enquire about your chosen options

  1. Catch Up on Cruising: Latest News in bite size!
  2. Drinks Package Comparison
  3. Regal Princess heads down under!
  4. Catch Up on Cruising: Latest News in bite size!
  5. What happens when you cruise back to back?

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

Total elapsed time: 0.93739557266235

# Query Time
(1) connect 0.0014159679412842
(2) DESCRIBE `cruises` 0.0055351257324219
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (74697, 57672, 48300, 40591, 47190, 75369, 11517, 52584, 67266, 67915)) ORDER BY FIND_IN_SET(id, '74697,57672,48300,40591,47190,75369,11517,52584,67266,67915') 0.0033919811248779
(4) DESCRIBE `specials` 0.0069639682769775
(5) DESCRIBE `specials` 0.0056710243225098
(6) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1511652') 0.00045084953308105
(7) DESCRIBE `ships` 0.0048460960388184
(8) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1163))) 0.001291036605835
(9) DESCRIBE `ships` 0.0058128833770752
(10) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1163') 0.00040292739868164
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00027203559875488
(12) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00027894973754883
(13) DESCRIBE `itineraries` 0.0030951499938965
(14) DESCRIBE `ports` 0.0017328262329102
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.0011420249938965
(16) DESCRIBE `ports` 0.0016050338745117
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.0005791187286377
(18) DESCRIBE `ports` 0.0021798610687256
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4804') 0.00046110153198242
(20) DESCRIBE `specialsailingdates` 0.0025069713592529
(21) DESCRIBE `sailingdates` 0.0023119449615479
(22) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 471642))) 0.00066184997558594
(23) DESCRIBE `ports` 0.0016582012176514
(24) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.00041007995605469
(25) DESCRIBE `ports` 0.0031828880310059
(26) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4804') 0.00031900405883789
(27) DESCRIBE `ports` 0.0040738582611084
(28) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.00081586837768555
(29) DESCRIBE `ports` 0.0024590492248535
(30) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4804') 0.00050902366638184
(31) DESCRIBE `ports` 0.0025968551635742
(32) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1229))) 0.00047206878662109
(33) DESCRIBE `ports` 0.0048270225524902
(34) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1229') 0.0011799335479736
(35) DESCRIBE `ports` 0.0041179656982422
(36) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00036406517028809
(37) DESCRIBE `ports` 0.0041558742523193
(38) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00049400329589844
(39) DESCRIBE `ports` 0.0022380352020264
(40) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3828))) 0.00048208236694336
(41) DESCRIBE `ports` 0.0019280910491943
(42) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3828') 0.00042104721069336
(43) DESCRIBE `ports` 0.0021450519561768
(44) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3828))) 0.0012128353118896
(45) DESCRIBE `ports` 0.0026421546936035
(46) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3828') 0.00047111511230469
(47) DESCRIBE `ports` 0.0035469532012939
(48) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3829))) 0.00055789947509766
(49) DESCRIBE `ports` 0.0025382041931152
(50) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3829') 0.0004730224609375
(51) DESCRIBE `ports` 0.0054008960723877
(52) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 279))) 0.00079917907714844
(53) DESCRIBE `ports` 0.0023999214172363
(54) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '279') 0.00033998489379883
(55) DESCRIBE `ports` 0.0019080638885498
(56) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.0023789405822754
(57) DESCRIBE `ports` 0.0045750141143799
(58) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4804') 0.00046396255493164
(59) DESCRIBE `cruises` 0.0045120716094971
(60) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 74697))) 0.00098896026611328
(61) DESCRIBE `avid_specials` 0.0041937828063965
(62) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1511652 and class = 'Special') OR (item_id = 74697 and class = 'Cruise') OR (item_id = 1163 AND class = 'Ship') OR (item_id = 212 AND class = 'CruiseLine') OR (item_id = 39 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.0016448497772217
(63) DESCRIBE `cruiselines` 0.002979040145874
(64) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00019598007202148
(65) DESCRIBE `orchid_image` 0.0022139549255371
(66) DESCRIBE `cruiselines` 0.0050599575042725
(67) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00042295455932617
(68) DESCRIBE `specials` 0.006850004196167
(69) DESCRIBE `specials` 0.0069577693939209
(70) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1512776') 0.0010080337524414
(71) DESCRIBE `ships` 0.0038509368896484
(72) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1205))) 0
(73) DESCRIBE `ships` 0.0049281120300293
(74) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1205') 0.00053787231445312
(75) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00040006637573242
(76) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00033712387084961
(77) DESCRIBE `itineraries` 0.002795934677124
(78) DESCRIBE `ports` 0.0023529529571533
(79) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00059986114501953
(80) DESCRIBE `ports` 0.002331018447876
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00060009956359863
(82) DESCRIBE `ports` 0.0019640922546387
(83) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00030303001403809
(84) DESCRIBE `specialsailingdates` 0.0025100708007812
(85) DESCRIBE `sailingdates` 0.0019409656524658
(86) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 485016))) 7.8678131103516E-6
(87) DESCRIBE `ports` 0.0021719932556152
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00046801567077637
(89) DESCRIBE `ports` 0.0021259784698486
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.0003809928894043
(91) DESCRIBE `ports` 0.0021629333496094
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.0011451244354248
(93) DESCRIBE `ports` 0.0022180080413818
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00043988227844238
(95) DESCRIBE `ports` 0.0016191005706787
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3671))) 0.00056004524230957
(97) DESCRIBE `ports` 0.0019009113311768
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3671') 0.0005180835723877
(99) DESCRIBE `ports` 0.0032839775085449
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2776))) 0.0012669563293457
(101) DESCRIBE `ports` 0.0024268627166748
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2776') 0.00051188468933105
(103) DESCRIBE `ports` 0.002514123916626
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0.00077009201049805
(105) DESCRIBE `ports` 0.0035550594329834
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 0.00064301490783691
(107) DESCRIBE `ports` 0.0021870136260986
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.0004730224609375
(109) DESCRIBE `ports` 0.0024611949920654
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00034594535827637
(111) DESCRIBE `ports` 0.0018961429595947
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00043892860412598
(113) DESCRIBE `ports` 0.0018818378448486
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00040698051452637
(115) DESCRIBE `ports` 0.0018250942230225
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5068))) 0.00041794776916504
(117) DESCRIBE `ports` 0.0022168159484863
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5068') 0.00041890144348145
(119) DESCRIBE `ports` 0.0023510456085205
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5645))) 0.00056695938110352
(121) DESCRIBE `ports` 0.0024540424346924
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5645') 0.0004279613494873
(123) DESCRIBE `ports` 0.0026140213012695
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2779))) 0.00041604042053223
(125) DESCRIBE `ports` 0.002223014831543
(126) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2779') 0.00037598609924316
(127) DESCRIBE `ports` 0.0026340484619141
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00043821334838867
(129) DESCRIBE `ports` 0.0019021034240723
(130) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00038790702819824
(131) DESCRIBE `cruises` 0.0033888816833496
(132) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 57672))) 0.00043702125549316
(133) DESCRIBE `avid_specials` 0.001352071762085
(134) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1512776 and class = 'Special') OR (item_id = 57672 and class = 'Cruise') OR (item_id = 1205 AND class = 'Ship') OR (item_id = 191 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.0011129379272461
(135) DESCRIBE `cruiselines` 0.0026769638061523
(136) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 191))) 0.00047016143798828
(137) DESCRIBE `orchid_image` 0.0026459693908691
(138) DESCRIBE `cruiselines` 0.0032680034637451
(139) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '191') 0.00079798698425293
(140) DESCRIBE `specials` 0.0053949356079102
(141) DESCRIBE `specials` 0.0049760341644287
(142) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1512771') 0.0011129379272461
(143) DESCRIBE `ships` 0.0042169094085693
(144) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1205))) 0.00026798248291016
(145) DESCRIBE `ships` 0.0035650730133057
(146) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1205') 8.7976455688477E-5
(147) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0
(148) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00092291831970215
(149) DESCRIBE `itineraries` 0.0017979145050049
(150) DESCRIBE `ports` 0.003046989440918
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00047111511230469
(152) DESCRIBE `ports` 0.0017509460449219
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.0013320446014404
(154) DESCRIBE `ports` 0.0019059181213379
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00061798095703125
(156) DESCRIBE `specialsailingdates` 0.001446008682251
(157) DESCRIBE `sailingdates` 0.0016610622406006
(158) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 485043))) 0.00045394897460938
(159) DESCRIBE `ports` 0.0015900135040283
(160) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00034284591674805
(161) DESCRIBE `ports` 0.0015950202941895
(162) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00032711029052734
(163) DESCRIBE `ports` 0.0015690326690674
(164) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00037002563476562
(165) DESCRIBE `ports` 0.0018301010131836
(166) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00038290023803711
(167) DESCRIBE `ports` 0.0015511512756348
(168) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3671))) 0.00037884712219238
(169) DESCRIBE `ports` 0.0014529228210449
(170) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3671') 0.00029993057250977
(171) DESCRIBE `ports` 0.001446008682251
(172) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2776))) 0.00033092498779297
(173) DESCRIBE `ports` 0.0017669200897217
(174) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2776') 0.0003809928894043
(175) DESCRIBE `ports` 0.0015518665313721
(176) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0.00039911270141602
(177) DESCRIBE `ports` 0.0018408298492432
(178) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 0.00043416023254395
(179) DESCRIBE `ports` 0.0019259452819824
(180) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00071287155151367
(181) DESCRIBE `ports` 0.0021770000457764
(182) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.0012028217315674
(183) DESCRIBE `ports` 0.0016059875488281
(184) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00045680999755859
(185) DESCRIBE `ports` 0.0022590160369873
(186) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00043797492980957
(187) DESCRIBE `cruises` 0.0038430690765381
(188) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 48300))) 0.00056099891662598
(189) DESCRIBE `avid_specials` 0.0018210411071777
(190) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1512771 and class = 'Special') OR (item_id = 48300 and class = 'Cruise') OR (item_id = 1205 AND class = 'Ship') OR (item_id = 191 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.0014770030975342
(191) DESCRIBE `cruiselines` 0.0025010108947754
(192) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 191))) 0.0004429817199707
(193) DESCRIBE `orchid_image` 0.0020678043365479
(194) DESCRIBE `cruiselines` 0.0040500164031982
(195) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '191') 0.0004730224609375
(196) DESCRIBE `specials` 0.005342960357666
(197) DESCRIBE `specials` 0.005361795425415
(198) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1512766') 0.00050711631774902
(199) DESCRIBE `ships` 0.0037949085235596
(200) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1032))) 0.00052285194396973
(201) DESCRIBE `ships` 0.0044939517974854
(202) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1032') 0
(203) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0003819465637207
(204) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0
(205) DESCRIBE `itineraries` 0.0021660327911377
(206) DESCRIBE `ports` 0.0026040077209473
(207) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.0003972053527832
(208) DESCRIBE `ports` 0.0023260116577148
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0
(210) DESCRIBE `ports` 0.0018219947814941
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') 8.702278137207E-5
(212) DESCRIBE `specialsailingdates` 0.0014858245849609
(213) DESCRIBE `sailingdates` 0.0015640258789062
(214) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 485428))) 0.00076103210449219
(215) DESCRIBE `ports` 0.0020430088043213
(216) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00048995018005371
(217) DESCRIBE `ports` 0.0017669200897217
(218) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') 0.0003509521484375
(219) DESCRIBE `ports` 0.0023550987243652
(220) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00061511993408203
(221) DESCRIBE `ports` 0.0016789436340332
(222) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00044608116149902
(223) DESCRIBE `ports` 0.0024940967559814
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00045299530029297
(225) DESCRIBE `ports` 0.0019130706787109
(226) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00042104721069336
(227) DESCRIBE `ports` 0.0019760131835938
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00053882598876953
(229) DESCRIBE `ports` 0.0021049976348877
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') 0.00043392181396484
(231) DESCRIBE `cruises` 0.0035209655761719
(232) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 40591))) 0.00050997734069824
(233) DESCRIBE `avid_specials` 0.0018069744110107
(234) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1512766 and class = 'Special') OR (item_id = 40591 and class = 'Cruise') OR (item_id = 1032 AND class = 'Ship') OR (item_id = 191 AND class = 'CruiseLine') OR (item_id = 55 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.0014629364013672
(235) DESCRIBE `cruiselines` 0.0042951107025146
(236) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 191))) 0.00062203407287598
(237) DESCRIBE `orchid_image` 0.0033140182495117
(238) DESCRIBE `cruiselines` 0.0027329921722412
(239) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '191') 0.00046181678771973
(240) DESCRIBE `specials` 0.0066900253295898
(241) DESCRIBE `specials` 0.0051980018615723
(242) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1511987') 0.00059700012207031
(243) DESCRIBE `ships` 0.0040171146392822
(244) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 333))) 0.00079488754272461
(245) DESCRIBE `ships` 0.0044560432434082
(246) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '333') 0.00057506561279297
(247) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034594535827637
(248) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003359317779541
(249) DESCRIBE `itineraries` 0.0040700435638428
(250) DESCRIBE `ports` 0.0021469593048096
(251) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00049018859863281
(252) DESCRIBE `ports` 0.0018970966339111
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00054001808166504
(254) DESCRIBE `ports` 0.0020010471343994
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00045013427734375
(256) DESCRIBE `specialsailingdates` 0.0019059181213379
(257) DESCRIBE `sailingdates` 0.0019888877868652
(258) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423912))) 0.00063586235046387
(259) DESCRIBE `ports` 0.0021510124206543
(260) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00049495697021484
(261) DESCRIBE `ports` 0.0020501613616943
(262) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00045299530029297
(263) DESCRIBE `ports` 0.0020182132720947
(264) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 296))) 0.00039887428283691
(265) DESCRIBE `ports` 0.0019690990447998
(266) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '296') 0.00034904479980469
(267) DESCRIBE `ports` 0.0019948482513428
(268) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 412))) 0.00036311149597168
(269) DESCRIBE `ports` 0.0017518997192383
(270) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '412') 0.00032401084899902
(271) DESCRIBE `ports` 0.0025949478149414
(272) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00041913986206055
(273) DESCRIBE `ports` 0.0019450187683105
(274) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00049781799316406
(275) DESCRIBE `ports` 0.0014569759368896
(276) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1727))) 0.00023889541625977
(277) DESCRIBE `ports` 0.0019149780273438
(278) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1727') 0.00060486793518066
(279) DESCRIBE `ports` 0.0025839805603027
(280) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00047183036804199
(281) DESCRIBE `ports` 0.002863883972168
(282) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00038409233093262
(283) DESCRIBE `cruises` 0.0045249462127686
(284) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 47190))) 0.00083112716674805
(285) DESCRIBE `avid_specials` 0.017944812774658
(286) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1511987 and class = 'Special') OR (item_id = 47190 and class = 'Cruise') OR (item_id = 333 AND class = 'Ship') OR (item_id = 218 AND class = 'CruiseLine') OR (item_id = 12 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.0018980503082275
(287) DESCRIBE `cruiselines` 0.0023829936981201
(288) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00047111511230469
(289) DESCRIBE `orchid_image` 0.0023279190063477
(290) DESCRIBE `cruiselines` 0.0027790069580078
(291) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00044894218444824
(292) DESCRIBE `specials` 0.0050818920135498
(293) DESCRIBE `specials` 0.0050160884857178
(294) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1512244') 0.00042605400085449
(295) DESCRIBE `ships` 0.0031349658966064
(296) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1320))) 0.00054693222045898
(297) DESCRIBE `ships` 0.0035879611968994
(298) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1320') 0.00040507316589355
(299) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027084350585938
(300) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031113624572754
(301) DESCRIBE `itineraries` 0.0015320777893066
(302) DESCRIBE `ports` 0.0016658306121826
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.0003819465637207
(304) DESCRIBE `ports` 0.0019397735595703
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00040602684020996
(306) DESCRIBE `ports` 0.0023000240325928
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.00039386749267578
(308) DESCRIBE `specialsailingdates` 0.0014588832855225
(309) DESCRIBE `sailingdates` 0.0014879703521729
(310) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 475646))) 0.00094103813171387
(311) DESCRIBE `ports` 0.0018479824066162
(312) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00043392181396484
(313) DESCRIBE `ports` 0.0018041133880615
(314) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.0003819465637207
(315) DESCRIBE `ports` 0.0014328956604004
(316) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 0.00039410591125488
(317) DESCRIBE `ports` 0.0018231868743896
(318) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.00036501884460449
(319) DESCRIBE `ports` 0.0018570423126221
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2283))) 0.00040602684020996
(321) DESCRIBE `ports` 0.0017750263214111
(322) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2283') 0.00037002563476562
(323) DESCRIBE `ports` 0.0017950534820557
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.00041294097900391
(325) DESCRIBE `ports` 0.0017099380493164
(326) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.00029683113098145
(327) DESCRIBE `ports` 0.0014979839324951
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00033688545227051
(329) DESCRIBE `ports` 0.0016930103302002
(330) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00030088424682617
(331) DESCRIBE `ports` 0.002094030380249
(332) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00040602684020996
(333) DESCRIBE `ports` 0.001539945602417
(334) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.00051784515380859
(335) DESCRIBE `cruises` 0.0036461353302002
(336) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 75369))) 0.00068807601928711
(337) DESCRIBE `avid_specials` 0.0017199516296387
(338) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1512244 and class = 'Special') OR (item_id = 75369 and class = 'Cruise') OR (item_id = 1320 AND class = 'Ship') OR (item_id = 218 AND class = 'CruiseLine') OR (item_id = 12 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.0016970634460449
(339) DESCRIBE `cruiselines` 0.0030679702758789
(340) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00050616264343262
(341) DESCRIBE `orchid_image` 0.002155065536499
(342) DESCRIBE `cruiselines` 0.0033421516418457
(343) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00078988075256348
(344) DESCRIBE `specials` 0.0091331005096436
(345) DESCRIBE `specials` 0.0050020217895508
(346) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1512752') 0.001079797744751
(347) DESCRIBE `ships` 0.0059499740600586
(348) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 521))) 0.00070595741271973
(349) DESCRIBE `ships` 0.003911018371582
(350) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '521') 0.0004420280456543
(351) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035309791564941
(352) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034904479980469
(353) DESCRIBE `itineraries` 0.0025579929351807
(354) DESCRIBE `ports` 0.0020229816436768
(355) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00062394142150879
(356) DESCRIBE `ports` 0.0019412040710449
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 7.7009201049805E-5
(358) DESCRIBE `ports` 0.0017328262329102
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2778') 0.00019288063049316
(360) DESCRIBE `specialsailingdates` 0.0016670227050781
(361) DESCRIBE `sailingdates` 0.0015549659729004
(362) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423040))) 0.00059795379638672
(363) DESCRIBE `ports` 0.002532958984375
(364) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0
(365) DESCRIBE `ports` 0.0032308101654053
(366) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2778') 0.0004119873046875
(367) DESCRIBE `ports` 0.0021779537200928
(368) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3490))) 0.0011239051818848
(369) DESCRIBE `ports` 0.0021600723266602
(370) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3490') 0.00041985511779785
(371) DESCRIBE `ports` 0.015257120132446
(372) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5160))) 0.00057792663574219
(373) DESCRIBE `ports` 0.0034699440002441
(374) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5160') 0.00049495697021484
(375) DESCRIBE `ports` 0.0021200180053711
(376) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.0005180835723877
(377) DESCRIBE `ports` 0.0016269683837891
(378) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 7.2002410888672E-5
(379) DESCRIBE `ports` 0.0031440258026123
(380) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4095))) 0.0010099411010742
(381) DESCRIBE `ports` 0.001943826675415
(382) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4095') 0.00045108795166016
(383) DESCRIBE `ports` 0.0018100738525391
(384) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0.0004429817199707
(385) DESCRIBE `ports` 0.0019919872283936
(386) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 0.00043010711669922
(387) DESCRIBE `ports` 0.0019381046295166
(388) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2776))) 0.00040411949157715
(389) DESCRIBE `ports` 0.0016541481018066
(390) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2776') 0.00029492378234863
(391) DESCRIBE `ports` 0.001823902130127
(392) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3671))) 0.00050806999206543
(393) DESCRIBE `ports` 0.0018999576568604
(394) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3671') 0.00040483474731445
(395) DESCRIBE `ports` 0.0020358562469482
(396) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2775))) 0.00046586990356445
(397) DESCRIBE `ports` 0.0019018650054932
(398) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2775') 0.00040006637573242
(399) DESCRIBE `ports` 0.0016219615936279
(400) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00042104721069336
(401) DESCRIBE `ports` 0.0018999576568604
(402) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.0003211498260498
(403) DESCRIBE `cruises` 0.0033190250396729
(404) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 11517))) 0.00062108039855957
(405) DESCRIBE `avid_specials` 0.001802921295166
(406) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1512752 and class = 'Special') OR (item_id = 11517 and class = 'Cruise') OR (item_id = 521 AND class = 'Ship') OR (item_id = 120 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.0016689300537109
(407) DESCRIBE `cruiselines` 0.0026450157165527
(408) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.0004889965057373
(409) DESCRIBE `orchid_image` 0.0021109580993652
(410) DESCRIBE `cruiselines` 0.003093957901001
(411) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00057697296142578
(412) DESCRIBE `specials` 0.0056929588317871
(413) DESCRIBE `specials` 0.005396842956543
(414) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1512003') 0.00052499771118164
(415) DESCRIBE `ships` 0.0039598941802979
(416) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 582))) 0.0006110668182373
(417) DESCRIBE `ships` 0.003911018371582
(418) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '582') 0.00062203407287598
(419) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00061488151550293
(420) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00042986869812012
(421) DESCRIBE `itineraries` 0.0020081996917725
(422) DESCRIBE `ports` 0.0020968914031982
(423) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00044488906860352
(424) DESCRIBE `ports` 0.0018289089202881
(425) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00043487548828125
(426) DESCRIBE `ports` 0.0018680095672607
(427) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0
(428) DESCRIBE `specialsailingdates` 0.0015120506286621
(429) DESCRIBE `sailingdates` 0.0013349056243896
(430) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 424907))) 0.00032520294189453
(431) DESCRIBE `ports` 0.0015799999237061
(432) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.0003509521484375
(433) DESCRIBE `ports` 0.0022652149200439
(434) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.00020098686218262
(435) DESCRIBE `ports` 0.0019547939300537
(436) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0
(437) DESCRIBE `ports` 0.001384973526001
(438) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.00033783912658691
(439) DESCRIBE `ports` 0.0019419193267822
(440) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 327))) 0.00043201446533203
(441) DESCRIBE `ports` 0.0026729106903076
(442) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '327') 0.00055193901062012
(443) DESCRIBE `ports` 0.0012011528015137
(444) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00063204765319824
(445) DESCRIBE `ports` 0.0017249584197998
(446) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00085282325744629
(447) DESCRIBE `ports` 0.0016269683837891
(448) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00033402442932129
(449) DESCRIBE `ports` 0.0014379024505615
(450) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.00030779838562012
(451) DESCRIBE `cruises` 0.0029659271240234
(452) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 52584))) 0.00049304962158203
(453) DESCRIBE `avid_specials` 0.0014140605926514
(454) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1512003 and class = 'Special') OR (item_id = 52584 and class = 'Cruise') OR (item_id = 582 AND class = 'Ship') OR (item_id = 218 AND class = 'CruiseLine') OR (item_id = 12 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.0015718936920166
(455) DESCRIBE `cruiselines` 0.0027689933776855
(456) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.0010719299316406
(457) DESCRIBE `orchid_image` 0.0012669563293457
(458) DESCRIBE `cruiselines` 0.0028829574584961
(459) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 2.1934509277344E-5
(460) DESCRIBE `specials` 0.0039849281311035
(461) DESCRIBE `specials` 0.0041108131408691
(462) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1512019') 0.00048398971557617
(463) DESCRIBE `ships` 0.0032641887664795
(464) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 970))) 0.00094008445739746
(465) DESCRIBE `ships` 0.0049018859863281
(466) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '970') 0.00050115585327148
(467) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0004429817199707
(468) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00038695335388184
(469) DESCRIBE `itineraries` 0.0017640590667725
(470) DESCRIBE `ports` 0.0017521381378174
(471) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.0004270076751709
(472) DESCRIBE `ports` 0.0015439987182617
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00044393539428711
(474) DESCRIBE `ports` 0.0015549659729004
(475) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00030398368835449
(476) DESCRIBE `specialsailingdates` 0.0013689994812012
(477) DESCRIBE `sailingdates` 0.0015699863433838
(478) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423693))) 0
(479) DESCRIBE `sailingdates` 0.0014059543609619
(480) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423694))) 0.00031280517578125
(481) DESCRIBE `ports` 0.0017240047454834
(482) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0
(483) DESCRIBE `ports` 0.0014858245849609
(484) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00040698051452637
(485) DESCRIBE `ports` 0.0019030570983887
(486) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4894))) 0.00054097175598145
(487) DESCRIBE `ports` 0.0012199878692627
(488) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4894') 0.00045013427734375
(489) DESCRIBE `ports` 0.0015649795532227
(490) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.00035810470581055
(491) DESCRIBE `ports` 0.0015871524810791
(492) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0
(493) DESCRIBE `ports` 0.00098896026611328
(494) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.0004279613494873
(495) DESCRIBE `ports` 0.00084185600280762
(496) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00032687187194824
(497) DESCRIBE `ports` 0.0019569396972656
(498) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1727))) 0.00043296813964844
(499) DESCRIBE `ports` 0.0015130043029785
(500) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1727') 0
(501) DESCRIBE `ports` 0.0020649433135986
(502) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00079202651977539
(503) DESCRIBE `ports` 0.002140998840332
(504) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0
(505) DESCRIBE `cruises` 0.0038838386535645
(506) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 67266))) 0.00066208839416504
(507) DESCRIBE `avid_specials` 0.0017921924591064
(508) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1512019 and class = 'Special') OR (item_id = 67266 and class = 'Cruise') OR (item_id = 970 AND class = 'Ship') OR (item_id = 218 AND class = 'CruiseLine') OR (item_id = 12 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.0023190975189209
(509) DESCRIBE `cruiselines` 0.0025229454040527
(510) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00043296813964844
(511) DESCRIBE `orchid_image` 0.0015740394592285
(512) DESCRIBE `cruiselines` 0.0022139549255371
(513) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00049614906311035
(514) DESCRIBE `specials` 0.0041718482971191
(515) DESCRIBE `specials` 0.005277156829834
(516) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1511854') 0.0006110668182373
(517) DESCRIBE `ships` 0.0040509700775146
(518) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 669))) 0.00062394142150879
(519) DESCRIBE `ships` 0.0037331581115723
(520) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '669') 0.0003819465637207
(521) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027298927307129
(522) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030612945556641
(523) DESCRIBE `itineraries` 0.0015749931335449
(524) DESCRIBE `ports` 0.0013980865478516
(525) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00034594535827637
(526) DESCRIBE `ports` 0.0013778209686279
(527) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00030207633972168
(528) DESCRIBE `ports` 0.001309871673584
(529) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00029110908508301
(530) DESCRIBE `specialsailingdates` 0.0012211799621582
(531) DESCRIBE `sailingdates` 0.0012009143829346
(532) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 428520))) 0.00037693977355957
(533) DESCRIBE `sailingdates` 0.0012998580932617
(534) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 428521))) 0.00028896331787109
(535) DESCRIBE `ports` 0.0014438629150391
(536) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00031805038452148
(537) DESCRIBE `ports` 0.0014309883117676
(538) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00028896331787109
(539) DESCRIBE `ports` 0.0018970966339111
(540) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.00038814544677734
(541) DESCRIBE `ports` 0.0015881061553955
(542) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.00029683113098145
(543) DESCRIBE `ports` 0.0015819072723389
(544) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2148))) 0.00036096572875977
(545) DESCRIBE `ports` 0.0014269351959229
(546) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2148') 0.0003509521484375
(547) DESCRIBE `ports` 0.0018100738525391
(548) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 166))) 0.00038695335388184
(549) DESCRIBE `ports` 0.0015599727630615
(550) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '166') 0.00036883354187012
(551) DESCRIBE `ports` 0.0014419555664062
(552) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00033688545227051
(553) DESCRIBE `ports` 0.001500129699707
(554) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.0003209114074707
(555) DESCRIBE `cruises` 0.0028140544891357
(556) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 67915))) 0.00052595138549805
(557) DESCRIBE `avid_specials` 0.0015690326690674
(558) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1511854 and class = 'Special') OR (item_id = 67915 and class = 'Cruise') OR (item_id = 669 AND class = 'Ship') OR (item_id = 218 AND class = 'CruiseLine') OR (item_id = 53 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.0017569065093994
(559) DESCRIBE `cruiselines` 0.0027880668640137
(560) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00049996376037598
(561) DESCRIBE `orchid_image` 0.0025060176849365
(562) DESCRIBE `cruiselines` 0.0026748180389404
(563) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.0003969669342041
(564) DESCRIBE `cruiselines` 0.0030767917633057
(565) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '191', '23', '101', '120', '4', '212')) ORDER BY FIND_IN_SET(id, '218,191,23,101,120,4,212') 0.00081205368041992
(566) DESCRIBE `ships` 0.0031969547271729
(567) SELECT `ships`.* FROM `ships` WHERE (id IN ('1205', '441', '390', '1032', '1303', '10', '451', '582', '669', '1237', '3', '9', '11', '21', '27', '333', '439', '521', '854', '970', '1320', '1579', '4', '22', '24', '25', '28', '105', '327', '461', '739', '1163', '1224', '1773')) ORDER BY FIND_IN_SET(id, '1205,441,390,1032,1303,10,451,582,669,1237,3,9,11,21,27,333,439,521,854,970,1320,1579,4,22,24,25,28,105,327,461,739,1163,1224,1773') 0.0041489601135254
(568) DESCRIBE `cruisetypes` 0.0019280910491943
(569) DESCRIBE `destinations` 0.0012800693511963
(570) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('12', '54', '48', '29', '9', '53', '40', '55', '8', '39', '50')) ORDER BY FIND_IN_SET(id, '12,54,48,29,9,53,40,55,8,39,50') 0.0013189315795898