or, enquire about your chosen options

  1. Catch Up on Cruising: Latest News in bite size!
  2. Cruise Ship Lingo? Look like a cruise expert before you get on the ship
  3. BREAKING NEWS FOR PRINCESS FANS: Register your interest now!!!
  4. Catch Up on Cruising: Latest News in bite size!
  5. Review: China – Part Two

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

Total elapsed time: 0.62365078926086

# Query Time
(1) connect 0.0014569759368896
(2) DESCRIBE `cruises` 0.0042810440063477
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (68941, 69002, 69080, 69508, 69517, 69536, 69850, 69918, 70029, 70410)) ORDER BY FIND_IN_SET(id, '68941,69002,69080,69508,69517,69536,69850,69918,70029,70410') 0.001986026763916
(4) DESCRIBE `cruises` 0.0030519962310791
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68941') 0.00037312507629395
(6) DESCRIBE `ships` 0.0028340816497803
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 711))) 0.00042891502380371
(8) DESCRIBE `ships` 0.002748966217041
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '711') 0.00028300285339355
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00025606155395508
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.0002439022064209
(12) DESCRIBE `itineraries` 0.0013711452484131
(13) DESCRIBE `ports` 0.0012979507446289
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00033211708068848
(15) DESCRIBE `ports` 0.0012321472167969
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00027990341186523
(17) DESCRIBE `ports` 0.0013189315795898
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00027799606323242
(19) DESCRIBE `sailingdates` 0.0013341903686523
(20) DESCRIBE `ports` 0.0012640953063965
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00030183792114258
(22) DESCRIBE `ports` 0.001262903213501
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00027084350585938
(24) DESCRIBE `ports` 0.0012581348419189
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2476))) 0.00028395652770996
(26) DESCRIBE `ports` 0.0014429092407227
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2476') 0.00026988983154297
(28) DESCRIBE `ports` 0.0012400150299072
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 370))) 0.00028705596923828
(30) DESCRIBE `ports` 0.0013129711151123
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '370') 0.00026488304138184
(32) DESCRIBE `ports` 0.0015289783477783
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00034594535827637
(34) DESCRIBE `ports` 0.0023751258850098
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00028300285339355
(36) DESCRIBE `ports` 0.0013740062713623
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3293))) 0.00029301643371582
(38) DESCRIBE `ports` 0.0013191699981689
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3293') 0.00027203559875488
(40) DESCRIBE `ports` 0.0012249946594238
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 694))) 0.00026988983154297
(42) DESCRIBE `ports` 0.001338005065918
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '694') 0.0003049373626709
(44) DESCRIBE `ports` 0.0012879371643066
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1252))) 0.00029110908508301
(46) DESCRIBE `ports` 0.0012381076812744
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1252') 0.00026798248291016
(48) DESCRIBE `ports` 0.0012221336364746
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00030016899108887
(50) DESCRIBE `ports` 0.0012259483337402
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00026679039001465
(52) DESCRIBE `avid_specials` 0.0010941028594971
(53) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68941 and class = 'Cruise') OR (item_id = 711 AND class = 'Ship') OR (item_id = 28 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.0010409355163574
(54) DESCRIBE `cruiselines` 0.0017950534820557
(55) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 28))) 0.00037693977355957
(56) DESCRIBE `orchid_image` 0.0014338493347168
(57) DESCRIBE `cruises` 0.0028278827667236
(58) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69002') 0.00035214424133301
(59) DESCRIBE `ships` 0.0030241012573242
(60) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1453))) 0.0005040168762207
(61) DESCRIBE `ships` 0.0032930374145508
(62) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1453') 0.00032520294189453
(63) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00029611587524414
(64) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025606155395508
(65) DESCRIBE `itineraries` 0.0012979507446289
(66) DESCRIBE `ports` 0.0013449192047119
(67) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00035691261291504
(68) DESCRIBE `ports` 0.0013470649719238
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00032782554626465
(70) DESCRIBE `ports` 0.0013711452484131
(71) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00029301643371582
(72) DESCRIBE `sailingdates` 0.001121997833252
(73) DESCRIBE `ports` 0.0013611316680908
(74) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.0003201961517334
(75) DESCRIBE `ports` 0.0012381076812744
(76) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00033807754516602
(77) DESCRIBE `ports` 0.0012969970703125
(78) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3685))) 0.00031495094299316
(79) DESCRIBE `ports` 0.0013329982757568
(80) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3685') 0.00028491020202637
(81) DESCRIBE `ports` 0.0016541481018066
(82) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1592))) 0.00030803680419922
(83) DESCRIBE `ports` 0.0013217926025391
(84) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1592') 0.00027799606323242
(85) DESCRIBE `ports` 0.0012459754943848
(86) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1563))) 0.00030398368835449
(87) DESCRIBE `ports` 0.0012869834899902
(88) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1563') 0.00028586387634277
(89) DESCRIBE `ports` 0.0012400150299072
(90) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1564))) 0.00029301643371582
(91) DESCRIBE `ports` 0.0012681484222412
(92) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1564') 0.00028705596923828
(93) DESCRIBE `ports` 0.0012600421905518
(94) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2093))) 0.00032496452331543
(95) DESCRIBE `ports` 0.0012960433959961
(96) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2093') 0.00027084350585938
(97) DESCRIBE `ports` 0.0012400150299072
(98) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1594))) 0.00038504600524902
(99) DESCRIBE `ports` 0.0013620853424072
(100) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1594') 0.00027298927307129
(101) DESCRIBE `ports` 0.0012669563293457
(102) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1590))) 0.00028896331787109
(103) DESCRIBE `ports` 0.0012929439544678
(104) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1590') 0.00027203559875488
(105) DESCRIBE `ports` 0.0013251304626465
(106) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2004))) 0.00032210350036621
(107) DESCRIBE `ports` 0.0012381076812744
(108) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2004') 0.00027108192443848
(109) DESCRIBE `ports` 0.001295804977417
(110) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2379))) 0.00029897689819336
(111) DESCRIBE `ports` 0.0012350082397461
(112) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2379') 0.00035691261291504
(113) DESCRIBE `avid_specials` 0.0011241436004639
(114) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69002 and class = 'Cruise') OR (item_id = 1453 AND class = 'Ship') OR (item_id = 77 AND class = 'CruiseLine') OR (item_id = 50 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010051727294922
(115) DESCRIBE `cruiselines` 0.0021481513977051
(116) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.0003669261932373
(117) DESCRIBE `orchid_image` 0.0019409656524658
(118) DESCRIBE `cruiselines` 0.0023109912872314
(119) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.0003960132598877
(120) DESCRIBE `cruises` 0.0025441646575928
(121) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69080') 0.0003209114074707
(122) DESCRIBE `ships` 0.0025439262390137
(123) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1588))) 0.00037121772766113
(124) DESCRIBE `ships` 0.0030219554901123
(125) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1588') 0.00042891502380371
(126) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00038504600524902
(127) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033283233642578
(128) DESCRIBE `itineraries` 0.0018138885498047
(129) DESCRIBE `ports` 0.0019049644470215
(130) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.0004570484161377
(131) DESCRIBE `ports` 0.0015718936920166
(132) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00040102005004883
(133) DESCRIBE `ports` 0.0017681121826172
(134) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00037503242492676
(135) DESCRIBE `sailingdates` 0.0011630058288574
(136) DESCRIBE `ports` 0.0012879371643066
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00031280517578125
(138) DESCRIBE `ports` 0.001323938369751
(139) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00027990341186523
(140) DESCRIBE `ports` 0.0012421607971191
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00029301643371582
(142) DESCRIBE `ports` 0.0012829303741455
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00027298927307129
(144) DESCRIBE `ports` 0.0012409687042236
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00030303001403809
(146) DESCRIBE `ports` 0.0013139247894287
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.0002741813659668
(148) DESCRIBE `ports` 0.0012390613555908
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00029492378234863
(150) DESCRIBE `ports` 0.0012550354003906
(151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00034594535827637
(152) DESCRIBE `ports` 0.0017201900482178
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00036501884460449
(154) DESCRIBE `ports` 0.001478910446167
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00029802322387695
(156) DESCRIBE `ports` 0.0012729167938232
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.0003058910369873
(158) DESCRIBE `ports` 0.0013020038604736
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00035405158996582
(160) DESCRIBE `ports` 0.0012807846069336
(161) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00031399726867676
(162) DESCRIBE `ports` 0.0015850067138672
(163) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00030899047851562
(164) DESCRIBE `avid_specials` 0.0015008449554443
(165) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69080 and class = 'Cruise') OR (item_id = 1588 AND class = 'Ship') OR (item_id = 19 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.0012640953063965
(166) DESCRIBE `cruiselines` 0.0020809173583984
(167) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00036001205444336
(168) DESCRIBE `orchid_image` 0.0015602111816406
(169) DESCRIBE `cruiselines` 0.0022530555725098
(170) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.0003509521484375
(171) DESCRIBE `cruises` 0.0024909973144531
(172) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69508') 0.00035786628723145
(173) DESCRIBE `ships` 0.0029258728027344
(174) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 162))) 0.00056695938110352
(175) DESCRIBE `ships` 0.0033340454101562
(176) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '162') 0.00030708312988281
(177) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026893615722656
(178) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00025606155395508
(179) DESCRIBE `itineraries` 0.0013329982757568
(180) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69508') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00091814994812012
(181) DESCRIBE `ports` 0.0014090538024902
(182) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00034904479980469
(183) DESCRIBE `ports` 0.001690149307251
(184) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00037002563476562
(185) DESCRIBE `ports` 0.0012660026550293
(186) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00027894973754883
(187) DESCRIBE `sailingdates` 0.0012221336364746
(188) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69508') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00082993507385254
(189) DESCRIBE `ports` 0.0015740394592285
(190) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00033402442932129
(191) DESCRIBE `ports` 0.0012779235839844
(192) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00035500526428223
(193) DESCRIBE `ports` 0.0012321472167969
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1119))) 0.00030612945556641
(195) DESCRIBE `ports` 0.0014209747314453
(196) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1119') 0.00027322769165039
(197) DESCRIBE `ports` 0.0013628005981445
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2171))) 0.0003819465637207
(199) DESCRIBE `ports` 0.0014119148254395
(200) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2171') 0.00032711029052734
(201) DESCRIBE `ports` 0.0012500286102295
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 578))) 0.00034809112548828
(203) DESCRIBE `ports` 0.0012760162353516
(204) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '578') 0.00032591819763184
(205) DESCRIBE `ports` 0.0018219947814941
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 277))) 0.00040602684020996
(207) DESCRIBE `ports` 0.0025351047515869
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '277') 0.00041484832763672
(209) DESCRIBE `ports` 0.001533031463623
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.0003211498260498
(211) DESCRIBE `ports` 0.0013589859008789
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00028800964355469
(213) DESCRIBE `ports` 0.0013530254364014
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00031614303588867
(215) DESCRIBE `ports` 0.0013260841369629
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00036001205444336
(217) DESCRIBE `avid_specials` 0.0013020038604736
(218) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69508 and class = 'Cruise') OR (item_id = 162 AND class = 'Ship') OR (item_id = 33 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.0016567707061768
(219) DESCRIBE `cruiselines` 0.0021560192108154
(220) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.0003509521484375
(221) DESCRIBE `orchid_image` 0.0014910697937012
(222) DESCRIBE `cruiselines` 0.0018739700317383
(223) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.00036883354187012
(224) DESCRIBE `cruises` 0.0032191276550293
(225) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69517') 0.00052404403686523
(226) DESCRIBE `ships` 0.003040075302124
(227) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 160))) 0.00045013427734375
(228) DESCRIBE `ships` 0.0030028820037842
(229) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '160') 0.00028610229492188
(230) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026893615722656
(231) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026106834411621
(232) DESCRIBE `itineraries` 0.0012822151184082
(233) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69517') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0010058879852295
(234) DESCRIBE `ports` 0.0020041465759277
(235) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00043606758117676
(236) DESCRIBE `ports` 0.0013430118560791
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00030112266540527
(238) DESCRIBE `ports` 0.0012531280517578
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00030207633972168
(240) DESCRIBE `sailingdates` 0.0011610984802246
(241) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69517') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00068402290344238
(242) DESCRIBE `ports` 0.0013580322265625
(243) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00032711029052734
(244) DESCRIBE `ports` 0.0013220310211182
(245) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00027894973754883
(246) DESCRIBE `ports` 0.0012779235839844
(247) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1119))) 0.00030016899108887
(248) DESCRIBE `ports` 0.0013279914855957
(249) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1119') 0.00028300285339355
(250) DESCRIBE `ports` 0.0013120174407959
(251) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 386))) 0.00030207633972168
(252) DESCRIBE `ports` 0.0013058185577393
(253) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '386') 0.00028800964355469
(254) DESCRIBE `ports` 0.0012588500976562
(255) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00029993057250977
(256) DESCRIBE `ports` 0.0013618469238281
(257) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00027108192443848
(258) DESCRIBE `ports` 0.0012409687042236
(259) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.00036096572875977
(260) DESCRIBE `ports` 0.0013980865478516
(261) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.00032782554626465
(262) DESCRIBE `ports` 0.0014820098876953
(263) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 910))) 0.00036406517028809
(264) DESCRIBE `ports` 0.0015518665313721
(265) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '910') 0.00030922889709473
(266) DESCRIBE `ports` 0.0014328956604004
(267) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 909))) 0.00029397010803223
(268) DESCRIBE `ports` 0.0012459754943848
(269) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '909') 0.0002739429473877
(270) DESCRIBE `ports` 0.0014688968658447
(271) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.0003659725189209
(272) DESCRIBE `ports` 0.0015339851379395
(273) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00037693977355957
(274) DESCRIBE `avid_specials` 0.0015280246734619
(275) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69517 and class = 'Cruise') OR (item_id = 160 AND class = 'Ship') OR (item_id = 33 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.0013518333435059
(276) DESCRIBE `cruiselines` 0.0018680095672607
(277) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00033688545227051
(278) DESCRIBE `orchid_image` 0.0014171600341797
(279) DESCRIBE `cruiselines` 0.0017850399017334
(280) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.00029492378234863
(281) DESCRIBE `cruises` 0.0027620792388916
(282) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69536') 0.00038385391235352
(283) DESCRIBE `ships` 0.0026481151580811
(284) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1601))) 0.00041007995605469
(285) DESCRIBE `ships` 0.0025880336761475
(286) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1601') 0.00030207633972168
(287) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00026702880859375
(288) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00025391578674316
(289) DESCRIBE `itineraries` 0.001262903213501
(290) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69536') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00054788589477539
(291) DESCRIBE `ports` 0.0013158321380615
(292) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00031495094299316
(293) DESCRIBE `ports` 0.0012509822845459
(294) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00029611587524414
(295) DESCRIBE `ports` 0.0012731552124023
(296) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.0002739429473877
(297) DESCRIBE `sailingdates` 0.0011081695556641
(298) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69536') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00066804885864258
(299) DESCRIBE `ports` 0.0012869834899902
(300) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00030684471130371
(301) DESCRIBE `ports` 0.0012938976287842
(302) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00029206275939941
(303) DESCRIBE `ports` 0.0017790794372559
(304) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1835))) 0.00036001205444336
(305) DESCRIBE `ports` 0.00140380859375
(306) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1835') 0.00043702125549316
(307) DESCRIBE `ports` 0.0016269683837891
(308) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1811))) 0.00041794776916504
(309) DESCRIBE `ports` 0.001288890838623
(310) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1811') 0.00027704238891602
(311) DESCRIBE `ports` 0.0013449192047119
(312) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5608))) 0.00030899047851562
(313) DESCRIBE `ports` 0.0013418197631836
(314) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5608') 0.00029206275939941
(315) DESCRIBE `ports` 0.0012388229370117
(316) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3035))) 0.00033807754516602
(317) DESCRIBE `ports` 0.0012481212615967
(318) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3035') 0.00028204917907715
(319) DESCRIBE `ports` 0.0012998580932617
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1814))) 0.00028896331787109
(321) DESCRIBE `ports` 0.0012779235839844
(322) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1814') 0.00026202201843262
(323) DESCRIBE `ports` 0.0013210773468018
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2704))) 0.00031900405883789
(325) DESCRIBE `ports` 0.0015408992767334
(326) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2704') 0.00028014183044434
(327) DESCRIBE `ports` 0.0015220642089844
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00040912628173828
(329) DESCRIBE `ports` 0.0017008781433105
(330) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00036191940307617
(331) DESCRIBE `avid_specials` 0.0012979507446289
(332) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69536 and class = 'Cruise') OR (item_id = 1601 AND class = 'Ship') OR (item_id = 103 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.0010490417480469
(333) DESCRIBE `cruiselines` 0.0018529891967773
(334) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 103))) 0.00032305717468262
(335) DESCRIBE `orchid_image` 0.001399040222168
(336) DESCRIBE `cruiselines` 0.0018370151519775
(337) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '103') 0.00029087066650391
(338) DESCRIBE `cruises` 0.0027050971984863
(339) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69850') 0.00031113624572754
(340) DESCRIBE `ships` 0.0026330947875977
(341) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1026))) 0.00038385391235352
(342) DESCRIBE `ships` 0.0025639533996582
(343) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1026') 0.00030612945556641
(344) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034403800964355
(345) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025606155395508
(346) DESCRIBE `itineraries` 0.0012178421020508
(347) DESCRIBE `ports` 0.0012860298156738
(348) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00031709671020508
(349) DESCRIBE `ports` 0.0012679100036621
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00035691261291504
(351) DESCRIBE `ports` 0.0012710094451904
(352) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00031709671020508
(353) DESCRIBE `sailingdates` 0.0011279582977295
(354) DESCRIBE `ports` 0.0018699169158936
(355) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00044679641723633
(356) DESCRIBE `ports` 0.0017099380493164
(357) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00029778480529785
(358) DESCRIBE `ports` 0.001453161239624
(359) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00030398368835449
(360) DESCRIBE `ports` 0.0013210773468018
(361) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00028300285339355
(362) DESCRIBE `ports` 0.0014071464538574
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4087))) 0.00030803680419922
(364) DESCRIBE `ports` 0.0013120174407959
(365) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4087') 0.00029277801513672
(366) DESCRIBE `ports` 0.0012588500976562
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4088))) 0.00028491020202637
(368) DESCRIBE `ports` 0.0014128684997559
(369) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4088') 0.00039815902709961
(370) DESCRIBE `ports` 0.0019538402557373
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4904))) 0.00046396255493164
(372) DESCRIBE `ports` 0.0016500949859619
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4904') 0.0002899169921875
(374) DESCRIBE `ports` 0.0012519359588623
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4086))) 0.00033903121948242
(376) DESCRIBE `ports` 0.0012519359588623
(377) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4086') 0.00029802322387695
(378) DESCRIBE `ports` 0.0013501644134521
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2673))) 0.00030398368835449
(380) DESCRIBE `ports` 0.00124192237854
(381) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2673') 0.00026702880859375
(382) DESCRIBE `ports` 0.001317024230957
(383) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00039100646972656
(384) DESCRIBE `ports` 0.0018131732940674
(385) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00028800964355469
(386) DESCRIBE `ports` 0.0012838840484619
(387) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00029706954956055
(388) DESCRIBE `ports` 0.0013978481292725
(389) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.0003359317779541
(390) DESCRIBE `avid_specials` 0.0011379718780518
(391) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69850 and class = 'Cruise') OR (item_id = 1026 AND class = 'Ship') OR (item_id = 77 AND class = 'CruiseLine') OR (item_id = 50 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0012679100036621
(392) DESCRIBE `cruiselines` 0.0025279521942139
(393) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.0004279613494873
(394) DESCRIBE `orchid_image` 0.0020720958709717
(395) DESCRIBE `cruiselines` 0.0022661685943604
(396) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.00035405158996582
(397) DESCRIBE `cruises` 0.0032341480255127
(398) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69918') 0.0003359317779541
(399) DESCRIBE `ships` 0.0025360584259033
(400) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 715))) 0.00034689903259277
(401) DESCRIBE `ships` 0.0024950504302979
(402) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '715') 0.00026798248291016
(403) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026202201843262
(404) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00024795532226562
(405) DESCRIBE `itineraries` 0.0012218952178955
(406) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69918') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0010409355163574
(407) DESCRIBE `ports` 0.0014479160308838
(408) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00032997131347656
(409) DESCRIBE `ports` 0.001399040222168
(410) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00030398368835449
(411) DESCRIBE `ports` 0.0013430118560791
(412) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00033307075500488
(413) DESCRIBE `sailingdates` 0.0013949871063232
(414) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69918') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00091385841369629
(415) DESCRIBE `ports` 0.0018260478973389
(416) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00038695335388184
(417) DESCRIBE `ports` 0.0012879371643066
(418) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00030899047851562
(419) DESCRIBE `ports` 0.001276969909668
(420) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 764))) 0.00034403800964355
(421) DESCRIBE `ports` 0.0012519359588623
(422) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '764') 0.0003509521484375
(423) DESCRIBE `ports` 0.0014820098876953
(424) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00038790702819824
(425) DESCRIBE `ports` 0.0017998218536377
(426) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00034499168395996
(427) DESCRIBE `ports` 0.0017249584197998
(428) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 370))) 0.00037598609924316
(429) DESCRIBE `ports` 0.0015780925750732
(430) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '370') 0.00028514862060547
(431) DESCRIBE `ports` 0.0012750625610352
(432) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00028705596923828
(433) DESCRIBE `ports` 0.0012829303741455
(434) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00036501884460449
(435) DESCRIBE `ports` 0.0017228126525879
(436) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00042200088500977
(437) DESCRIBE `ports` 0.0017180442810059
(438) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00028395652770996
(439) DESCRIBE `ports` 0.0013020038604736
(440) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00029206275939941
(441) DESCRIBE `ports` 0.0013039112091064
(442) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00026392936706543
(443) DESCRIBE `avid_specials` 0.0012030601501465
(444) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69918 and class = 'Cruise') OR (item_id = 715 AND class = 'Ship') OR (item_id = 12 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.0009911060333252
(445) DESCRIBE `cruiselines` 0.0020489692687988
(446) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 12))) 0.00031208992004395
(447) DESCRIBE `orchid_image` 0.0014259815216064
(448) DESCRIBE `cruiselines` 0.0018310546875
(449) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '12') 0.00028586387634277
(450) DESCRIBE `cruises` 0.002953052520752
(451) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70029') 0.00037813186645508
(452) DESCRIBE `ships` 0.0024399757385254
(453) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1415))) 0.0003659725189209
(454) DESCRIBE `ships` 0.0024569034576416
(455) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1415') 0.00031399726867676
(456) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00026798248291016
(457) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00026798248291016
(458) DESCRIBE `itineraries` 0.0012919902801514
(459) DESCRIBE `ports` 0.0013370513916016
(460) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00032782554626465
(461) DESCRIBE `ports` 0.0013248920440674
(462) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00031399726867676
(463) DESCRIBE `ports` 0.001244068145752
(464) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00029492378234863
(465) DESCRIBE `sailingdates` 0.0012547969818115
(466) DESCRIBE `ports` 0.002173900604248
(467) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00047516822814941
(468) DESCRIBE `ports` 0.0016651153564453
(469) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00030612945556641
(470) DESCRIBE `ports` 0.00124192237854
(471) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 414))) 0.00051999092102051
(472) DESCRIBE `ports` 0.0013449192047119
(473) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '414') 0.00030303001403809
(474) DESCRIBE `ports` 0.0014579296112061
(475) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00032496452331543
(476) DESCRIBE `ports` 0.0012450218200684
(477) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.0002739429473877
(478) DESCRIBE `ports` 0.001317024230957
(479) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00033283233642578
(480) DESCRIBE `ports` 0.0012428760528564
(481) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00027704238891602
(482) DESCRIBE `ports` 0.0018539428710938
(483) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00031614303588867
(484) DESCRIBE `ports` 0.0013420581817627
(485) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00027704238891602
(486) DESCRIBE `ports` 0.0012340545654297
(487) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00030303001403809
(488) DESCRIBE `ports` 0.0012869834899902
(489) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00028300285339355
(490) DESCRIBE `avid_specials` 0.0011141300201416
(491) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70029 and class = 'Cruise') OR (item_id = 1415 AND class = 'Ship') OR (item_id = 19 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.0011429786682129
(492) DESCRIBE `cruiselines` 0.0018141269683838
(493) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00042986869812012
(494) DESCRIBE `orchid_image` 0.0014328956604004
(495) DESCRIBE `cruiselines` 0.0018270015716553
(496) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00030112266540527
(497) DESCRIBE `cruises` 0.0024580955505371
(498) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70410') 0.0003659725189209
(499) DESCRIBE `ships` 0.0025730133056641
(500) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1272))) 0.00033688545227051
(501) DESCRIBE `ships` 0.0027070045471191
(502) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1272') 0.00027203559875488
(503) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029206275939941
(504) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026822090148926
(505) DESCRIBE `itineraries` 0.0013961791992188
(506) DESCRIBE `ports` 0.001366138458252
(507) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 864))) 0.00031900405883789
(508) DESCRIBE `ports` 0.0014388561248779
(509) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 864))) 0.00031590461730957
(510) DESCRIBE `ports` 0.0013430118560791
(511) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '864') 0.00036382675170898
(512) DESCRIBE `sailingdates` 0.0012779235839844
(513) DESCRIBE `ports` 0.0017149448394775
(514) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 864))) 0.00036811828613281
(515) DESCRIBE `ports` 0.0014441013336182
(516) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '864') 0.00031685829162598
(517) DESCRIBE `ports` 0.0013260841369629
(518) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00036501884460449
(519) DESCRIBE `ports` 0.00160813331604
(520) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00036287307739258
(521) DESCRIBE `ports` 0.0014231204986572
(522) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00033187866210938
(523) DESCRIBE `ports` 0.0014829635620117
(524) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00034308433532715
(525) DESCRIBE `ports` 0.0015220642089844
(526) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.00044083595275879
(527) DESCRIBE `ports` 0.0017330646514893
(528) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.0003349781036377
(529) DESCRIBE `ports` 0.0014238357543945
(530) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00037503242492676
(531) DESCRIBE `ports` 0.0014240741729736
(532) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00031089782714844
(533) DESCRIBE `ports` 0.0018010139465332
(534) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00041913986206055
(535) DESCRIBE `ports` 0.0017189979553223
(536) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00039505958557129
(537) DESCRIBE `ports` 0.0018298625946045
(538) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 864))) 0.00042200088500977
(539) DESCRIBE `ports` 0.0016810894012451
(540) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '864') 0.00038719177246094
(541) DESCRIBE `avid_specials` 0.0014960765838623
(542) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70410 and class = 'Cruise') OR (item_id = 1272 AND class = 'Ship') OR (item_id = 12 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.0018680095672607
(543) DESCRIBE `cruiselines` 0.0025107860565186
(544) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 12))) 0.00049400329589844
(545) DESCRIBE `orchid_image` 0.0018820762634277
(546) DESCRIBE `cruiselines` 0.0024199485778809
(547) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '12') 0.00042200088500977
(548) DESCRIBE `cruiselines` 0.0027461051940918
(549) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '19', '77', '26', '7', '12', '23', '171', '20', '18', '144', '31', '101', '8', '131', '96', '239', '29', '15', '191', '120', '183', '103', '50', '206', '91', '16', '262', '221', '33', '24', '28', '114', '110', '268', '156', '37', '208', '141', '14', '187', '153', '118', '49', '151', '211', '30', '258', '216', '181', '88', '212', '4', '36', '232', '225', '238', '140', '184', '249', '159', '113', '90', '47', '230', '182', '136', '213', '256', '261', '35', '237', '188', '174', '57', '180', '64', '264', '73', '248', '146', '195', '95', '52', '115', '204', '209', '59', '168', '196', '219', '231', '116', '82', '229', '119', '170', '244', '134', '105', '240', '276', '48', '108', '275', '132', '224', '210', '269')) ORDER BY FIND_IN_SET(id, '218,19,77,26,7,12,23,171,20,18,144,31,101,8,131,96,239,29,15,191,120,183,103,50,206,91,16,262,221,33,24,28,114,110,268,156,37,208,141,14,187,153,118,49,151,211,30,258,216,181,88,212,4,36,232,225,238,140,184,249,159,113,90,47,230,182,136,213,256,261,35,237,188,174,57,180,64,264,73,248,146,195,95,52,115,204,209,59,168,196,219,231,116,82,229,119,170,244,134,105,240,276,48,108,275,132,224,210,269') 0.007500171661377
(550) DESCRIBE `ships` 0.0037569999694824
(551) SELECT `ships`.* FROM `ships` WHERE (id IN ('1127', '1032', '1292', '1205', '1199', '258', '1291', '977', '1359', '454', '1599', '1272', '855', '986', '1237', '404', '1594', '780', '1677', '1067', '1588', '837', '37', '38', '34', '22', '27', '378', '461', '21', '28', '407', '31', '393', '1607', '817', '1135', '1247', '1554', '1555', '1012', '30', '36', '349', '39', '1424', '726', '35', '1422', '462', '1415', '792', '1423', '585', '882', '1245', '1419', '1420', '1421', '1176', '1418', '1215', '1574', '113', '330', '1405', '24', '711', '11', '439', '1744', '9', '10', '265', '766', '455', '452', '542', '1141', '1193', '78', '739', '81', '635', '1572', '69', '124', '674', '3', '1095', '1454', '770', '1008', '1372', '5', '850', '874', '338', '116', '340', '573', '1168', '580', '1471', '1021', '1569', '553', '1284', '43', '70', '1302', '25', '66', '160', '253', '285', '332', '405', '716', '1402', '148', '451', '658', '944', '1678', '111', '390', '1562', '4', '748', '1172', '386', '520', '797', '966', '1259', '1260', '1460', '385', '626', '791', '1320', '1323', '406', '1455', '974', '1088', '1108', '1325', '286', '314', '678', '351', '590', '768', '582', '970', '1195', '1373', '1575', '63', '119', '327', '434', '508', '526', '108', '335', '375', '616', '993', '1587', '559', '854', '207', '84', '394', '401', '722', '1208', '1266', '517', '1398', '1492', '1571', '657', '775', '1068', '1268', '150', '421', '1236', '1586', '485', '1308', '1672', '114', '403', '704', '1742', '147', '152', '547', '784', '883', '105', '151', '1064', '1289', '1319', '223', '325', '652', '683', '958', '1269', '1724', '123', '149', '262', '348', '715', '1321', '1270', '75', '163', '389', '483', '1243', '1389', '1143', '1159', '1282', '1561', '1330', '1437', '1557', '14', '441', '1013', '1526', '1579', '1711', '287', '717', '1139', '1151', '1214', '1326', '1327', '1348', '162', '333', '545', '790', '796', '1367', '1722', '290', '732', '823', '1216', '1301', '1539', '1717', '93', '651', '1738', '291', '884', '968', '1075', '1318', '201', '673', '1540', '1602', '82', '98', '212', '769', '818', '1063', '1137', '1144', '1303', '1344', '45', '516', '743', '852', '1040', '1160', '1343', '1704', '751', '776', '1163', '1217', '1452', '1453', '1604', '701', '1043', '1218', '1283', '1409', '1426', '1566', '1682', '266', '324', '341', '521', '811', '885', '988', '1025', '1027', '1090', '1136', '1157', '1241', '1449', '448', '669', '1253', '1413', '1552', '1632', '1676', '1740', '467', '574', '738', '795', '1019', '1073', '1223', '1358', '1411', '639', '905', '1152', '1226', '1233', '1345', '1376', '1448', '1474', '601', '888', '1150', '1721', '494', '1029', '1145', '1647', '74', '417', '997', '1055', '1229', '1322', '1408', '1458', '1716', '1026', '1188', '1580', '618', '709', '836', '1149', '1231', '1351', '1410', '1463', '1489', '1496', '1505', '1619', '1663', '205', '208', '666', '954', '973', '1034', '1047', '1222', '1366', '1713', '1715', '204', '352', '423', '493', '610', '996', '1049', '1230', '1714', '643', '851', '1154', '1262', '1362', '1368', '1407', '1444', '1516', '1609', '1673', '1743', '663', '920', '927', '1017', '1404', '1567', '1606', '499', '703', '921', '931', '1004', '1020', '1037', '1187', '1196', '1285', '1354', '1360', '1361', '1459', '1470', '1508', '1627', '731', '859', '914', '923', '1042', '1175', '1518', '503', '915', '916', '926', '930', '1003', '1045', '1072', '1106', '1138', '1486', '1517', '1521', '422', '479', '781', '924', '972', '1092', '1254', '1352', '1412', '1522', '1596', '1708', '1751', '17', '671', '1001', '1091', '1240', '1593', '1723', '453', '656', '665', '938', '1005', '1051', '1054', '1148', '1445', '1514', '1729', '420', '672', '937', '1684', '1002', '1052', '1601', '1679', '1681', '1697')) ORDER BY FIND_IN_SET(id, '1127,1032,1292,1205,1199,258,1291,977,1359,454,1599,1272,855,986,1237,404,1594,780,1677,1067,1588,837,37,38,34,22,27,378,461,21,28,407,31,393,1607,817,1135,1247,1554,1555,1012,30,36,349,39,1424,726,35,1422,462,1415,792,1423,585,882,1245,1419,1420,1421,1176,1418,1215,1574,113,330,1405,24,711,11,439,1744,9,10,265,766,455,452,542,1141,1193,78,739,81,635,1572,69,124,674,3,1095,1454,770,1008,1372,5,850,874,338,116,340,573,1168,580,1471,1021,1569,553,1284,43,70,1302,25,66,160,253,285,332,405,716,1402,148,451,658,944,1678,111,390,1562,4,748,1172,386,520,797,966,1259,1260,1460,385,626,791,1320,1323,406,1455,974,1088,1108,1325,286,314,678,351,590,768,582,970,1195,1373,1575,63,119,327,434,508,526,108,335,375,616,993,1587,559,854,207,84,394,401,722,1208,1266,517,1398,1492,1571,657,775,1068,1268,150,421,1236,1586,485,1308,1672,114,403,704,1742,147,152,547,784,883,105,151,1064,1289,1319,223,325,652,683,958,1269,1724,123,149,262,348,715,1321,1270,75,163,389,483,1243,1389,1143,1159,1282,1561,1330,1437,1557,14,441,1013,1526,1579,1711,287,717,1139,1151,1214,1326,1327,1348,162,333,545,790,796,1367,1722,290,732,823,1216,1301,1539,1717,93,651,1738,291,884,968,1075,1318,201,673,1540,1602,82,98,212,769,818,1063,1137,1144,1303,1344,45,516,743,852,1040,1160,1343,1704,751,776,1163,1217,1452,1453,1604,701,1043,1218,1283,1409,1426,1566,1682,266,324,341,521,811,885,988,1025,1027,1090,1136,1157,1241,1449,448,669,1253,1413,1552,1632,1676,1740,467,574,738,795,1019,1073,1223,1358,1411,639,905,1152,1226,1233,1345,1376,1448,1474,601,888,1150,1721,494,1029,1145,1647,74,417,997,1055,1229,1322,1408,1458,1716,1026,1188,1580,618,709,836,1149,1231,1351,1410,1463,1489,1496,1505,1619,1663,205,208,666,954,973,1034,1047,1222,1366,1713,1715,204,352,423,493,610,996,1049,1230,1714,643,851,1154,1262,1362,1368,1407,1444,1516,1609,1673,1743,663,920,927,1017,1404,1567,1606,499,703,921,931,1004,1020,1037,1187,1196,1285,1354,1360,1361,1459,1470,1508,1627,731,859,914,923,1042,1175,1518,503,915,916,926,930,1003,1045,1072,1106,1138,1486,1517,1521,422,479,781,924,972,1092,1254,1352,1412,1522,1596,1708,1751,17,671,1001,1091,1240,1593,1723,453,656,665,938,1005,1051,1054,1148,1445,1514,1729,420,672,937,1684,1002,1052,1601,1679,1681,1697') 0.056595087051392
(552) DESCRIBE `cruisetypes` 0.0014519691467285
(553) DESCRIBE `destinations` 0.0016980171203613
(554) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '22', '54', '35', '25', '37', '9', '43', '2', '8', '53', '55', '39', '38', '28', '7', '40', '26', '30', '48', '11', '21', '29', '45', '49', '56', '44', '10', '34', '52', '46', '32')) ORDER BY FIND_IN_SET(id, '50,12,22,54,35,25,37,9,43,2,8,53,55,39,38,28,7,40,26,30,48,11,21,29,45,49,56,44,10,34,52,46,32') 0.0019550323486328