or, enquire about your chosen options

  1. Royal Caribbean Launch “Royal Up”
  2. Catch Up on Cruising: Latest News in bite size!
  3. Drinks Package Comparison
  4. Regal Princess heads down under!
  5. Catch Up on Cruising: Latest News in bite size!

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

Total elapsed time: 1.4129064083099

# Query Time
(1) connect 0.0021519660949707
(2) DESCRIBE `cruises` 0.0063009262084961
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (70319, 74753, 74671, 74669, 67334, 64046, 78021, 78025, 74675, 70318)) ORDER BY FIND_IN_SET(id, '70319,74753,74671,74669,67334,64046,78021,78025,74675,70318') 0.0026500225067139
(4) DESCRIBE `cruises` 0.0053458213806152
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70319') 0.00053501129150391
(6) DESCRIBE `ships` 0.0039570331573486
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1260))) 0.00056815147399902
(8) DESCRIBE `ships` 0.0059130191802979
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1260') 0.00060915946960449
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00033998489379883
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00041604042053223
(12) DESCRIBE `itineraries` 0.0041899681091309
(13) DESCRIBE `ports` 0.0021889209747314
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00059890747070312
(15) DESCRIBE `ports` 0.0019850730895996
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.0004429817199707
(17) DESCRIBE `ports` 0.0026960372924805
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.0006411075592041
(19) DESCRIBE `sailingdates` 0.0021820068359375
(20) DESCRIBE `ports` 0.0093660354614258
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00065302848815918
(22) DESCRIBE `ports` 0.0028049945831299
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00042915344238281
(24) DESCRIBE `ports` 0.0020430088043213
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00044703483581543
(26) DESCRIBE `ports` 0.0019271373748779
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00041699409484863
(28) DESCRIBE `ports` 0.0020589828491211
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 648))) 0.00050497055053711
(30) DESCRIBE `ports` 0.0020210742950439
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '648') 0.00043392181396484
(32) DESCRIBE `ports` 0.0020699501037598
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 801))) 0.00048494338989258
(34) DESCRIBE `ports` 0.002208948135376
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '801') 0.00035500526428223
(36) DESCRIBE `ports` 0.0018510818481445
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 801))) 0.00041985511779785
(38) DESCRIBE `ports` 0.0018489360809326
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '801') 0.00034999847412109
(40) DESCRIBE `ports` 0.0018417835235596
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 227))) 0.00037288665771484
(42) DESCRIBE `ports` 0.0019359588623047
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '227') 0.00034022331237793
(44) DESCRIBE `ports` 0.0019741058349609
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 227))) 0.00035405158996582
(46) DESCRIBE `ports` 0.0019791126251221
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '227') 0.00034904479980469
(48) DESCRIBE `ports` 0.0013489723205566
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 272))) 0.00036501884460449
(50) DESCRIBE `ports` 0.0016839504241943
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '272') 0.00028300285339355
(52) DESCRIBE `ports` 0.0013630390167236
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 574))) 0.00029301643371582
(54) DESCRIBE `ports` 0.0014300346374512
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '574') 0.0002748966217041
(56) DESCRIBE `ports` 0.0015640258789062
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00031805038452148
(58) DESCRIBE `ports` 0.0016789436340332
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00028204917907715
(60) DESCRIBE `avid_specials` 0.0012290477752686
(61) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70319 and class = 'Cruise') OR (item_id = 1260 AND class = 'Ship') OR (item_id = 262 AND class = 'CruiseLine') OR (item_id = 25 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.0024690628051758
(62) DESCRIBE `cruiselines` 0.0026421546936035
(63) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262))) 0.00033092498779297
(64) DESCRIBE `orchid_image` 0.0016629695892334
(65) DESCRIBE `cruiselines` 0.0022299289703369
(66) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '262') 0.00029802322387695
(67) DESCRIBE `cruises` 0.0040290355682373
(68) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74753') 0.00039196014404297
(69) DESCRIBE `ships` 0.0032920837402344
(70) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1208))) 0.00036478042602539
(71) DESCRIBE `ships` 0.003126859664917
(72) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1208') 0.00044107437133789
(73) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00027799606323242
(74) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00030684471130371
(75) DESCRIBE `itineraries` 0.0021119117736816
(76) DESCRIBE `ports` 0.0024640560150146
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00050592422485352
(78) DESCRIBE `ports` 0.0030989646911621
(79) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00055813789367676
(80) DESCRIBE `ports` 0.004004955291748
(81) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00041508674621582
(82) DESCRIBE `sailingdates` 0.0066330432891846
(83) DESCRIBE `ports` 0.0020089149475098
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00046491622924805
(85) DESCRIBE `ports` 0.0022242069244385
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00075602531433105
(87) DESCRIBE `ports` 0.0030410289764404
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3349))) 0.0005340576171875
(89) DESCRIBE `ports` 0.0029611587524414
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3349') 0.00058603286743164
(91) DESCRIBE `ports` 0.0028409957885742
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3349))) 0.0021100044250488
(93) DESCRIBE `ports` 0.0057229995727539
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3349') 0.0089519023895264
(95) DESCRIBE `ports` 0.0023210048675537
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3349))) 0.0060939788818359
(97) DESCRIBE `ports` 0.0034248828887939
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3349') 0.00082898139953613
(99) DESCRIBE `ports` 0.0053360462188721
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2151))) 0.00053119659423828
(101) DESCRIBE `ports` 0.0020818710327148
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2151') 0.00036287307739258
(103) DESCRIBE `ports` 0.0039858818054199
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00044608116149902
(105) DESCRIBE `ports` 0.015753984451294
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.0004279613494873
(107) DESCRIBE `avid_specials` 0.0020759105682373
(108) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74753 and class = 'Cruise') OR (item_id = 1208 AND class = 'Ship') OR (item_id = 262 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.011518001556396
(109) DESCRIBE `cruiselines` 0.0092780590057373
(110) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262))) 0.00054812431335449
(111) DESCRIBE `orchid_image` 0.0035080909729004
(112) DESCRIBE `cruiselines` 0.002985954284668
(113) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '262') 0.00048303604125977
(114) DESCRIBE `cruises` 0.0036029815673828
(115) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74671') 0.0004570484161377
(116) DESCRIBE `ships` 0.021822929382324
(117) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1704))) 0.0016980171203613
(118) DESCRIBE `ships` 0.0057101249694824
(119) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1704') 0.0019690990447998
(120) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.0028760433197021
(121) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.0016331672668457
(122) DESCRIBE `itineraries` 0.0018539428710938
(123) DESCRIBE `ports` 0.0019190311431885
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00052094459533691
(125) DESCRIBE `ports` 0.0019769668579102
(126) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0023581981658936
(127) DESCRIBE `ports` 0.0074059963226318
(128) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.0043821334838867
(129) DESCRIBE `sailingdates` 0.0023200511932373
(130) DESCRIBE `ports` 0.0022909641265869
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00058507919311523
(132) DESCRIBE `ports` 0.0038812160491943
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00041699409484863
(134) DESCRIBE `ports` 0.0063788890838623
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0028119087219238
(136) DESCRIBE `ports` 0.0050451755523682
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00055193901062012
(138) DESCRIBE `ports` 0.0076730251312256
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1623))) 0.00046491622924805
(140) DESCRIBE `ports` 0.0039801597595215
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1623') 0.0004570484161377
(142) DESCRIBE `ports` 0.0019102096557617
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 586))) 0.00046706199645996
(144) DESCRIBE `ports` 0.0021669864654541
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '586') 0.00098299980163574
(146) DESCRIBE `ports` 0.002187967300415
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 587))) 0.00057005882263184
(148) DESCRIBE `ports` 0.0025908946990967
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '587') 0.00041508674621582
(150) DESCRIBE `ports` 0.002100944519043
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3150))) 0.00053596496582031
(152) DESCRIBE `ports` 0.0026791095733643
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3150') 0.001708984375
(154) DESCRIBE `ports` 0.005418062210083
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00066089630126953
(156) DESCRIBE `ports` 0.002979040145874
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00056815147399902
(158) DESCRIBE `ports` 0.0019540786743164
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00047016143798828
(160) DESCRIBE `ports` 0.002100944519043
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00051712989807129
(162) DESCRIBE `ports` 0.0019309520721436
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00049495697021484
(164) DESCRIBE `ports` 0.0020430088043213
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.0004580020904541
(166) DESCRIBE `ports` 0.023720026016235
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.0020790100097656
(168) DESCRIBE `ports` 0.0087151527404785
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00051498413085938
(170) DESCRIBE `ports` 0.0018510818481445
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1709))) 0.0005028247833252
(172) DESCRIBE `ports` 0.0019679069519043
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1709') 0.00050497055053711
(174) DESCRIBE `ports` 0.0018770694732666
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00050997734069824
(176) DESCRIBE `ports` 0.0021939277648926
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00044918060302734
(178) DESCRIBE `ports` 0.0021300315856934
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00069594383239746
(180) DESCRIBE `ports` 0.0020849704742432
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00058197975158691
(182) DESCRIBE `ports` 0.0020010471343994
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00059890747070312
(184) DESCRIBE `ports` 0.0018799304962158
(185) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00040483474731445
(186) DESCRIBE `ports` 0.0016369819641113
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0003969669342041
(188) DESCRIBE `ports` 0.0016930103302002
(189) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00037789344787598
(190) DESCRIBE `avid_specials` 0.0017569065093994
(191) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74671 and class = 'Cruise') OR (item_id = 1704 AND class = 'Ship') OR (item_id = 262 AND class = 'CruiseLine') OR (item_id = 22 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.0020849704742432
(192) DESCRIBE `cruiselines` 0.0032291412353516
(193) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262))) 0.00052690505981445
(194) DESCRIBE `orchid_image` 0.003972053527832
(195) DESCRIBE `cruiselines` 0.0031380653381348
(196) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '262') 0.0005030632019043
(197) DESCRIBE `cruises` 0.0042629241943359
(198) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74669') 0.00048089027404785
(199) DESCRIBE `ships` 0.0064239501953125
(200) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1704))) 0.0005800724029541
(201) DESCRIBE `ships` 0.0042049884796143
(202) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1704') 0.00057315826416016
(203) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00034379959106445
(204) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00035905838012695
(205) DESCRIBE `itineraries` 0.0044529438018799
(206) DESCRIBE `ports` 0.0030760765075684
(207) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0018210411071777
(208) DESCRIBE `ports` 0.0021069049835205
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00049781799316406
(210) DESCRIBE `ports` 0.016305923461914
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.000701904296875
(212) DESCRIBE `sailingdates` 0.0023200511932373
(213) DESCRIBE `ports` 0.011636972427368
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00079488754272461
(215) DESCRIBE `ports` 0.0020270347595215
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00044798851013184
(217) DESCRIBE `ports` 0.0026359558105469
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00052618980407715
(219) DESCRIBE `ports` 0.0020110607147217
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00043392181396484
(221) DESCRIBE `ports` 0.0021471977233887
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1623))) 0.00077509880065918
(223) DESCRIBE `ports` 0.002140998840332
(224) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1623') 0.0005490779876709
(225) DESCRIBE `ports` 0.0020790100097656
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 586))) 0.00048208236694336
(227) DESCRIBE `ports` 0.002065896987915
(228) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '586') 0.00045084953308105
(229) DESCRIBE `ports` 0.0022900104522705
(230) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 587))) 0.00060701370239258
(231) DESCRIBE `ports` 0.0019500255584717
(232) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '587') 0.00038409233093262
(233) DESCRIBE `ports` 0.0018289089202881
(234) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3150))) 0.00052809715270996
(235) DESCRIBE `ports` 0.0019290447235107
(236) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3150') 0.00052285194396973
(237) DESCRIBE `ports` 0.0019271373748779
(238) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.0004880428314209
(239) DESCRIBE `ports` 0.0022768974304199
(240) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00051307678222656
(241) DESCRIBE `ports` 0.0024781227111816
(242) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00050806999206543
(243) DESCRIBE `ports` 0.0021319389343262
(244) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00052285194396973
(245) DESCRIBE `avid_specials` 0.015069007873535
(246) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74669 and class = 'Cruise') OR (item_id = 1704 AND class = 'Ship') OR (item_id = 262 AND class = 'CruiseLine') OR (item_id = 22 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.0090351104736328
(247) DESCRIBE `cruiselines` 0.0029959678649902
(248) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262))) 0.00064516067504883
(249) DESCRIBE `orchid_image` 0.0025069713592529
(250) DESCRIBE `cruiselines` 0.0039029121398926
(251) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '262') 0.00066900253295898
(252) DESCRIBE `cruises` 0.0036888122558594
(253) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67334') 0.00058698654174805
(254) DESCRIBE `ships` 0.0039849281311035
(255) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1492))) 0.0007178783416748
(256) DESCRIBE `ships` 0.0039849281311035
(257) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1492') 0.00063109397888184
(258) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00037407875061035
(259) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00031495094299316
(260) DESCRIBE `itineraries` 0.0021078586578369
(261) DESCRIBE `ports` 0.0023019313812256
(262) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00050520896911621
(263) DESCRIBE `ports` 0.0023870468139648
(264) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00060200691223145
(265) DESCRIBE `ports` 0.002047061920166
(266) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00041699409484863
(267) DESCRIBE `sailingdates` 0.0018830299377441
(268) DESCRIBE `ports` 0.016481876373291
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00060296058654785
(270) DESCRIBE `ports` 0.0085170269012451
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00073599815368652
(272) DESCRIBE `ports` 0.015558004379272
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0022401809692383
(274) DESCRIBE `ports` 0.021464824676514
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00063800811767578
(276) DESCRIBE `ports` 0.0041189193725586
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00060296058654785
(278) DESCRIBE `ports` 0.0021109580993652
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00055909156799316
(280) DESCRIBE `ports` 0.0025279521942139
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00053596496582031
(282) DESCRIBE `ports` 0.003140926361084
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00051784515380859
(284) DESCRIBE `ports` 0.0022459030151367
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00047707557678223
(286) DESCRIBE `ports` 0.0025100708007812
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00042891502380371
(288) DESCRIBE `ports` 0.0018479824066162
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2228))) 0.00048995018005371
(290) DESCRIBE `ports` 0.0041499137878418
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2228') 0.00052094459533691
(292) DESCRIBE `ports` 0.0019729137420654
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00054001808166504
(294) DESCRIBE `ports` 0.0021541118621826
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00051498413085938
(296) DESCRIBE `ports` 0.0021359920501709
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00049090385437012
(298) DESCRIBE `ports` 0.0021610260009766
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00042891502380371
(300) DESCRIBE `ports` 0.0029439926147461
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00051307678222656
(302) DESCRIBE `ports` 0.0022740364074707
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00088596343994141
(304) DESCRIBE `ports` 0.0031490325927734
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00051999092102051
(306) DESCRIBE `ports` 0.0032651424407959
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0024168491363525
(308) DESCRIBE `ports` 0.014506816864014
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00045323371887207
(310) DESCRIBE `ports` 0.004918098449707
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00048089027404785
(312) DESCRIBE `avid_specials` 0.0028510093688965
(313) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67334 and class = 'Cruise') OR (item_id = 1492 AND class = 'Ship') OR (item_id = 262 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0019659996032715
(314) DESCRIBE `cruiselines` 0.0058150291442871
(315) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262))) 0.00063204765319824
(316) DESCRIBE `orchid_image` 0.0028889179229736
(317) DESCRIBE `cruiselines` 0.0031349658966064
(318) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '262') 0.0003969669342041
(319) DESCRIBE `cruises` 0.0039830207824707
(320) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64046') 0.00051116943359375
(321) DESCRIBE `ships` 0.0041539669036865
(322) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1259))) 0.00058078765869141
(323) DESCRIBE `ships` 0.01056694984436
(324) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1259') 0.00043201446533203
(325) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00034594535827637
(326) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00030207633972168
(327) DESCRIBE `itineraries` 0.0037181377410889
(328) DESCRIBE `ports` 0.0019779205322266
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00041794776916504
(330) DESCRIBE `ports` 0.0017728805541992
(331) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00036191940307617
(332) DESCRIBE `ports` 0.0054929256439209
(333) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00053501129150391
(334) DESCRIBE `sailingdates` 0.0064468383789062
(335) DESCRIBE `ports` 0.002377986907959
(336) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.0012080669403076
(337) DESCRIBE `ports` 0.0034840106964111
(338) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.0010218620300293
(339) DESCRIBE `ports` 0.0040750503540039
(340) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00041508674621582
(341) DESCRIBE `ports` 0.0019550323486328
(342) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.0016021728515625
(343) DESCRIBE `ports` 0.0030679702758789
(344) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 410))) 0.0015358924865723
(345) DESCRIBE `ports` 0.0056889057159424
(346) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '410') 0.00042200088500977
(347) DESCRIBE `ports` 0.0026369094848633
(348) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 349))) 0.0005950927734375
(349) DESCRIBE `ports` 0.0018320083618164
(350) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '349') 0.00036311149597168
(351) DESCRIBE `ports` 0.0073399543762207
(352) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 307))) 0.0005791187286377
(353) DESCRIBE `ports` 0.006788969039917
(354) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '307') 0.00046491622924805
(355) DESCRIBE `ports` 0.0053558349609375
(356) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00057387351989746
(357) DESCRIBE `ports` 0.0024738311767578
(358) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.0013818740844727
(359) DESCRIBE `ports` 0.004601001739502
(360) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 663))) 0.00053906440734863
(361) DESCRIBE `ports` 0.0036149024963379
(362) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '663') 0.0010838508605957
(363) DESCRIBE `ports` 0.0030539035797119
(364) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 365))) 0.00051689147949219
(365) DESCRIBE `ports` 0.0029990673065186
(366) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '365') 0.0006101131439209
(367) DESCRIBE `ports` 0.0018551349639893
(368) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00046205520629883
(369) DESCRIBE `ports` 0.0040879249572754
(370) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00066089630126953
(371) DESCRIBE `ports` 0.0022730827331543
(372) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 347))) 0.00053191184997559
(373) DESCRIBE `ports` 0.0020821094512939
(374) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '347') 0.0004279613494873
(375) DESCRIBE `ports` 0.0019359588623047
(376) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00050497055053711
(377) DESCRIBE `ports` 0.0022828578948975
(378) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00050997734069824
(379) DESCRIBE `avid_specials` 0.002918004989624
(380) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 64046 and class = 'Cruise') OR (item_id = 1259 AND class = 'Ship') OR (item_id = 262 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.0019330978393555
(381) DESCRIBE `cruiselines` 0.0027999877929688
(382) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262))) 0.00059294700622559
(383) DESCRIBE `orchid_image` 0.0022420883178711
(384) DESCRIBE `cruiselines` 0.0053818225860596
(385) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '262') 0.00053000450134277
(386) DESCRIBE `cruises` 0.0042929649353027
(387) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '78021') 0.0005040168762207
(388) DESCRIBE `ships` 0.0041160583496094
(389) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1208))) 0.00069522857666016
(390) DESCRIBE `ships` 0.0056672096252441
(391) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1208') 0.00053596496582031
(392) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00034809112548828
(393) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00032997131347656
(394) DESCRIBE `itineraries` 0.0018460750579834
(395) DESCRIBE `ports` 0.0042521953582764
(396) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00041389465332031
(397) DESCRIBE `ports` 0.0033769607543945
(398) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00054192543029785
(399) DESCRIBE `ports` 0.0019710063934326
(400) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00042319297790527
(401) DESCRIBE `sailingdates` 0.002161979675293
(402) DESCRIBE `ports` 0.0019340515136719
(403) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00047016143798828
(404) DESCRIBE `ports` 0.0027461051940918
(405) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00050091743469238
(406) DESCRIBE `ports` 0.0030100345611572
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00060892105102539
(408) DESCRIBE `ports` 0.0024681091308594
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00045895576477051
(410) DESCRIBE `ports` 0.002161979675293
(411) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 628))) 0.00070595741271973
(412) DESCRIBE `ports` 0.0022368431091309
(413) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '628') 0.0004570484161377
(414) DESCRIBE `ports` 0.0022101402282715
(415) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00041890144348145
(416) DESCRIBE `ports` 0.0033180713653564
(417) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.0005650520324707
(418) DESCRIBE `ports` 0.0019688606262207
(419) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.0005338191986084
(420) DESCRIBE `ports` 0.0022528171539307
(421) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00050806999206543
(422) DESCRIBE `ports` 0.002018928527832
(423) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00064897537231445
(424) DESCRIBE `ports` 0.0036740303039551
(425) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00057005882263184
(426) DESCRIBE `ports` 0.0032260417938232
(427) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00049996376037598
(428) DESCRIBE `ports` 0.002687931060791
(429) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00057291984558105
(430) DESCRIBE `ports` 0.0024609565734863
(431) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00061988830566406
(432) DESCRIBE `ports` 0.002830982208252
(433) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.0015521049499512
(434) DESCRIBE `ports` 0.0020949840545654
(435) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00051307678222656
(436) DESCRIBE `ports` 0.0021979808807373
(437) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00050187110900879
(438) DESCRIBE `ports` 0.0032191276550293
(439) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00058388710021973
(440) DESCRIBE `ports` 0.0023429393768311
(441) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00052809715270996
(442) DESCRIBE `ports` 0.0021359920501709
(443) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00040602684020996
(444) DESCRIBE `ports` 0.0029590129852295
(445) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00048112869262695
(446) DESCRIBE `ports` 0.002208948135376
(447) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00051283836364746
(448) DESCRIBE `ports` 0.0045948028564453
(449) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00073909759521484
(450) DESCRIBE `ports` 0.0034267902374268
(451) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00059795379638672
(452) DESCRIBE `ports` 0.0020620822906494
(453) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00044584274291992
(454) DESCRIBE `ports` 0.0024039745330811
(455) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00059795379638672
(456) DESCRIBE `ports` 0.002255916595459
(457) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00040197372436523
(458) DESCRIBE `ports` 0.002122163772583
(459) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00049710273742676
(460) DESCRIBE `ports` 0.002190113067627
(461) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00040698051452637
(462) DESCRIBE `ports` 0.001945972442627
(463) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0004279613494873
(464) DESCRIBE `ports` 0.0029449462890625
(465) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00061798095703125
(466) DESCRIBE `avid_specials` 0.0016658306121826
(467) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 78021 and class = 'Cruise') OR (item_id = 1208 AND class = 'Ship') OR (item_id = 262 AND class = 'CruiseLine') OR (item_id = 38 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.0020308494567871
(468) DESCRIBE `cruiselines` 0.0028188228607178
(469) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262))) 0.00056600570678711
(470) DESCRIBE `orchid_image` 0.0026719570159912
(471) DESCRIBE `cruiselines` 0.0029900074005127
(472) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '262') 0.00054001808166504
(473) DESCRIBE `cruises` 0.0040810108184814
(474) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '78025') 0.00053691864013672
(475) DESCRIBE `ships` 0.0039961338043213
(476) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1208))) 0.00062990188598633
(477) DESCRIBE `ships` 0.0037829875946045
(478) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1208') 0.00047016143798828
(479) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00034904479980469
(480) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00033712387084961
(481) DESCRIBE `itineraries` 0.0018332004547119
(482) DESCRIBE `ports` 0.0016770362854004
(483) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00038003921508789
(484) DESCRIBE `ports` 0.01557183265686
(485) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00066781044006348
(486) DESCRIBE `ports` 0.0021071434020996
(487) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00052213668823242
(488) DESCRIBE `sailingdates` 0.0017440319061279
(489) DESCRIBE `ports` 0.0021460056304932
(490) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0089490413665771
(491) DESCRIBE `ports` 0.0022189617156982
(492) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.0012900829315186
(493) DESCRIBE `ports` 0.0021350383758545
(494) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.0004880428314209
(495) DESCRIBE `ports` 0.0019669532775879
(496) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.0029969215393066
(497) DESCRIBE `ports` 0.0021388530731201
(498) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 628))) 0.00054287910461426
(499) DESCRIBE `ports` 0.0020749568939209
(500) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '628') 0.00057816505432129
(501) DESCRIBE `ports` 0.0021259784698486
(502) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00070691108703613
(503) DESCRIBE `ports` 0.0020549297332764
(504) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00047993659973145
(505) DESCRIBE `ports` 0.0019681453704834
(506) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00060606002807617
(507) DESCRIBE `ports` 0.0020020008087158
(508) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00044798851013184
(509) DESCRIBE `avid_specials` 0.0017678737640381
(510) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 78025 and class = 'Cruise') OR (item_id = 1208 AND class = 'Ship') OR (item_id = 262 AND class = 'CruiseLine') OR (item_id = 38 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.0019481182098389
(511) DESCRIBE `cruiselines` 0.0030338764190674
(512) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262))) 0.00064802169799805
(513) DESCRIBE `orchid_image` 0.0026841163635254
(514) DESCRIBE `cruiselines` 0.0029470920562744
(515) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '262') 0.00056314468383789
(516) DESCRIBE `cruises` 0.0037460327148438
(517) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74675') 0.00061988830566406
(518) DESCRIBE `ships` 0.0046470165252686
(519) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1704))) 0.00083589553833008
(520) DESCRIBE `ships` 0.0042989253997803
(521) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1704') 0.00059103965759277
(522) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00036406517028809
(523) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00032305717468262
(524) DESCRIBE `itineraries` 0.0022590160369873
(525) DESCRIBE `ports` 0.0024509429931641
(526) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00052094459533691
(527) DESCRIBE `ports` 0.0021159648895264
(528) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00057792663574219
(529) DESCRIBE `ports` 0.0021920204162598
(530) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00046586990356445
(531) DESCRIBE `sailingdates` 0.0019090175628662
(532) DESCRIBE `ports` 0.0020802021026611
(533) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00054097175598145
(534) DESCRIBE `ports` 0.0019171237945557
(535) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00047397613525391
(536) DESCRIBE `ports` 0.0020978450775146
(537) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00053501129150391
(538) DESCRIBE `ports` 0.0034289360046387
(539) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00062417984008789
(540) DESCRIBE `ports` 0.0024189949035645
(541) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.001021146774292
(542) DESCRIBE `ports` 0.0022788047790527
(543) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00052094459533691
(544) DESCRIBE `ports` 0.0021018981933594
(545) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1709))) 0.00049495697021484
(546) DESCRIBE `ports` 0.0019741058349609
(547) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1709') 0.0010859966278076
(548) DESCRIBE `ports` 0.0034220218658447
(549) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.0007481575012207
(550) DESCRIBE `ports` 0.002471923828125
(551) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00093507766723633
(552) DESCRIBE `ports` 0.004647970199585
(553) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00065112113952637
(554) DESCRIBE `ports` 0.0027589797973633
(555) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.0008089542388916
(556) DESCRIBE `ports` 0.0034480094909668
(557) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00058603286743164
(558) DESCRIBE `ports` 0.0032351016998291
(559) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00060296058654785
(560) DESCRIBE `ports` 0.0021710395812988
(561) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00051712989807129
(562) DESCRIBE `ports` 0.0020120143890381
(563) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00048112869262695
(564) DESCRIBE `ports` 0.0032360553741455
(565) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00069093704223633
(566) DESCRIBE `ports` 0.0020928382873535
(567) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00049495697021484
(568) DESCRIBE `ports` 0.0020511150360107
(569) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1623))) 0.0005650520324707
(570) DESCRIBE `ports` 0.0022139549255371
(571) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1623') 0.00047993659973145
(572) DESCRIBE `ports` 0.0020730495452881
(573) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 586))) 0.00046801567077637
(574) DESCRIBE `ports` 0.0030710697174072
(575) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '586') 0.00044488906860352
(576) DESCRIBE `ports` 0.0021030902862549
(577) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 587))) 0.0005340576171875
(578) DESCRIBE `ports` 0.0022339820861816
(579) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '587') 0.0005640983581543
(580) DESCRIBE `ports` 0.0022261142730713
(581) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3150))) 0.00057196617126465
(582) DESCRIBE `ports` 0.0021929740905762
(583) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3150') 0.0005028247833252
(584) DESCRIBE `ports` 0.0029110908508301
(585) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00059890747070312
(586) DESCRIBE `ports` 0.0020568370819092
(587) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00050806999206543
(588) DESCRIBE `ports` 0.0024309158325195
(589) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.0007169246673584
(590) DESCRIBE `ports` 0.0021629333496094
(591) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00049400329589844
(592) DESCRIBE `avid_specials` 0.0019259452819824
(593) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74675 and class = 'Cruise') OR (item_id = 1704 AND class = 'Ship') OR (item_id = 262 AND class = 'CruiseLine') OR (item_id = 22 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.0019760131835938
(594) DESCRIBE `cruiselines` 0.0029089450836182
(595) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262))) 0.00053501129150391
(596) DESCRIBE `orchid_image` 0.0022749900817871
(597) DESCRIBE `cruiselines` 0.003140926361084
(598) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '262') 0.00057315826416016
(599) DESCRIBE `cruises` 0.0039899349212646
(600) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70318') 0.00059103965759277
(601) DESCRIBE `ships` 0.0049488544464111
(602) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1260))) 0.00080609321594238
(603) DESCRIBE `ships` 0.0040948390960693
(604) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1260') 0.00079488754272461
(605) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00035381317138672
(606) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.0003359317779541
(607) DESCRIBE `itineraries` 0.0033600330352783
(608) DESCRIBE `ports` 0.0028200149536133
(609) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00049495697021484
(610) DESCRIBE `ports` 0.0034279823303223
(611) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00057411193847656
(612) DESCRIBE `ports` 0.0023119449615479
(613) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00056600570678711
(614) DESCRIBE `sailingdates` 0.0018110275268555
(615) DESCRIBE `ports` 0.0021660327911377
(616) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00059103965759277
(617) DESCRIBE `ports` 0.0019278526306152
(618) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00047779083251953
(619) DESCRIBE `ports` 0.0020310878753662
(620) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 574))) 0.00052905082702637
(621) DESCRIBE `ports` 0.0020489692687988
(622) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '574') 0.00050115585327148
(623) DESCRIBE `ports` 0.0021240711212158
(624) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 272))) 0.00059390068054199
(625) DESCRIBE `ports` 0.0020971298217773
(626) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '272') 0.00067305564880371
(627) DESCRIBE `ports` 0.0025758743286133
(628) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 227))) 0.00055289268493652
(629) DESCRIBE `ports` 0.0022900104522705
(630) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '227') 0.00065994262695312
(631) DESCRIBE `ports` 0.0027580261230469
(632) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 227))) 0.00055384635925293
(633) DESCRIBE `ports` 0.0019829273223877
(634) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '227') 0.00042414665222168
(635) DESCRIBE `ports` 0.0019989013671875
(636) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 801))) 0.00056099891662598
(637) DESCRIBE `ports` 0.0027589797973633
(638) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '801') 0.00051498413085938
(639) DESCRIBE `ports` 0.002018928527832
(640) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 801))) 0.00051689147949219
(641) DESCRIBE `ports` 0.0038938522338867
(642) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '801') 0.00056314468383789
(643) DESCRIBE `ports` 0.0022451877593994
(644) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 648))) 0.00053811073303223
(645) DESCRIBE `ports` 0.0027189254760742
(646) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '648') 0.00056195259094238
(647) DESCRIBE `ports` 0.0022280216217041
(648) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00055599212646484
(649) DESCRIBE `ports` 0.0020709037780762
(650) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00048613548278809
(651) DESCRIBE `ports` 0.002100944519043
(652) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.0005040168762207
(653) DESCRIBE `ports` 0.0017859935760498
(654) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00042295455932617
(655) DESCRIBE `avid_specials` 0.0015969276428223
(656) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70318 and class = 'Cruise') OR (item_id = 1260 AND class = 'Ship') OR (item_id = 262 AND class = 'CruiseLine') OR (item_id = 25 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.0018138885498047
(657) DESCRIBE `cruiselines` 0.002708911895752
(658) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262))) 0.00052094459533691
(659) DESCRIBE `orchid_image` 0.0020451545715332
(660) DESCRIBE `cruiselines` 0.0027689933776855
(661) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '262') 0.00049805641174316
(662) DESCRIBE `ships` 0.0043411254882812
(663) SELECT `ships`.* FROM `ships` WHERE (id IN ('1259', '1260', '1208', '1492', '1704', '1474')) ORDER BY FIND_IN_SET(id, '1259,1260,1208,1492,1704,1474') 0.0014550685882568
(664) DESCRIBE `cruisetypes` 0.0019218921661377
(665) DESCRIBE `destinations` 0.0028820037841797
(666) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '26', '25', '35', '12', '2', '21', '38', '49', '40', '37', '28', '43', '8', '11', '48', '52')) ORDER BY FIND_IN_SET(id, '22,26,25,35,12,2,21,38,49,40,37,28,43,8,11,48,52') 0.0021030902862549
(667) DESCRIBE `cruiselines` 0.0035159587860107
(668) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262))) 0.00063610076904297
(669) DESCRIBE `cruiselines` 0.0029737949371338
(670) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262))) 0.00066208839416504