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

# Query Time
(1) connect 0.00019311904907227
(2) DESCRIBE `cruises` 0.0041511058807373
(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.0028901100158691
(4) DESCRIBE `specials` 0.0052640438079834
(5) DESCRIBE `specials` 0.0048880577087402
(6) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1511652') 0.00095009803771973
(7) DESCRIBE `ships` 0.0034809112548828
(8) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1163))) 0.00050497055053711
(9) DESCRIBE `ships` 0.0032861232757568
(10) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1163') 0.00047421455383301
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00030088424682617
(12) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00028204917907715
(13) DESCRIBE `itineraries` 0.0018439292907715
(14) DESCRIBE `ports` 0.0018050670623779
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.00044417381286621
(16) DESCRIBE `ports` 0.0015909671783447
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.00038385391235352
(18) DESCRIBE `ports` 0.0015938282012939
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4804') 0.0003819465637207
(20) DESCRIBE `specialsailingdates` 0.0012898445129395
(21) DESCRIBE `sailingdates` 0.0015289783477783
(22) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 471642))) 0.00070500373840332
(23) DESCRIBE `ports` 0.0018200874328613
(24) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.00044488906860352
(25) DESCRIBE `ports` 0.0017518997192383
(26) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4804') 0.00038814544677734
(27) DESCRIBE `ports` 0.0016980171203613
(28) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.00049996376037598
(29) DESCRIBE `ports` 0.0018048286437988
(30) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4804') 0.00047707557678223
(31) DESCRIBE `ports` 0.0018579959869385
(32) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1229))) 0.00051307678222656
(33) DESCRIBE `ports` 0.0016360282897949
(34) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1229') 0.00039410591125488
(35) DESCRIBE `ports` 0.0016820430755615
(36) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00039196014404297
(37) DESCRIBE `ports` 0.0017681121826172
(38) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00038814544677734
(39) DESCRIBE `ports` 0.0016288757324219
(40) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3828))) 0.00051593780517578
(41) DESCRIBE `ports` 0.0017540454864502
(42) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3828') 0.00043392181396484
(43) DESCRIBE `ports` 0.00177001953125
(44) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3828))) 0.00041508674621582
(45) DESCRIBE `ports` 0.0016021728515625
(46) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3828') 0.00038909912109375
(47) DESCRIBE `ports` 0.0018019676208496
(48) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3829))) 0.00041794776916504
(49) DESCRIBE `ports` 0.0017650127410889
(50) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3829') 0.00032901763916016
(51) DESCRIBE `ports` 0.0014998912811279
(52) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 279))) 0.00046396255493164
(53) DESCRIBE `ports` 0.0015439987182617
(54) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '279') 0.00035309791564941
(55) DESCRIBE `ports` 0.0016689300537109
(56) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.00042915344238281
(57) DESCRIBE `ports` 0.0017080307006836
(58) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4804') 0.00035810470581055
(59) DESCRIBE `cruises` 0.0032248497009277
(60) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 74697))) 0.00066113471984863
(61) DESCRIBE `avid_specials` 0.0015110969543457
(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.0029468536376953
(63) DESCRIBE `cruiselines` 0.0025501251220703
(64) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00042581558227539
(65) DESCRIBE `orchid_image` 0.001878023147583
(66) DESCRIBE `cruiselines` 0.0024948120117188
(67) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00041794776916504
(68) DESCRIBE `specials` 0.0045890808105469
(69) DESCRIBE `specials` 0.0049111843109131
(70) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1512776') 0.00069499015808105
(71) DESCRIBE `ships` 0.0035200119018555
(72) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1205))) 0.00058603286743164
(73) DESCRIBE `ships` 0.0028290748596191
(74) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1205') 0.00075006484985352
(75) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00019693374633789
(76) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026082992553711
(77) DESCRIBE `itineraries` 0.0027651786804199
(78) DESCRIBE `ports` 0.0020720958709717
(79) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.0004730224609375
(80) DESCRIBE `ports` 0.0018432140350342
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00043487548828125
(82) DESCRIBE `ports` 0.0018160343170166
(83) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00039410591125488
(84) DESCRIBE `specialsailingdates` 0.0014050006866455
(85) DESCRIBE `sailingdates` 0.0016260147094727
(86) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 485016))) 0.00057601928710938
(87) DESCRIBE `ports` 0.0017189979553223
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00041818618774414
(89) DESCRIBE `ports` 0.0018148422241211
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00033998489379883
(91) DESCRIBE `ports` 0.0015599727630615
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00042009353637695
(93) DESCRIBE `ports` 0.0017437934875488
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00038504600524902
(95) DESCRIBE `ports` 0.0017588138580322
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3671))) 0.00034523010253906
(97) DESCRIBE `ports` 0.0014219284057617
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3671') 0.00037717819213867
(99) DESCRIBE `ports` 0.0015130043029785
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2776))) 0.00043797492980957
(101) DESCRIBE `ports` 0.0017199516296387
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2776') 0.00014400482177734
(103) DESCRIBE `ports` 0.0029819011688232
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0
(105) DESCRIBE `ports` 0.0028488636016846
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 4.1961669921875E-5
(107) DESCRIBE `ports` 0.0016529560089111
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.0012600421905518
(109) DESCRIBE `ports` 0.0011990070343018
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.0003819465637207
(111) DESCRIBE `ports` 0.0016698837280273
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00042819976806641
(113) DESCRIBE `ports` 0.0017020702362061
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00058913230895996
(115) DESCRIBE `ports` 0.0019979476928711
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5068))) 0.00048208236694336
(117) DESCRIBE `ports` 0.0023939609527588
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5068') 0.00048708915710449
(119) DESCRIBE `ports` 0.0017368793487549
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5645))) 0.00044584274291992
(121) DESCRIBE `ports` 0.0018019676208496
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5645') 0.00043487548828125
(123) DESCRIBE `ports` 0.0018680095672607
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2779))) 0.00046086311340332
(125) DESCRIBE `ports` 0.0019259452819824
(126) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2779') 0.00040292739868164
(127) DESCRIBE `ports` 0.0014629364013672
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.0005500316619873
(129) DESCRIBE `ports` 0.0019979476928711
(130) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00045084953308105
(131) DESCRIBE `cruises` 0.0037710666656494
(132) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 57672))) 0.00076794624328613
(133) DESCRIBE `avid_specials` 0.0014519691467285
(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.0013508796691895
(135) DESCRIBE `cruiselines` 0.0022289752960205
(136) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 191))) 0.00045609474182129
(137) DESCRIBE `orchid_image` 0.0017049312591553
(138) DESCRIBE `cruiselines` 0.0020558834075928
(139) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '191') 0.0003359317779541
(140) DESCRIBE `specials` 0.0045821666717529
(141) DESCRIBE `specials` 0.0057251453399658
(142) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1512771') 0.00063610076904297
(143) DESCRIBE `ships` 0.0040290355682373
(144) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1205))) 0.0006248950958252
(145) DESCRIBE `ships` 0.0040309429168701
(146) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1205') 0.0005640983581543
(147) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035691261291504
(148) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035214424133301
(149) DESCRIBE `itineraries` 0.0015251636505127
(150) DESCRIBE `ports` 0.0014090538024902
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00036811828613281
(152) DESCRIBE `ports` 0.0015990734100342
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00032806396484375
(154) DESCRIBE `ports` 0.001349925994873
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00033092498779297
(156) DESCRIBE `specialsailingdates` 0.001227855682373
(157) DESCRIBE `sailingdates` 0.001194953918457
(158) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 485043))) 0.0004880428314209
(159) DESCRIBE `ports` 0.0013880729675293
(160) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00041699409484863
(161) DESCRIBE `ports` 0.0014021396636963
(162) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00030398368835449
(163) DESCRIBE `ports` 0.0015099048614502
(164) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00034904479980469
(165) DESCRIBE `ports` 0.0015749931335449
(166) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.0003509521484375
(167) DESCRIBE `ports` 0.0016450881958008
(168) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3671))) 0.00034403800964355
(169) DESCRIBE `ports` 0.0013189315795898
(170) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3671') 0.00032591819763184
(171) DESCRIBE `ports` 0.0012810230255127
(172) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2776))) 0.00032210350036621
(173) DESCRIBE `ports` 0.0012969970703125
(174) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2776') 0.00028109550476074
(175) DESCRIBE `ports` 0.001511812210083
(176) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0.00032281875610352
(177) DESCRIBE `ports` 0.0014300346374512
(178) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 0.00030994415283203
(179) DESCRIBE `ports` 0.0014348030090332
(180) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00035309791564941
(181) DESCRIBE `ports` 0.0014059543609619
(182) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00030517578125
(183) DESCRIBE `ports` 0.0013999938964844
(184) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00050497055053711
(185) DESCRIBE `ports` 0.0014939308166504
(186) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00034809112548828
(187) DESCRIBE `cruises` 0.0034270286560059
(188) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 48300))) 0.0006859302520752
(189) DESCRIBE `avid_specials` 0.001460075378418
(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.0016889572143555
(191) DESCRIBE `cruiselines` 0.0027568340301514
(192) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 191))) 0.00048518180847168
(193) DESCRIBE `orchid_image` 0.0022268295288086
(194) DESCRIBE `cruiselines` 0.002500057220459
(195) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '191') 0.00044488906860352
(196) DESCRIBE `specials` 0.004810094833374
(197) DESCRIBE `specials` 0.0048110485076904
(198) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1512766') 0.00064802169799805
(199) DESCRIBE `ships` 0.0032830238342285
(200) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1032))) 0.00045990943908691
(201) DESCRIBE `ships` 0.003309965133667
(202) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1032') 0.0005180835723877
(203) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034904479980469
(204) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0003349781036377
(205) DESCRIBE `itineraries` 0.0019230842590332
(206) DESCRIBE `ports` 0.0020101070404053
(207) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00048685073852539
(208) DESCRIBE `ports` 0.0020058155059814
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00049400329589844
(210) DESCRIBE `ports` 0.0019690990447998
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') 0.00081419944763184
(212) DESCRIBE `specialsailingdates` 0.0018918514251709
(213) DESCRIBE `sailingdates` 0.0020320415496826
(214) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 485428))) 0.0010819435119629
(215) DESCRIBE `ports` 0.0019280910491943
(216) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.0004880428314209
(217) DESCRIBE `ports` 0.0019681453704834
(218) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') 0.0004270076751709
(219) DESCRIBE `ports` 0.0018730163574219
(220) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00051283836364746
(221) DESCRIBE `ports` 0.0019240379333496
(222) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00042390823364258
(223) DESCRIBE `ports` 0.0018310546875
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00052595138549805
(225) DESCRIBE `ports` 0.0018599033355713
(226) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00044107437133789
(227) DESCRIBE `ports` 0.0018470287322998
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.0006568431854248
(229) DESCRIBE `ports` 0.0018970966339111
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') 0.0004270076751709
(231) DESCRIBE `cruises` 0.0030241012573242
(232) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 40591))) 0.00057601928710938
(233) DESCRIBE `avid_specials` 0.0015029907226562
(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.0011558532714844
(235) DESCRIBE `cruiselines` 0.0020430088043213
(236) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 191))) 0.0003359317779541
(237) DESCRIBE `orchid_image` 0.0016970634460449
(238) DESCRIBE `cruiselines` 0.0021860599517822
(239) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '191') 0.00030684471130371
(240) DESCRIBE `specials` 0.003756046295166
(241) DESCRIBE `specials` 0.0042409896850586
(242) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1511987') 0.00083494186401367
(243) DESCRIBE `ships` 0.0040709972381592
(244) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 333))) 0.0006110668182373
(245) DESCRIBE `ships` 0.0030238628387451
(246) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '333') 0.00042581558227539
(247) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003199577331543
(248) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029802322387695
(249) DESCRIBE `itineraries` 0.0018270015716553
(250) DESCRIBE `ports` 0.0014820098876953
(251) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00048398971557617
(252) DESCRIBE `ports` 0.0017189979553223
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00042605400085449
(254) DESCRIBE `ports` 0.0018439292907715
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00040006637573242
(256) DESCRIBE `specialsailingdates` 0.0015909671783447
(257) DESCRIBE `sailingdates` 0.0021259784698486
(258) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423912))) 0.00063300132751465
(259) DESCRIBE `ports` 0.001910924911499
(260) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.0010650157928467
(261) DESCRIBE `ports` 0.0015959739685059
(262) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00035595893859863
(263) DESCRIBE `ports` 0.001823902130127
(264) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 296))) 0.00039410591125488
(265) DESCRIBE `ports` 0.0018441677093506
(266) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '296') 0.00040793418884277
(267) DESCRIBE `ports` 0.0021641254425049
(268) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 412))) 0.00053501129150391
(269) DESCRIBE `ports` 0.0025279521942139
(270) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '412') 0.00030183792114258
(271) DESCRIBE `ports` 0.001849889755249
(272) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00042414665222168
(273) DESCRIBE `ports` 0.0016028881072998
(274) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00037598609924316
(275) DESCRIBE `ports` 0.0023708343505859
(276) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1727))) 0.00054192543029785
(277) DESCRIBE `ports` 0.0020780563354492
(278) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1727') 0.00043320655822754
(279) DESCRIBE `ports` 0.0024981498718262
(280) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00051522254943848
(281) DESCRIBE `ports` 0.0020852088928223
(282) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00043082237243652
(283) DESCRIBE `cruises` 0.00360107421875
(284) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 47190))) 0
(285) DESCRIBE `avid_specials` 0.0016062259674072
(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.00097107887268066
(287) DESCRIBE `cruiselines` 0.0034480094909668
(288) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00046586990356445
(289) DESCRIBE `orchid_image` 0.0022330284118652
(290) DESCRIBE `cruiselines` 0.0027749538421631
(291) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00044107437133789
(292) DESCRIBE `specials` 0.0051398277282715
(293) DESCRIBE `specials` 0.0055270195007324
(294) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1512244') 0.00077295303344727
(295) DESCRIBE `ships` 0.0039429664611816
(296) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1320))) 0.00067496299743652
(297) DESCRIBE `ships` 0.0040109157562256
(298) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1320') 0.0005948543548584
(299) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032901763916016
(300) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028109550476074
(301) DESCRIBE `itineraries` 0.0018000602722168
(302) DESCRIBE `ports` 0.0015830993652344
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00040888786315918
(304) DESCRIBE `ports` 0.0015139579772949
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00032615661621094
(306) DESCRIBE `ports` 0.0014660358428955
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.00030398368835449
(308) DESCRIBE `specialsailingdates` 0.001270055770874
(309) DESCRIBE `sailingdates` 0.0013949871063232
(310) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 475646))) 0.00050997734069824
(311) DESCRIBE `ports` 0.0014450550079346
(312) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00034594535827637
(313) DESCRIBE `ports` 0.0014359951019287
(314) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.00042414665222168
(315) DESCRIBE `ports` 0.0021049976348877
(316) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 1.3828277587891E-5
(317) DESCRIBE `ports` 0.002640962600708
(318) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.00043201446533203
(319) DESCRIBE `ports` 0.0018579959869385
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2283))) 0.00048995018005371
(321) DESCRIBE `ports` 0.0022549629211426
(322) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2283') 0.00045299530029297
(323) DESCRIBE `ports` 0.0018200874328613
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.00053119659423828
(325) DESCRIBE `ports` 0.0017609596252441
(326) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.0005500316619873
(327) DESCRIBE `ports` 0.0021710395812988
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00045680999755859
(329) DESCRIBE `ports` 0.0019280910491943
(330) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00041794776916504
(331) DESCRIBE `ports` 0.0018651485443115
(332) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.0004570484161377
(333) DESCRIBE `ports` 0.0022299289703369
(334) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.00039815902709961
(335) DESCRIBE `cruises` 0.0035579204559326
(336) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 75369))) 0.00079703330993652
(337) DESCRIBE `avid_specials` 0.0014479160308838
(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.0011041164398193
(339) DESCRIBE `cruiselines` 0.0021131038665771
(340) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00044918060302734
(341) DESCRIBE `orchid_image` 0.0018188953399658
(342) DESCRIBE `cruiselines` 0.0025889873504639
(343) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00046205520629883
(344) DESCRIBE `specials` 0.0051510334014893
(345) DESCRIBE `specials` 0.0061559677124023
(346) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1512752') 0.00053095817565918
(347) DESCRIBE `ships` 0.0037717819213867
(348) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 521))) 0.00062012672424316
(349) DESCRIBE `ships` 0.0036981105804443
(350) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '521') 0.0009307861328125
(351) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00036001205444336
(352) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0003359317779541
(353) DESCRIBE `itineraries` 0.0018820762634277
(354) DESCRIBE `ports` 0.0020120143890381
(355) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00050091743469238
(356) DESCRIBE `ports` 0.0018670558929443
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00052905082702637
(358) DESCRIBE `ports` 0.0026781558990479
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2778') 0.00046992301940918
(360) DESCRIBE `specialsailingdates` 0.0014879703521729
(361) DESCRIBE `sailingdates` 0.0016119480133057
(362) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423040))) 0.00045108795166016
(363) DESCRIBE `ports` 0.0018107891082764
(364) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00043320655822754
(365) DESCRIBE `ports` 0.0017669200897217
(366) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2778') 0.0003821849822998
(367) DESCRIBE `ports` 0.0018320083618164
(368) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3490))) 0.00038981437683105
(369) DESCRIBE `ports` 0.0017688274383545
(370) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3490') 0.00035595893859863
(371) DESCRIBE `ports` 0.0017271041870117
(372) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5160))) 0.00049209594726562
(373) DESCRIBE `ports` 0.0017669200897217
(374) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5160') 0.00039505958557129
(375) DESCRIBE `ports` 0.0017549991607666
(376) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00041794776916504
(377) DESCRIBE `ports` 0.0017862319946289
(378) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00037693977355957
(379) DESCRIBE `ports` 0.0017459392547607
(380) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4095))) 0.00047898292541504
(381) DESCRIBE `ports` 0.0018911361694336
(382) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4095') 0.00047397613525391
(383) DESCRIBE `ports` 0.0019400119781494
(384) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0.00044012069702148
(385) DESCRIBE `ports` 0.0017020702362061
(386) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 0.00038313865661621
(387) DESCRIBE `ports` 0.001694917678833
(388) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2776))) 0.00037503242492676
(389) DESCRIBE `ports` 0.0017759799957275
(390) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2776') 0.00035691261291504
(391) DESCRIBE `ports` 0.0014479160308838
(392) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3671))) 0.00040602684020996
(393) DESCRIBE `ports` 0.0017619132995605
(394) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3671') 0.00046586990356445
(395) DESCRIBE `ports` 0.0018088817596436
(396) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2775))) 0.00041413307189941
(397) DESCRIBE `ports` 0.0018308162689209
(398) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2775') 0.00047588348388672
(399) DESCRIBE `ports` 0.0014851093292236
(400) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00037288665771484
(401) DESCRIBE `ports` 0.0014951229095459
(402) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.0002901554107666
(403) DESCRIBE `cruises` 0.0030169486999512
(404) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 11517))) 0.00059795379638672
(405) DESCRIBE `avid_specials` 0.0017509460449219
(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.001863956451416
(407) DESCRIBE `cruiselines` 0.0026729106903076
(408) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00059294700622559
(409) DESCRIBE `orchid_image` 0.0021810531616211
(410) DESCRIBE `cruiselines` 0.0029489994049072
(411) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00049996376037598
(412) DESCRIBE `specials` 0.0054240226745605
(413) DESCRIBE `specials` 0.0050079822540283
(414) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1512003') 0.00049281120300293
(415) DESCRIBE `ships` 0.003817081451416
(416) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 582))) 0.0006098747253418
(417) DESCRIBE `ships` 0.0034658908843994
(418) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '582') 0.00048089027404785
(419) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033783912658691
(420) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033211708068848
(421) DESCRIBE `itineraries` 0.0019428730010986
(422) DESCRIBE `ports` 0.0019378662109375
(423) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00048494338989258
(424) DESCRIBE `ports` 0.0018999576568604
(425) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00052189826965332
(426) DESCRIBE `ports` 0.0018458366394043
(427) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.00040698051452637
(428) DESCRIBE `specialsailingdates` 0.0014162063598633
(429) DESCRIBE `sailingdates` 0.0016078948974609
(430) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 424907))) 0.00043511390686035
(431) DESCRIBE `ports` 0.0018210411071777
(432) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.0004570484161377
(433) DESCRIBE `ports` 0.0017809867858887
(434) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.00040292739868164
(435) DESCRIBE `ports` 0.0018248558044434
(436) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.0004420280456543
(437) DESCRIBE `ports` 0.0018110275268555
(438) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.00038313865661621
(439) DESCRIBE `ports` 0.0016779899597168
(440) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 327))) 0.00046682357788086
(441) DESCRIBE `ports` 0.0018041133880615
(442) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '327') 0.00044608116149902
(443) DESCRIBE `ports` 0.0017220973968506
(444) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00045919418334961
(445) DESCRIBE `ports` 0.0017960071563721
(446) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00041699409484863
(447) DESCRIBE `ports` 0.0018360614776611
(448) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00062394142150879
(449) DESCRIBE `ports` 0.001957893371582
(450) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.00040292739868164
(451) DESCRIBE `cruises` 0.003425121307373
(452) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 52584))) 0.00066900253295898
(453) DESCRIBE `avid_specials` 0.0019810199737549
(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.001378059387207
(455) DESCRIBE `cruiselines` 0.0023181438446045
(456) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00043821334838867
(457) DESCRIBE `orchid_image` 0.0017411708831787
(458) DESCRIBE `cruiselines` 0.0027229785919189
(459) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00056886672973633
(460) DESCRIBE `specials` 0.0048470497131348
(461) DESCRIBE `specials` 0.0055789947509766
(462) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1512019') 0.0016078948974609
(463) DESCRIBE `ships` 0.0037069320678711
(464) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 970))) 0.00064992904663086
(465) DESCRIBE `ships` 0.0046989917755127
(466) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '970') 0.00036096572875977
(467) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00039100646972656
(468) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032997131347656
(469) DESCRIBE `itineraries` 0.0018830299377441
(470) DESCRIBE `ports` 0.0017690658569336
(471) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00047993659973145
(472) DESCRIBE `ports` 0.0018520355224609
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00043392181396484
(474) DESCRIBE `ports` 0.0017919540405273
(475) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00038599967956543
(476) DESCRIBE `specialsailingdates` 0.0015590190887451
(477) DESCRIBE `sailingdates` 0.0016791820526123
(478) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423693))) 0.00042819976806641
(479) DESCRIBE `sailingdates` 0.0015161037445068
(480) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423694))) 0.00041794776916504
(481) DESCRIBE `ports` 0.001978874206543
(482) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00047802925109863
(483) DESCRIBE `ports` 0.00177001953125
(484) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00053095817565918
(485) DESCRIBE `ports` 0.0017158985137939
(486) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4894))) 0.00041985511779785
(487) DESCRIBE `ports` 0.0017499923706055
(488) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4894') 0.00044918060302734
(489) DESCRIBE `ports` 0.0020101070404053
(490) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.00046992301940918
(491) DESCRIBE `ports` 0.0018348693847656
(492) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.00042605400085449
(493) DESCRIBE `ports` 0.0018391609191895
(494) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00048494338989258
(495) DESCRIBE `ports` 0.0018289089202881
(496) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00043106079101562
(497) DESCRIBE `ports` 0.0017390251159668
(498) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1727))) 0.00047683715820312
(499) DESCRIBE `ports` 0.0018150806427002
(500) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1727') 0.00043797492980957
(501) DESCRIBE `ports` 0.0018520355224609
(502) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00046610832214355
(503) DESCRIBE `ports` 0.0016138553619385
(504) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00039100646972656
(505) DESCRIBE `cruises` 0.0032169818878174
(506) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 67266))) 0.00046300888061523
(507) DESCRIBE `avid_specials` 0.0014510154724121
(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.001291036605835
(509) DESCRIBE `cruiselines` 0.0023210048675537
(510) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00040197372436523
(511) DESCRIBE `orchid_image` 0.00160813331604
(512) DESCRIBE `cruiselines` 0.0019941329956055
(513) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00036978721618652
(514) DESCRIBE `specials` 0.0041351318359375
(515) DESCRIBE `specials` 0.0054969787597656
(516) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1511854') 0.00063490867614746
(517) DESCRIBE `ships` 0.0035791397094727
(518) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 669))) 0.00048494338989258
(519) DESCRIBE `ships` 0.0030839443206787
(520) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '669') 0.00044083595275879
(521) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002739429473877
(522) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025486946105957
(523) DESCRIBE `itineraries` 0.0015919208526611
(524) DESCRIBE `ports` 0.0014889240264893
(525) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00036716461181641
(526) DESCRIBE `ports` 0.0012941360473633
(527) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00030708312988281
(528) DESCRIBE `ports` 0.0014948844909668
(529) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00034594535827637
(530) DESCRIBE `specialsailingdates` 0.00130295753479
(531) DESCRIBE `sailingdates` 0.0013179779052734
(532) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 428520))) 0.00047707557678223
(533) DESCRIBE `sailingdates` 0.0013411045074463
(534) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 428521))) 0.00034189224243164
(535) DESCRIBE `ports` 0.0014820098876953
(536) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00037598609924316
(537) DESCRIBE `ports` 0.0014438629150391
(538) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00035691261291504
(539) DESCRIBE `ports` 0.0013201236724854
(540) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.00034499168395996
(541) DESCRIBE `ports` 0.0013020038604736
(542) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.00028300285339355
(543) DESCRIBE `ports` 0.0017139911651611
(544) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2148))) 0.00036811828613281
(545) DESCRIBE `ports` 0.0015518665313721
(546) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2148') 0.00034594535827637
(547) DESCRIBE `ports` 0.0017039775848389
(548) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 166))) 0.00041389465332031
(549) DESCRIBE `ports` 0.0015559196472168
(550) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '166') 0.00032591819763184
(551) DESCRIBE `ports` 0.00142502784729
(552) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00041794776916504
(553) DESCRIBE `ports` 0.0021100044250488
(554) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00047802925109863
(555) DESCRIBE `cruises` 0.0036830902099609
(556) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 67915))) 0.00055217742919922
(557) DESCRIBE `avid_specials` 0.0018279552459717
(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.0019011497497559
(559) DESCRIBE `cruiselines` 0.0027940273284912
(560) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00053596496582031
(561) DESCRIBE `orchid_image` 0.0019919872283936
(562) DESCRIBE `cruiselines` 0.0024499893188477
(563) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00065398216247559
(564) DESCRIBE `cruiselines` 0.0029830932617188
(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.0010948181152344
(566) DESCRIBE `ships` 0.0050880908966064
(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.0055510997772217
(568) DESCRIBE `cruisetypes` 0.0018229484558105
(569) DESCRIBE `destinations` 0.0024149417877197
(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.0018291473388672