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.70132780075073

# Query Time
(1) connect 0.0016539096832275
(2) DESCRIBE `cruises` 0.0034120082855225
(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.0020558834075928
(4) DESCRIBE `specials` 0.004741907119751
(5) DESCRIBE `specials` 0.0055198669433594
(6) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1511652') 6.6041946411133E-5
(7) DESCRIBE `ships` 0.0029160976409912
(8) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1163))) 0.00039482116699219
(9) DESCRIBE `ships` 0.0027351379394531
(10) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1163') 0.00030803680419922
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026512145996094
(12) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00032281875610352
(13) DESCRIBE `itineraries` 0.00049614906311035
(14) DESCRIBE `ports` 0.0014970302581787
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.00033783912658691
(16) DESCRIBE `ports` 0.0014238357543945
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.0011429786682129
(18) DESCRIBE `ports` 0.00087213516235352
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4804') 0.00032496452331543
(20) DESCRIBE `specialsailingdates` 0.0018811225891113
(21) DESCRIBE `sailingdates` 0.0011460781097412
(22) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 471642))) 0.00063014030456543
(23) DESCRIBE `ports` 0.00088810920715332
(24) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.00036501884460449
(25) DESCRIBE `ports` 0.0018529891967773
(26) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4804') 0.00020098686218262
(27) DESCRIBE `ports` 0.001248836517334
(28) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.00032305717468262
(29) DESCRIBE `ports` 0.001378059387207
(30) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4804') 0.00031805038452148
(31) DESCRIBE `ports` 0.0014140605926514
(32) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1229))) 0.00040793418884277
(33) DESCRIBE `ports` 0.0009770393371582
(34) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1229') 0.00035786628723145
(35) DESCRIBE `ports` 0.0017788410186768
(36) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00039291381835938
(37) DESCRIBE `ports` 0.0026049613952637
(38) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00024700164794922
(39) DESCRIBE `ports` 0.0018351078033447
(40) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3828))) 0.0011980533599854
(41) DESCRIBE `ports` 0.0018229484558105
(42) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3828') 0.00038003921508789
(43) DESCRIBE `ports` 0.0017650127410889
(44) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3828))) 0.00039505958557129
(45) DESCRIBE `ports` 0.0017979145050049
(46) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3828') 0.00037693977355957
(47) DESCRIBE `ports` 0.0017549991607666
(48) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3829))) 0.00038790702819824
(49) DESCRIBE `ports` 0.0017540454864502
(50) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3829') 4.7922134399414E-5
(51) DESCRIBE `ports` 0.0017728805541992
(52) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 279))) 0.00041413307189941
(53) DESCRIBE `ports` 0.0018148422241211
(54) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '279') 0.00039982795715332
(55) DESCRIBE `ports` 0.0018620491027832
(56) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.00043296813964844
(57) DESCRIBE `ports` 0.0018880367279053
(58) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4804') 0.00040721893310547
(59) DESCRIBE `cruises` 0.0026590824127197
(60) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 74697))) 0.00063610076904297
(61) DESCRIBE `avid_specials` 0.0012471675872803
(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.0014140605926514
(63) DESCRIBE `cruiselines` 0.0019299983978271
(64) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00034499168395996
(65) DESCRIBE `orchid_image` 0.0018398761749268
(66) DESCRIBE `cruiselines` 0.0018811225891113
(67) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00041508674621582
(68) DESCRIBE `specials` 0.0049231052398682
(69) DESCRIBE `specials` 0.0054748058319092
(70) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1512776') 0.00073099136352539
(71) DESCRIBE `ships` 0.0038158893585205
(72) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1205))) 0.00070619583129883
(73) DESCRIBE `ships` 0.0034198760986328
(74) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1205') 0.00043296813964844
(75) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00028300285339355
(76) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0
(77) DESCRIBE `itineraries` 0.00093793869018555
(78) DESCRIBE `ports` 0.0016510486602783
(79) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00038719177246094
(80) DESCRIBE `ports` 0.0012850761413574
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00049591064453125
(82) DESCRIBE `ports` 0.0013399124145508
(83) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00031805038452148
(84) DESCRIBE `specialsailingdates` 0.0010781288146973
(85) DESCRIBE `sailingdates` 0.0012199878692627
(86) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 485016))) 0.0011270046234131
(87) DESCRIBE `ports` 0.0013759136199951
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00033187866210938
(89) DESCRIBE `ports` 0.0015780925750732
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.0003199577331543
(91) DESCRIBE `ports` 0.0012788772583008
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00030803680419922
(93) DESCRIBE `ports` 0.0014309883117676
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00027990341186523
(95) DESCRIBE `ports` 0.0012850761413574
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3671))) 0.00033783912658691
(97) DESCRIBE `ports` 0.0013139247894287
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3671') 0.00032496452331543
(99) DESCRIBE `ports` 0.001295804977417
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2776))) 0.0003209114074707
(101) DESCRIBE `ports` 0.0012469291687012
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2776') 0.00027203559875488
(103) DESCRIBE `ports` 0.0013089179992676
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0.00030303001403809
(105) DESCRIBE `ports` 0.0012469291687012
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 0.00028800964355469
(107) DESCRIBE `ports` 0.0013377666473389
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00029397010803223
(109) DESCRIBE `ports` 0.0012650489807129
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00032901763916016
(111) DESCRIBE `ports` 0.0013008117675781
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00031900405883789
(113) DESCRIBE `ports` 0.0012400150299072
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00030803680419922
(115) DESCRIBE `ports` 0.0012860298156738
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5068))) 0.00029897689819336
(117) DESCRIBE `ports` 0.0012359619140625
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5068') 0.00028014183044434
(119) DESCRIBE `ports` 0.0012331008911133
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5645))) 0.0002901554107666
(121) DESCRIBE `ports` 0.0013608932495117
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5645') 0.0012218952178955
(123) DESCRIBE `ports` 0.001643180847168
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2779))) 0.00033807754516602
(125) DESCRIBE `ports` 0.0015358924865723
(126) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2779') 0.00029206275939941
(127) DESCRIBE `ports` 0.0014359951019287
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00030899047851562
(129) DESCRIBE `ports` 0.0012650489807129
(130) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00028705596923828
(131) DESCRIBE `cruises` 0.0027220249176025
(132) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 57672))) 0.00055408477783203
(133) DESCRIBE `avid_specials` 0.0017130374908447
(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.001924991607666
(135) DESCRIBE `cruiselines` 0.0020411014556885
(136) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 191))) 0.00040102005004883
(137) DESCRIBE `orchid_image` 0.001492977142334
(138) DESCRIBE `cruiselines` 0.0019729137420654
(139) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '191') 0.00048494338989258
(140) DESCRIBE `specials` 0.0037939548492432
(141) DESCRIBE `specials` 0.0045030117034912
(142) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1512771') 0.00038981437683105
(143) DESCRIBE `ships` 0.0028340816497803
(144) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1205))) 0.0004889965057373
(145) DESCRIBE `ships` 0.0029110908508301
(146) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1205') 0.00049495697021484
(147) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00030088424682617
(148) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025701522827148
(149) DESCRIBE `itineraries` 0.0016200542449951
(150) DESCRIBE `ports` 0.001384973526001
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00038290023803711
(152) DESCRIBE `ports` 0.0012760162353516
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00039196014404297
(154) DESCRIBE `ports` 0.0014479160308838
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00029921531677246
(156) DESCRIBE `specialsailingdates` 0.0011460781097412
(157) DESCRIBE `sailingdates` 0.0015289783477783
(158) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 485043))) 0.0004420280456543
(159) DESCRIBE `ports` 0.0013270378112793
(160) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0
(161) DESCRIBE `ports` 0.0012788772583008
(162) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00038886070251465
(163) DESCRIBE `ports` 0.001694917678833
(164) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00034594535827637
(165) DESCRIBE `ports` 0.0023341178894043
(166) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0
(167) DESCRIBE `ports` 0.0013360977172852
(168) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3671))) 0.00035691261291504
(169) DESCRIBE `ports` 0.0015299320220947
(170) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3671') 0.00032615661621094
(171) DESCRIBE `ports` 0.0014619827270508
(172) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2776))) 0
(173) DESCRIBE `ports` 0.0013840198516846
(174) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2776') 0.00027108192443848
(175) DESCRIBE `ports` 0.0016059875488281
(176) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0.00031280517578125
(177) DESCRIBE `ports` 0.0012400150299072
(178) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 0.00027894973754883
(179) DESCRIBE `ports` 0.0013260841369629
(180) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00029993057250977
(181) DESCRIBE `ports` 0.0012431144714355
(182) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00029587745666504
(183) DESCRIBE `ports` 0.00048303604125977
(184) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00032496452331543
(185) DESCRIBE `ports` 0.0013408660888672
(186) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0
(187) DESCRIBE `cruises` 0.0022449493408203
(188) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 48300))) 0.00096988677978516
(189) DESCRIBE `avid_specials` 0.0012650489807129
(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.002202033996582
(191) DESCRIBE `cruiselines` 0.0013959407806396
(192) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 191))) 0.00033807754516602
(193) DESCRIBE `orchid_image` 0.0016129016876221
(194) DESCRIBE `cruiselines` 0.0021920204162598
(195) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '191') 0.00034189224243164
(196) DESCRIBE `specials` 0.005382776260376
(197) DESCRIBE `specials` 0.0041739940643311
(198) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1512766') 0.00054812431335449
(199) DESCRIBE `ships` 0.0038089752197266
(200) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1032))) 0.0012450218200684
(201) DESCRIBE `ships` 0.0028488636016846
(202) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1032') 0.00039410591125488
(203) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026988983154297
(204) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0003361701965332
(205) DESCRIBE `itineraries` 0.0019640922546387
(206) DESCRIBE `ports` 0.0018579959869385
(207) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.0003359317779541
(208) DESCRIBE `ports` 0.0017309188842773
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00041294097900391
(210) DESCRIBE `ports` 0.0017929077148438
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') 0.00055480003356934
(212) DESCRIBE `specialsailingdates` 0.0012140274047852
(213) DESCRIBE `sailingdates` 0.0013070106506348
(214) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 485428))) 0.00036501884460449
(215) DESCRIBE `ports` 0.0014450550079346
(216) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00055789947509766
(217) DESCRIBE `ports` 0.0016648769378662
(218) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') 0.00038790702819824
(219) DESCRIBE `ports` 0.0015459060668945
(220) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00032806396484375
(221) DESCRIBE `ports` 0.0017609596252441
(222) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0
(223) DESCRIBE `ports` 0.0016798973083496
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00084900856018066
(225) DESCRIBE `ports` 0.0020029544830322
(226) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.0010640621185303
(227) DESCRIBE `ports` 0.0016911029815674
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00091886520385742
(229) DESCRIBE `ports` 0.0016331672668457
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') 0.00034809112548828
(231) DESCRIBE `cruises` 0.0034160614013672
(232) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 40591))) 7.8916549682617E-5
(233) DESCRIBE `avid_specials` 0.0014750957489014
(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.0012509822845459
(235) DESCRIBE `cruiselines` 0.0019040107727051
(236) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 191))) 0.00034594535827637
(237) DESCRIBE `orchid_image` 0.001500129699707
(238) DESCRIBE `cruiselines` 0.0020959377288818
(239) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '191') 0.00031113624572754
(240) DESCRIBE `specials` 0.0038430690765381
(241) DESCRIBE `specials` 0.0039718151092529
(242) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1511987') 0.00077199935913086
(243) DESCRIBE `ships` 0.0037250518798828
(244) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 333))) 0.00069093704223633
(245) DESCRIBE `ships` 0.00384521484375
(246) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '333') 0.00048708915710449
(247) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036001205444336
(248) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035285949707031
(249) DESCRIBE `itineraries` 0.00094795227050781
(250) DESCRIBE `ports` 0.0014011859893799
(251) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00045990943908691
(252) DESCRIBE `ports` 0.0018439292907715
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00047492980957031
(254) DESCRIBE `ports` 0.0021939277648926
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00050187110900879
(256) DESCRIBE `specialsailingdates` 0.0017809867858887
(257) DESCRIBE `sailingdates` 0.001406192779541
(258) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423912))) 0
(259) DESCRIBE `ports` 0.0015630722045898
(260) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00039410591125488
(261) DESCRIBE `ports` 0.0011649131774902
(262) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00049304962158203
(263) DESCRIBE `ports` 0.0019500255584717
(264) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 296))) 0.00049114227294922
(265) DESCRIBE `ports` 0.0019328594207764
(266) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '296') 0.00039410591125488
(267) DESCRIBE `ports` 0.0019059181213379
(268) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 412))) 0.00047492980957031
(269) DESCRIBE `ports` 0.0024402141571045
(270) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '412') 0.00019407272338867
(271) DESCRIBE `ports` 0.0018529891967773
(272) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.0013749599456787
(273) DESCRIBE `ports` 0.0017437934875488
(274) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00030398368835449
(275) DESCRIBE `ports` 0.0014488697052002
(276) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1727))) 0.00040197372436523
(277) DESCRIBE `ports` 0.0013508796691895
(278) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1727') 0.00029492378234863
(279) DESCRIBE `ports` 0.0013091564178467
(280) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00032782554626465
(281) DESCRIBE `ports` 0.0013999938964844
(282) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00028204917907715
(283) DESCRIBE `cruises` 0.0032029151916504
(284) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 47190))) 0.00044393539428711
(285) DESCRIBE `avid_specials` 0.0012509822845459
(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.001129150390625
(287) DESCRIBE `cruiselines` 0.0021419525146484
(288) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.0003969669342041
(289) DESCRIBE `orchid_image` 0.0017490386962891
(290) DESCRIBE `cruiselines` 0.0020411014556885
(291) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.0003659725189209
(292) DESCRIBE `specials` 0.0042920112609863
(293) DESCRIBE `specials` 0.0043740272521973
(294) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1512244') 0.00071907043457031
(295) DESCRIBE `ships` 0.0036849975585938
(296) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1320))) 0.0068471431732178
(297) DESCRIBE `ships` 0.0038459300994873
(298) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1320') 0.00056314468383789
(299) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034093856811523
(300) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033879280090332
(301) DESCRIBE `itineraries` 0.0020809173583984
(302) DESCRIBE `ports` 0.0015418529510498
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00037407875061035
(304) DESCRIBE `ports` 0.0014150142669678
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.0003199577331543
(306) DESCRIBE `ports` 0.0013539791107178
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.00029206275939941
(308) DESCRIBE `specialsailingdates` 0.0011239051818848
(309) DESCRIBE `sailingdates` 0.0011928081512451
(310) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 475646))) 0.00044989585876465
(311) DESCRIBE `ports` 0.0013411045074463
(312) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00032305717468262
(313) DESCRIBE `ports` 0.0013949871063232
(314) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.00032901763916016
(315) DESCRIBE `ports` 0.001427173614502
(316) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 0.00031208992004395
(317) DESCRIBE `ports` 0.0013301372528076
(318) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.00029611587524414
(319) DESCRIBE `ports` 0.0013668537139893
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2283))) 0.00042390823364258
(321) DESCRIBE `ports` 0.0018210411071777
(322) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2283') 0.00039291381835938
(323) DESCRIBE `ports` 0.001431941986084
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.00040578842163086
(325) DESCRIBE `ports` 0.0019960403442383
(326) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.00046110153198242
(327) DESCRIBE `ports` 0.0016400814056396
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00035595893859863
(329) DESCRIBE `ports` 0.0015289783477783
(330) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00034999847412109
(331) DESCRIBE `ports` 0.0013179779052734
(332) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00034499168395996
(333) DESCRIBE `ports` 0.0013370513916016
(334) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.00035595893859863
(335) DESCRIBE `cruises` 0.002669095993042
(336) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 75369))) 0.00051307678222656
(337) DESCRIBE `avid_specials` 0.00130295753479
(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.0016250610351562
(339) DESCRIBE `cruiselines` 0.0021209716796875
(340) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00035691261291504
(341) DESCRIBE `orchid_image` 0.0014967918395996
(342) DESCRIBE `cruiselines` 0.0019521713256836
(343) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00030994415283203
(344) DESCRIBE `specials` 0.0036711692810059
(345) DESCRIBE `specials` 0.0039231777191162
(346) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1512752') 0.00041794776916504
(347) DESCRIBE `ships` 0.0028359889984131
(348) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 521))) 0.00038909912109375
(349) DESCRIBE `ships` 0.0029680728912354
(350) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '521') 0.00045514106750488
(351) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00030803680419922
(352) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00033092498779297
(353) DESCRIBE `itineraries` 0.0016710758209229
(354) DESCRIBE `ports` 0.0017728805541992
(355) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00045084953308105
(356) DESCRIBE `ports` 0.0016241073608398
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00041294097900391
(358) DESCRIBE `ports` 0.0016129016876221
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2778') 0.00036382675170898
(360) DESCRIBE `specialsailingdates` 0.0012409687042236
(361) DESCRIBE `sailingdates` 0.0012581348419189
(362) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423040))) 0.00034785270690918
(363) DESCRIBE `ports` 0.0014081001281738
(364) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00033688545227051
(365) DESCRIBE `ports` 0.0013189315795898
(366) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2778') 0.00030016899108887
(367) DESCRIBE `ports` 0.0013689994812012
(368) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3490))) 0.0003211498260498
(369) DESCRIBE `ports` 0.0015149116516113
(370) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3490') 0.00031495094299316
(371) DESCRIBE `ports` 0.0014669895172119
(372) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5160))) 0.00033807754516602
(373) DESCRIBE `ports` 0.0014631748199463
(374) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5160') 0.00032782554626465
(375) DESCRIBE `ports` 0.001554012298584
(376) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00045609474182129
(377) DESCRIBE `ports` 0.0014569759368896
(378) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00036191940307617
(379) DESCRIBE `ports` 0.0014879703521729
(380) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4095))) 0.00032901763916016
(381) DESCRIBE `ports` 0.0013461112976074
(382) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4095') 0.00030183792114258
(383) DESCRIBE `ports` 0.0013470649719238
(384) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0.00035786628723145
(385) DESCRIBE `ports` 0.0014009475708008
(386) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 0.00033807754516602
(387) DESCRIBE `ports` 0.0013999938964844
(388) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2776))) 0.00031900405883789
(389) DESCRIBE `ports` 0.0013449192047119
(390) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2776') 0.00031304359436035
(391) DESCRIBE `ports` 0.0013298988342285
(392) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3671))) 0.00031113624572754
(393) DESCRIBE `ports` 0.0016388893127441
(394) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3671') 0.00028514862060547
(395) DESCRIBE `ports` 0.0013070106506348
(396) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2775))) 0.00041317939758301
(397) DESCRIBE `ports` 0.0015010833740234
(398) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2775') 0.00028395652770996
(399) DESCRIBE `ports` 0.0014238357543945
(400) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00030398368835449
(401) DESCRIBE `ports` 0.0013039112091064
(402) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00027298927307129
(403) DESCRIBE `cruises` 0.0025849342346191
(404) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 11517))) 0.00041103363037109
(405) DESCRIBE `avid_specials` 0.0011708736419678
(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.0011718273162842
(407) DESCRIBE `cruiselines` 0.0018689632415771
(408) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00034713745117188
(409) DESCRIBE `orchid_image` 0.0014991760253906
(410) DESCRIBE `cruiselines` 0.0019309520721436
(411) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00031495094299316
(412) DESCRIBE `specials` 0.0037319660186768
(413) DESCRIBE `specials` 0.0037469863891602
(414) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1512003') 0.00051307678222656
(415) DESCRIBE `ships` 0.0031249523162842
(416) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 582))) 0.00056314468383789
(417) DESCRIBE `ships` 0.0029881000518799
(418) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '582') 0.0004429817199707
(419) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029897689819336
(420) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002899169921875
(421) DESCRIBE `itineraries` 0.0015518665313721
(422) DESCRIBE `ports` 0.0015718936920166
(423) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.0010881423950195
(424) DESCRIBE `ports` 0.0016689300537109
(425) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00034713745117188
(426) DESCRIBE `ports` 0.0014071464538574
(427) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.0003211498260498
(428) DESCRIBE `specialsailingdates` 0.0013511180877686
(429) DESCRIBE `sailingdates` 0.0013041496276855
(430) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 424907))) 0.00041794776916504
(431) DESCRIBE `ports` 0.0016400814056396
(432) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00037288665771484
(433) DESCRIBE `ports` 0.0014321804046631
(434) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.0003509521484375
(435) DESCRIBE `ports` 0.0013589859008789
(436) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.00034117698669434
(437) DESCRIBE `ports` 0.0015408992767334
(438) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.00040721893310547
(439) DESCRIBE `ports` 0.0016658306121826
(440) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 327))) 0.0003669261932373
(441) DESCRIBE `ports` 0.0016100406646729
(442) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '327') 0.00031900405883789
(443) DESCRIBE `ports` 0.0013899803161621
(444) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00037002563476562
(445) DESCRIBE `ports` 0.0021200180053711
(446) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00034284591674805
(447) DESCRIBE `ports` 0.0014820098876953
(448) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.0004119873046875
(449) DESCRIBE `ports` 0.0016069412231445
(450) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.00038003921508789
(451) DESCRIBE `cruises` 0.002687931060791
(452) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 52584))) 0.0004279613494873
(453) DESCRIBE `avid_specials` 0.0012590885162354
(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.0017490386962891
(455) DESCRIBE `cruiselines` 0.0023610591888428
(456) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00048208236694336
(457) DESCRIBE `orchid_image` 0.0022270679473877
(458) DESCRIBE `cruiselines` 0.0022678375244141
(459) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.0005650520324707
(460) DESCRIBE `specials` 0.0046761035919189
(461) DESCRIBE `specials` 0.0039808750152588
(462) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1512019') 0.00038409233093262
(463) DESCRIBE `ships` 0.0027220249176025
(464) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 970))) 0.00039911270141602
(465) DESCRIBE `ships` 0.0027849674224854
(466) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '970') 0.0004270076751709
(467) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030612945556641
(468) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032210350036621
(469) DESCRIBE `itineraries` 0.0016868114471436
(470) DESCRIBE `ports` 0.0015828609466553
(471) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00045490264892578
(472) DESCRIBE `ports` 0.0014469623565674
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00033402442932129
(474) DESCRIBE `ports` 0.0014030933380127
(475) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00030303001403809
(476) DESCRIBE `specialsailingdates` 0.001121997833252
(477) DESCRIBE `sailingdates` 0.0012919902801514
(478) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423693))) 0.00034379959106445
(479) DESCRIBE `sailingdates` 0.0015478134155273
(480) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423694))) 0.00036406517028809
(481) DESCRIBE `ports` 0.0015361309051514
(482) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00039005279541016
(483) DESCRIBE `ports` 0.0019979476928711
(484) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00037407875061035
(485) DESCRIBE `ports` 0.0017318725585938
(486) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4894))) 0.00043988227844238
(487) DESCRIBE `ports` 0.0015349388122559
(488) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4894') 0.00041007995605469
(489) DESCRIBE `ports` 0.0013489723205566
(490) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.00016307830810547
(491) DESCRIBE `ports` 0.0017290115356445
(492) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.00030612945556641
(493) DESCRIBE `ports` 0.0013458728790283
(494) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00036907196044922
(495) DESCRIBE `ports` 0.001298189163208
(496) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.0003209114074707
(497) DESCRIBE `ports` 0.0013720989227295
(498) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1727))) 0.0003511905670166
(499) DESCRIBE `ports` 0.001366138458252
(500) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1727') 0.0003969669342041
(501) DESCRIBE `ports` 0.0015468597412109
(502) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00033020973205566
(503) DESCRIBE `ports` 0.0014710426330566
(504) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00024795532226562
(505) DESCRIBE `cruises` 0.0031740665435791
(506) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 67266))) 0.00055193901062012
(507) DESCRIBE `avid_specials` 0.0018019676208496
(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.0020689964294434
(509) DESCRIBE `cruiselines` 0.0023701190948486
(510) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00041317939758301
(511) DESCRIBE `orchid_image` 0.0017199516296387
(512) DESCRIBE `cruiselines` 0.0023667812347412
(513) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00026297569274902
(514) DESCRIBE `specials` 0.0039889812469482
(515) DESCRIBE `specials` 0.004425048828125
(516) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1511854') 0.00022602081298828
(517) DESCRIBE `ships` 0.0032618045806885
(518) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 669))) 0.00021100044250488
(519) DESCRIBE `ships` 0.0030570030212402
(520) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '669') 0.00088000297546387
(521) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00043892860412598
(522) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036096572875977
(523) DESCRIBE `itineraries` 0.0016129016876221
(524) DESCRIBE `ports` 0.0015449523925781
(525) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00021505355834961
(526) DESCRIBE `ports` 0.0019171237945557
(527) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00083613395690918
(528) DESCRIBE `ports` 0.0019369125366211
(529) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00037908554077148
(530) DESCRIBE `specialsailingdates` 0.0014019012451172
(531) DESCRIBE `sailingdates` 0.00083208084106445
(532) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 428520))) 0.00044107437133789
(533) DESCRIBE `sailingdates` 0.0015101432800293
(534) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 428521))) 0.00020384788513184
(535) DESCRIBE `ports` 0.0017409324645996
(536) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00030207633972168
(537) DESCRIBE `ports` 0.0017580986022949
(538) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 5.6982040405273E-5
(539) DESCRIBE `ports` 0.0017809867858887
(540) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.00031805038452148
(541) DESCRIBE `ports` 0.0014030933380127
(542) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0
(543) DESCRIBE `ports` 0.0014898777008057
(544) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2148))) 0.00094699859619141
(545) DESCRIBE `ports` 0.0015339851379395
(546) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2148') 0
(547) DESCRIBE `ports` 0.001943826675415
(548) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 166))) 0.00063395500183105
(549) DESCRIBE `ports` 0.0021328926086426
(550) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '166') 0.00066709518432617
(551) DESCRIBE `ports` 0.0014219284057617
(552) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 6.103515625E-5
(553) DESCRIBE `ports` 0.0014050006866455
(554) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0
(555) DESCRIBE `cruises` 0.0036070346832275
(556) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 67915))) 0.00022792816162109
(557) DESCRIBE `avid_specials` 0.0012869834899902
(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.0012538433074951
(559) DESCRIBE `cruiselines` 0.0031020641326904
(560) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 8.5830688476562E-5
(561) DESCRIBE `orchid_image` 0.0026040077209473
(562) DESCRIBE `cruiselines` 0.0026741027832031
(563) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0
(564) DESCRIBE `cruiselines` 0.0024480819702148
(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.00094509124755859
(566) DESCRIBE `ships` 0.0030350685119629
(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.0038931369781494
(568) DESCRIBE `cruisetypes` 0.0014879703521729
(569) DESCRIBE `destinations` 0.0036439895629883
(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.0012099742889404