or, enquire about your chosen options

  1. Ovation of the Seas coming to Australia & New Zealand
  2. Heritage Expeditions: Secrets of Melanesia Cruise
  3. Vietnam Cruise a ‘must do’
  4. Explorer of the Seas to visit New Zealand
  5. Panama Canal – Norwegian Star

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

Total elapsed time: 0.45697093009949

# Query Time
(1) connect 0.00071883201599121
(2) DESCRIBE `cruises` 0.0021719932556152
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (40901, 48870, 41033, 40890, 63189, 41032, 60283, 66883, 40897, 41319)) ORDER BY FIND_IN_SET(id, '40901,48870,41033,40890,63189,41032,60283,66883,40897,41319') 0.0012838840484619
(4) DESCRIBE `specials` 0.0022637844085693
(5) DESCRIBE `specials` 0.0018641948699951
(6) DESCRIBE `specials` 0.0019161701202393
(7) DESCRIBE `cruises` 0.0014491081237793
(8) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '40901') 0.00029206275939941
(9) DESCRIBE `specials` 0.0020289421081543
(10) DESCRIBE `ships` 0.0015201568603516
(11) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1051))) 0.00030088424682617
(12) DESCRIBE `ships` 0.0016279220581055
(13) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1051') 0.00023007392883301
(14) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017499923706055
(15) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00020599365234375
(16) DESCRIBE `itineraries` 0.00078797340393066
(17) DESCRIBE `ports` 0.00088906288146973
(18) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00026106834411621
(19) DESCRIBE `ports` 0.00078105926513672
(20) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00023913383483887
(21) DESCRIBE `ports` 0.000762939453125
(22) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00021219253540039
(23) DESCRIBE `specials` 0.0022051334381104
(24) DESCRIBE `sailingdates` 0.00083494186401367
(25) DESCRIBE `ports` 0.00090694427490234
(26) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00026679039001465
(27) DESCRIBE `ports` 0.00071287155151367
(28) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00019216537475586
(29) DESCRIBE `ports` 0.00070905685424805
(30) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1508))) 0.00022196769714355
(31) DESCRIBE `ports` 0.00068211555480957
(32) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1508') 0.00018405914306641
(33) DESCRIBE `ports` 0.00068402290344238
(34) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1510))) 0.00022506713867188
(35) DESCRIBE `ports` 0.00072002410888672
(36) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1510') 0.00018501281738281
(37) DESCRIBE `ports` 0.00066804885864258
(38) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1508))) 0.00020003318786621
(39) DESCRIBE `ports` 0.00067400932312012
(40) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1508') 0.00018215179443359
(41) DESCRIBE `ports` 0.00069594383239746
(42) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1552))) 0.00021815299987793
(43) DESCRIBE `ports` 0.00067591667175293
(44) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1552') 0.00018000602722168
(45) DESCRIBE `ports` 0.0006861686706543
(46) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3212))) 0.00019598007202148
(47) DESCRIBE `ports` 0.00066900253295898
(48) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3212') 0.00017690658569336
(49) DESCRIBE `ports` 0.00066208839416504
(50) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.0001990795135498
(51) DESCRIBE `ports` 0.00070714950561523
(52) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00020003318786621
(53) DESCRIBE `specials` 0.0018739700317383
(54) DESCRIBE `specials` 0.0023319721221924
(55) DESCRIBE `avid_specials` 0.00074386596679688
(56) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 40901 and class = 'Cruise') OR (item_id = 1051 AND class = 'Ship') OR (item_id = 144 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.00092315673828125
(57) DESCRIBE `cruiselines` 0.0010080337524414
(58) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00026512145996094
(59) DESCRIBE `orchid_image` 0.00076079368591309
(60) DESCRIBE `cruiselines` 0.0010221004486084
(61) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00021791458129883
(62) DESCRIBE `specials` 0.0019690990447998
(63) DESCRIBE `specials` 0.001835823059082
(64) DESCRIBE `specials` 0.0025830268859863
(65) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1222235') 0.00034594535827637
(66) DESCRIBE `ships` 0.0016880035400391
(67) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1232))) 0.00036406517028809
(68) DESCRIBE `ships` 0.0022680759429932
(69) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1232') 0.00025796890258789
(70) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00019192695617676
(71) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016593933105469
(72) DESCRIBE `itineraries` 0.0008089542388916
(73) DESCRIBE `ports` 0.00073003768920898
(74) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2507))) 0.00023102760314941
(75) DESCRIBE `ports` 0.00068783760070801
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2507))) 0.00020503997802734
(77) DESCRIBE `ports` 0.00069189071655273
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2507') 0.00019502639770508
(79) DESCRIBE `specialsailingdates` 0.00063300132751465
(80) DESCRIBE `sailingdates` 0.0006411075592041
(81) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396377))) 0.00025415420532227
(82) DESCRIBE `sailingdates` 0.00064301490783691
(83) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396378))) 0.00020003318786621
(84) DESCRIBE `sailingdates` 0.00060701370239258
(85) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396379))) 0.00019311904907227
(86) DESCRIBE `ports` 0.00070500373840332
(87) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2507))) 0.00021195411682129
(88) DESCRIBE `ports` 0.00091099739074707
(89) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2507') 0.00020885467529297
(90) DESCRIBE `ports` 0.00084805488586426
(91) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2410))) 0.00020098686218262
(92) DESCRIBE `ports` 0.00068116188049316
(93) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2410') 0.00018000602722168
(94) DESCRIBE `ports` 0.00072383880615234
(95) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2507))) 0.00026082992553711
(96) DESCRIBE `ports` 0.00068497657775879
(97) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2507') 0.00018405914306641
(98) DESCRIBE `ports` 0.00075602531433105
(99) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4484))) 0.00020408630371094
(100) DESCRIBE `ports` 0.0006859302520752
(101) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4484') 0.00024104118347168
(102) DESCRIBE `ports` 0.001021146774292
(103) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5091))) 0.00028514862060547
(104) DESCRIBE `ports` 0.0010309219360352
(105) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5091') 0.00027894973754883
(106) DESCRIBE `ports` 0.0010819435119629
(107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4485))) 0.00029897689819336
(108) DESCRIBE `ports` 0.0010030269622803
(109) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4485') 0.00027894973754883
(110) DESCRIBE `ports` 0.00096702575683594
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5091))) 0.0002751350402832
(112) DESCRIBE `ports` 0.00098490715026855
(113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5091') 0.00025415420532227
(114) DESCRIBE `ports` 0.0010130405426025
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4484))) 0.00027585029602051
(116) DESCRIBE `ports` 0.0010159015655518
(117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4484') 0.00024890899658203
(118) DESCRIBE `ports` 0.0010168552398682
(119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2507))) 0.00029683113098145
(120) DESCRIBE `ports` 0.0010490417480469
(121) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2507') 0.00025200843811035
(122) DESCRIBE `ports` 0.00097918510437012
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2507))) 0.00026392936706543
(124) DESCRIBE `ports` 0.00097918510437012
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2507') 0.00024294853210449
(126) DESCRIBE `cruises` 0.0020840167999268
(127) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 48870))) 0.00041604042053223
(128) DESCRIBE `avid_specials` 0.0010068416595459
(129) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1222235 and class = 'Special') OR (item_id = 48870 and class = 'Cruise') OR (item_id = 1232 AND class = 'Ship') OR (item_id = 144 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.0017600059509277
(130) DESCRIBE `cruiselines` 0.0016469955444336
(131) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00038003921508789
(132) DESCRIBE `orchid_image` 0.0012831687927246
(133) DESCRIBE `cruiselines` 0.0016539096832275
(134) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00031900405883789
(135) DESCRIBE `specials` 0.0030419826507568
(136) DESCRIBE `specials` 0.0031368732452393
(137) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1230256') 0.00039315223693848
(138) DESCRIBE `ships` 0.0023329257965088
(139) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1035))) 0.00041389465332031
(140) DESCRIBE `ships` 0.0023181438446045
(141) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1035') 0.00027108192443848
(142) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00023198127746582
(143) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00023508071899414
(144) DESCRIBE `itineraries` 0.00097894668579102
(145) DESCRIBE `ports` 0.0010411739349365
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00030899047851562
(147) DESCRIBE `ports` 0.00093507766723633
(148) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.0002601146697998
(149) DESCRIBE `ports` 0.0008699893951416
(150) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00022506713867188
(151) DESCRIBE `specialsailingdates` 0.00074505805969238
(152) DESCRIBE `sailingdates` 0.0007789134979248
(153) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 395985))) 0.0002751350402832
(154) DESCRIBE `sailingdates` 0.00077605247497559
(155) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 395986))) 0.00022602081298828
(156) DESCRIBE `sailingdates` 0.00077104568481445
(157) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 395988))) 0.00022411346435547
(158) DESCRIBE `sailingdates` 0.0008699893951416
(159) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 395989))) 0.00024509429931641
(160) DESCRIBE `ports` 0.0010128021240234
(161) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.0002901554107666
(162) DESCRIBE `ports` 0.0009911060333252
(163) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00024604797363281
(164) DESCRIBE `ports` 0.00098490715026855
(165) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1576))) 0.00026798248291016
(166) DESCRIBE `ports` 0.0010178089141846
(167) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1576') 0.00023889541625977
(168) DESCRIBE `ports` 0.001025915145874
(169) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 936))) 0.0002751350402832
(170) DESCRIBE `ports` 0.0010268688201904
(171) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '936') 0.00024700164794922
(172) DESCRIBE `ports` 0.00099611282348633
(173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 940))) 0.00026702880859375
(174) DESCRIBE `ports` 0.0010168552398682
(175) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '940') 0.00023889541625977
(176) DESCRIBE `ports` 0.00098800659179688
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00026297569274902
(178) DESCRIBE `ports` 0.00097513198852539
(179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00023794174194336
(180) DESCRIBE `ports` 0.00098180770874023
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00027894973754883
(182) DESCRIBE `ports` 0.00097012519836426
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00024294853210449
(184) DESCRIBE `ports` 0.00099992752075195
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1578))) 0.00026488304138184
(186) DESCRIBE `ports` 0.00099492073059082
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1578') 0.00024294853210449
(188) DESCRIBE `ports` 0.0010049343109131
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00027203559875488
(190) DESCRIBE `ports` 0.0009310245513916
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00023698806762695
(192) DESCRIBE `ports` 0.00094819068908691
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00026893615722656
(194) DESCRIBE `ports` 0.00096702575683594
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00024700164794922
(196) DESCRIBE `cruises` 0.0019571781158447
(197) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 41033))) 0.00039887428283691
(198) DESCRIBE `avid_specials` 0.00086092948913574
(199) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1230256 and class = 'Special') OR (item_id = 41033 and class = 'Cruise') OR (item_id = 1035 AND class = 'Ship') OR (item_id = 144 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.0016429424285889
(200) DESCRIBE `cruiselines` 0.0014469623565674
(201) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00031518936157227
(202) DESCRIBE `orchid_image` 0.00078201293945312
(203) DESCRIBE `cruiselines` 0.0014939308166504
(204) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00052595138549805
(205) DESCRIBE `specials` 0.0034339427947998
(206) DESCRIBE `specials` 0.001945972442627
(207) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1233384') 0.00029897689819336
(208) DESCRIBE `ships` 0.0015048980712891
(209) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1052))) 0.00026988983154297
(210) DESCRIBE `ships` 0.0012829303741455
(211) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1052') 0.00020098686218262
(212) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00018501281738281
(213) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017094612121582
(214) DESCRIBE `itineraries` 0.00068497657775879
(215) DESCRIBE `ports` 0.00073099136352539
(216) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1581))) 0.00022196769714355
(217) DESCRIBE `ports` 0.00067901611328125
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1581))) 0.00020194053649902
(219) DESCRIBE `ports` 0.00069808959960938
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1581') 0.00025486946105957
(221) DESCRIBE `specialsailingdates` 0.0006251335144043
(222) DESCRIBE `sailingdates` 0.00061893463134766
(223) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 395914))) 0.00023102760314941
(224) DESCRIBE `ports` 0.00069379806518555
(225) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1581))) 0.00020694732666016
(226) DESCRIBE `ports` 0.0006871223449707
(227) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1581') 0.00019407272338867
(228) DESCRIBE `ports` 0.00068092346191406
(229) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1576))) 0.00020503997802734
(230) DESCRIBE `ports` 0.00067710876464844
(231) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1576') 0.00018501281738281
(232) DESCRIBE `ports` 0.00067996978759766
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00021910667419434
(234) DESCRIBE `ports` 0.00071096420288086
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00018501281738281
(236) DESCRIBE `ports` 0.00067877769470215
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 936))) 0.00020098686218262
(238) DESCRIBE `ports` 0.00067687034606934
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '936') 0.0001828670501709
(240) DESCRIBE `ports` 0.00069189071655273
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00020599365234375
(242) DESCRIBE `ports` 0.00067901611328125
(243) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00018310546875
(244) DESCRIBE `ports` 0.00067305564880371
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00020694732666016
(246) DESCRIBE `ports` 0.00067591667175293
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00018596649169922
(248) DESCRIBE `ports` 0.00067591667175293
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 941))) 0.00020003318786621
(250) DESCRIBE `ports` 0.00067496299743652
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '941') 0.00022983551025391
(252) DESCRIBE `ports` 0.00069022178649902
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2618))) 0.00020098686218262
(254) DESCRIBE `ports` 0.00067496299743652
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2618') 0.00018191337585449
(256) DESCRIBE `ports` 0.00066709518432617
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2564))) 0.00020384788513184
(258) DESCRIBE `ports` 0.00067996978759766
(259) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2564') 0.00018715858459473
(260) DESCRIBE `ports` 0.00067400932312012
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2096))) 0.00022196769714355
(262) DESCRIBE `ports` 0.00071597099304199
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2096') 0.00018310546875
(264) DESCRIBE `ports` 0.00067591667175293
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2097))) 0.00020003318786621
(266) DESCRIBE `ports` 0.00067901611328125
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2097') 0.0001828670501709
(268) DESCRIBE `ports` 0.00069117546081543
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2935))) 0.00020408630371094
(270) DESCRIBE `ports` 0.00067996978759766
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2935') 0.0001828670501709
(272) DESCRIBE `ports` 0.00066590309143066
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2935))) 0.00020503997802734
(274) DESCRIBE `ports` 0.0006721019744873
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2935') 0.00018692016601562
(276) DESCRIBE `ports` 0.0006859302520752
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2617))) 0.00020480155944824
(278) DESCRIBE `ports` 0.00067687034606934
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2617') 0.00018692016601562
(280) DESCRIBE `ports` 0.000762939453125
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 945))) 0.00031399726867676
(282) DESCRIBE `ports` 0.00073099136352539
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '945') 0.00018596649169922
(284) DESCRIBE `ports` 0.0007779598236084
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2967))) 0.00020718574523926
(286) DESCRIBE `ports` 0.00068092346191406
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2967') 0.00019478797912598
(288) DESCRIBE `ports` 0.00067806243896484
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2967))) 0.0001981258392334
(290) DESCRIBE `ports` 0.00068211555480957
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2967') 0.00018095970153809
(292) DESCRIBE `cruises` 0.0013148784637451
(293) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 40890))) 0.00028109550476074
(294) DESCRIBE `avid_specials` 0.00060510635375977
(295) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1233384 and class = 'Special') OR (item_id = 40890 and class = 'Cruise') OR (item_id = 1052 AND class = 'Ship') OR (item_id = 144 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.0008540153503418
(296) DESCRIBE `cruiselines` 0.00095796585083008
(297) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00024604797363281
(298) DESCRIBE `orchid_image` 0.00075507164001465
(299) DESCRIBE `cruiselines` 0.00094389915466309
(300) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.0001981258392334
(301) DESCRIBE `specials` 0.0018661022186279
(302) DESCRIBE `specials` 0.0018069744110107
(303) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1230412') 0.00025486946105957
(304) DESCRIBE `ships` 0.0015780925750732
(305) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1483))) 0.00031089782714844
(306) DESCRIBE `ships` 0.0013761520385742
(307) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1483') 0.00021505355834961
(308) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017499923706055
(309) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017404556274414
(310) DESCRIBE `itineraries` 0.00068497657775879
(311) DESCRIBE `ports` 0.00070595741271973
(312) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.000244140625
(313) DESCRIBE `ports` 0.00067400932312012
(314) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.0001981258392334
(315) DESCRIBE `ports` 0.00068402290344238
(316) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00017786026000977
(317) DESCRIBE `specialsailingdates` 0.00056290626525879
(318) DESCRIBE `sailingdates` 0.0006251335144043
(319) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396811))) 0.00034904479980469
(320) DESCRIBE `sailingdates` 0.00061297416687012
(321) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396812))) 0.00019717216491699
(322) DESCRIBE `sailingdates` 0.00061178207397461
(323) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396813))) 0.00019598007202148
(324) DESCRIBE `sailingdates` 0.00061392784118652
(325) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396814))) 0.00021195411682129
(326) DESCRIBE `sailingdates` 0.00060606002807617
(327) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396815))) 0.00018882751464844
(328) DESCRIBE `sailingdates` 0.00061392784118652
(329) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396816))) 0.00019717216491699
(330) DESCRIBE `sailingdates` 0.00062704086303711
(331) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396817))) 0.00020909309387207
(332) DESCRIBE `ports` 0.0007331371307373
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00021815299987793
(334) DESCRIBE `ports` 0.00069713592529297
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00019502639770508
(336) DESCRIBE `ports` 0.00075888633728027
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00035905838012695
(338) DESCRIBE `ports` 0.00085997581481934
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00020408630371094
(340) DESCRIBE `ports` 0.00070500373840332
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2691))) 0.0002140998840332
(342) DESCRIBE `ports` 0.00070810317993164
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2691') 0.00019621849060059
(344) DESCRIBE `ports` 0.00068902969360352
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3208))) 0.00021505355834961
(346) DESCRIBE `ports` 0.00071406364440918
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3208') 0.00019288063049316
(348) DESCRIBE `ports` 0.00069093704223633
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2937))) 0.0002140998840332
(350) DESCRIBE `ports` 0.00068998336791992
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2937') 0.00024509429931641
(352) DESCRIBE `ports` 0.00087189674377441
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3207))) 0.00020694732666016
(354) DESCRIBE `ports` 0.00070691108703613
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3207') 0.00019598007202148
(356) DESCRIBE `ports` 0.00072193145751953
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2692))) 0.00021100044250488
(358) DESCRIBE `ports` 0.00073480606079102
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2692') 0.00018692016601562
(360) DESCRIBE `ports` 0.00068998336791992
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2692))) 0.00020217895507812
(362) DESCRIBE `ports` 0.00069904327392578
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2692') 0.00018095970153809
(364) DESCRIBE `ports` 0.00069499015808105
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00020694732666016
(366) DESCRIBE `ports` 0.00069904327392578
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00018191337585449
(368) DESCRIBE `cruises` 0.0013141632080078
(369) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 63189))) 0.0003199577331543
(370) DESCRIBE `avid_specials` 0.00063180923461914
(371) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1230412 and class = 'Special') OR (item_id = 63189 and class = 'Cruise') OR (item_id = 1483 AND class = 'Ship') OR (item_id = 144 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.00086188316345215
(372) DESCRIBE `cruiselines` 0.0010061264038086
(373) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00022697448730469
(374) DESCRIBE `orchid_image` 0.00094199180603027
(375) DESCRIBE `cruiselines` 0.0010218620300293
(376) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00022697448730469
(377) DESCRIBE `specials` 0.0020649433135986
(378) DESCRIBE `specials` 0.0023388862609863
(379) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1226002') 0.00037002563476562
(380) DESCRIBE `ships` 0.001622200012207
(381) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1063))) 0.0003049373626709
(382) DESCRIBE `ships` 0.0013680458068848
(383) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1063') 0.00020003318786621
(384) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017499923706055
(385) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00018501281738281
(386) DESCRIBE `itineraries` 0.00083303451538086
(387) DESCRIBE `ports` 0.0007939338684082
(388) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00025010108947754
(389) DESCRIBE `ports` 0.00073909759521484
(390) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00023007392883301
(391) DESCRIBE `ports` 0.00072884559631348
(392) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00019598007202148
(393) DESCRIBE `specialsailingdates` 0.00057196617126465
(394) DESCRIBE `sailingdates` 0.00063180923461914
(395) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396062))) 0.00024509429931641
(396) DESCRIBE `sailingdates` 0.00073695182800293
(397) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396063))) 0.00039410591125488
(398) DESCRIBE `sailingdates` 0.00084185600280762
(399) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396064))) 0.00022697448730469
(400) DESCRIBE `sailingdates` 0.00067901611328125
(401) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396065))) 0.00018811225891113
(402) DESCRIBE `sailingdates` 0.00061798095703125
(403) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396066))) 0.00018811225891113
(404) DESCRIBE `sailingdates` 0.00061678886413574
(405) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396067))) 0.00019502639770508
(406) DESCRIBE `sailingdates` 0.00061988830566406
(407) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396068))) 0.00020599365234375
(408) DESCRIBE `sailingdates` 0.00073695182800293
(409) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396069))) 0.00026798248291016
(410) DESCRIBE `ports` 0.001093864440918
(411) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00023102760314941
(412) DESCRIBE `ports` 0.00070691108703613
(413) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00019502639770508
(414) DESCRIBE `ports` 0.00068807601928711
(415) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2682))) 0.0002140998840332
(416) DESCRIBE `ports` 0.00075483322143555
(417) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2682') 0.00018191337585449
(418) DESCRIBE `ports` 0.00069403648376465
(419) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3210))) 0.00020289421081543
(420) DESCRIBE `ports` 0.00072288513183594
(421) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3210') 0.00020885467529297
(422) DESCRIBE `ports` 0.00083303451538086
(423) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2306))) 0.00023603439331055
(424) DESCRIBE `ports` 0.00072193145751953
(425) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2306') 0.00020098686218262
(426) DESCRIBE `ports` 0.00083708763122559
(427) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2682))) 0.00026607513427734
(428) DESCRIBE `ports` 0.00084185600280762
(429) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2682') 0.00021791458129883
(430) DESCRIBE `ports` 0.00073885917663574
(431) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3209))) 0.0002140998840332
(432) DESCRIBE `ports` 0.00073504447937012
(433) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3209') 0.00019001960754395
(434) DESCRIBE `ports` 0.00085616111755371
(435) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00023794174194336
(436) DESCRIBE `ports` 0.00084590911865234
(437) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00020599365234375
(438) DESCRIBE `ports` 0.0010409355163574
(439) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00027084350585938
(440) DESCRIBE `ports` 0.00078797340393066
(441) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00021600723266602
(442) DESCRIBE `ports` 0.00068998336791992
(443) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00022697448730469
(444) DESCRIBE `ports` 0.0007939338684082
(445) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00033903121948242
(446) DESCRIBE `cruises` 0.0015199184417725
(447) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 41032))) 0.00033807754516602
(448) DESCRIBE `avid_specials` 0.00064706802368164
(449) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1226002 and class = 'Special') OR (item_id = 41032 and class = 'Cruise') OR (item_id = 1063 AND class = 'Ship') OR (item_id = 144 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.00087189674377441
(450) DESCRIBE `cruiselines` 0.0010039806365967
(451) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00023508071899414
(452) DESCRIBE `orchid_image` 0.0008089542388916
(453) DESCRIBE `cruiselines` 0.00096297264099121
(454) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00022602081298828
(455) DESCRIBE `specials` 0.0019359588623047
(456) DESCRIBE `specials` 0.0019519329071045
(457) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1319652') 0.00026988983154297
(458) DESCRIBE `ships` 0.0013740062713623
(459) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 973))) 0.00026798248291016
(460) DESCRIBE `ships` 0.0013718605041504
(461) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '973') 0.00019001960754395
(462) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00018596649169922
(463) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016498565673828
(464) DESCRIBE `itineraries` 0.00069093704223633
(465) DESCRIBE `ports` 0.00087904930114746
(466) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1543))) 0.00025391578674316
(467) DESCRIBE `ports` 0.00069618225097656
(468) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1543))) 0.00021719932556152
(469) DESCRIBE `ports` 0.00071883201599121
(470) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1543') 0.00020003318786621
(471) DESCRIBE `specialsailingdates` 0.00057697296142578
(472) DESCRIBE `sailingdates` 0.00064802169799805
(473) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 382051))) 0.0002439022064209
(474) DESCRIBE `ports` 0.00069713592529297
(475) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1543))) 0.00025200843811035
(476) DESCRIBE `ports` 0.00072789192199707
(477) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1543') 0.00022387504577637
(478) DESCRIBE `ports` 0.00068497657775879
(479) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1543))) 0.0002129077911377
(480) DESCRIBE `ports` 0.00069904327392578
(481) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1543') 0.0001828670501709
(482) DESCRIBE `ports` 0.00068402290344238
(483) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00020718574523926
(484) DESCRIBE `ports` 0.00068497657775879
(485) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.00018405914306641
(486) DESCRIBE `ports` 0.0006859302520752
(487) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1570))) 0.00020599365234375
(488) DESCRIBE `ports` 0.00084686279296875
(489) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1570') 0.0001981258392334
(490) DESCRIBE `ports` 0.00075101852416992
(491) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1600))) 0.00022006034851074
(492) DESCRIBE `ports` 0.00069713592529297
(493) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1600') 0.00018906593322754
(494) DESCRIBE `ports` 0.0006871223449707
(495) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00020694732666016
(496) DESCRIBE `ports` 0.00068402290344238
(497) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00018310546875
(498) DESCRIBE `ports` 0.00071382522583008
(499) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1564))) 0.00020813941955566
(500) DESCRIBE `ports` 0.00069499015808105
(501) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1564') 0.00018882751464844
(502) DESCRIBE `ports` 0.00072407722473145
(503) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1596))) 0.00028800964355469
(504) DESCRIBE `ports` 0.0010879039764404
(505) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1596') 0.00044488906860352
(506) DESCRIBE `ports` 0.0010719299316406
(507) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1595))) 0.00029301643371582
(508) DESCRIBE `ports` 0.00099992752075195
(509) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1595') 0.00019216537475586
(510) DESCRIBE `ports` 0.00084590911865234
(511) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2964))) 0.00023007392883301
(512) DESCRIBE `ports` 0.00070714950561523
(513) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2964') 0.00018906593322754
(514) DESCRIBE `ports` 0.00072813034057617
(515) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00021004676818848
(516) DESCRIBE `ports` 0.00069808959960938
(517) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00018906593322754
(518) DESCRIBE `ports` 0.0006868839263916
(519) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00020909309387207
(520) DESCRIBE `ports` 0.00070905685424805
(521) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00019478797912598
(522) DESCRIBE `ports` 0.00069689750671387
(523) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00020694732666016
(524) DESCRIBE `ports` 0.00069594383239746
(525) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00018310546875
(526) DESCRIBE `cruises` 0.0013368129730225
(527) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 60283))) 0.0003199577331543
(528) DESCRIBE `avid_specials` 0.0006558895111084
(529) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1319652 and class = 'Special') OR (item_id = 60283 and class = 'Cruise') OR (item_id = 973 AND class = 'Ship') OR (item_id = 101 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.00092291831970215
(530) DESCRIBE `cruiselines` 0.00099992752075195
(531) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 101))) 0.00023889541625977
(532) DESCRIBE `orchid_image` 0.00079202651977539
(533) DESCRIBE `cruiselines` 0.00098109245300293
(534) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '101') 0.00019717216491699
(535) DESCRIBE `specials` 0.0019659996032715
(536) DESCRIBE `specials` 0.0021011829376221
(537) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1294179') 0.0002751350402832
(538) DESCRIBE `ships` 0.0014350414276123
(539) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 644))) 0.0002739429473877
(540) DESCRIBE `ships` 0.0013771057128906
(541) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '644') 0.00020599365234375
(542) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017595291137695
(543) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016307830810547
(544) DESCRIBE `itineraries` 0.00071001052856445
(545) DESCRIBE `ports` 0.0007328987121582
(546) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 193))) 0.00023007392883301
(547) DESCRIBE `ports` 0.00069403648376465
(548) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 193))) 0.00019383430480957
(549) DESCRIBE `ports` 0.00068497657775879
(550) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '193') 0.00021195411682129
(551) DESCRIBE `specialsailingdates` 0.00060200691223145
(552) DESCRIBE `sailingdates` 0.00067806243896484
(553) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 419764))) 0.00026082992553711
(554) DESCRIBE `sailingdates` 0.0006251335144043
(555) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 419765))) 0.0001990795135498
(556) DESCRIBE `sailingdates` 0.00061917304992676
(557) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 419766))) 0.00019598007202148
(558) DESCRIBE `sailingdates` 0.0006108283996582
(559) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 419767))) 0.00022006034851074
(560) DESCRIBE `sailingdates` 0.0006721019744873
(561) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 419768))) 0.00020003318786621
(562) DESCRIBE `sailingdates` 0.0006258487701416
(563) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 419769))) 0.00020003318786621
(564) DESCRIBE `sailingdates` 0.00065898895263672
(565) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 419770))) 0.00020098686218262
(566) DESCRIBE `sailingdates` 0.00063800811767578
(567) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 419771))) 0.0003058910369873
(568) DESCRIBE `sailingdates` 0.00066685676574707
(569) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 419772))) 0.00022006034851074
(570) DESCRIBE `sailingdates` 0.00071406364440918
(571) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 419773))) 0.00042414665222168
(572) DESCRIBE `sailingdates` 0.0009009838104248
(573) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 419774))) 0.00021696090698242
(574) DESCRIBE `sailingdates` 0.00070405006408691
(575) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 419775))) 0.00019311904907227
(576) DESCRIBE `sailingdates` 0.00060296058654785
(577) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 419776))) 0.00019097328186035
(578) DESCRIBE `sailingdates` 0.0010340213775635
(579) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 419777))) 0.00020885467529297
(580) DESCRIBE `sailingdates` 0.00061297416687012
(581) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 419778))) 0.0001981258392334
(582) DESCRIBE `sailingdates` 0.00063896179199219
(583) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 419779))) 0.00020003318786621
(584) DESCRIBE `sailingdates` 0.00065398216247559
(585) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 419780))) 0.00019502639770508
(586) DESCRIBE `ports` 0.00070500373840332
(587) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 193))) 0.00021505355834961
(588) DESCRIBE `ports` 0.00087785720825195
(589) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '193') 0.0002448558807373
(590) DESCRIBE `ports` 0.00076389312744141
(591) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 189))) 0.0002129077911377
(592) DESCRIBE `ports` 0.00074291229248047
(593) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '189') 0.00019001960754395
(594) DESCRIBE `ports` 0.00072097778320312
(595) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 187))) 0.00022101402282715
(596) DESCRIBE `ports` 0.00070309638977051
(597) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '187') 0.00019192695617676
(598) DESCRIBE `ports` 0.00068497657775879
(599) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 193))) 0.00020694732666016
(600) DESCRIBE `ports` 0.0007021427154541
(601) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '193') 0.00018501281738281
(602) DESCRIBE `cruises` 0.0013389587402344
(603) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 66883))) 0.00035881996154785
(604) DESCRIBE `avid_specials` 0.00066900253295898
(605) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1294179 and class = 'Special') OR (item_id = 66883 and class = 'Cruise') OR (item_id = 644 AND class = 'Ship') OR (item_id = 38 AND class = 'CruiseLine') OR (item_id = 35 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.00088787078857422
(606) DESCRIBE `cruiselines` 0.001007080078125
(607) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 38))) 0.00024008750915527
(608) DESCRIBE `orchid_image` 0.00076913833618164
(609) DESCRIBE `cruiselines` 0.0009760856628418
(610) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '38') 0.00019311904907227
(611) DESCRIBE `specials` 0.0019481182098389
(612) DESCRIBE `specials` 0.0022628307342529
(613) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1221707') 0.00030207633972168
(614) DESCRIBE `ships` 0.0014419555664062
(615) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1049))) 0.00031805038452148
(616) DESCRIBE `ships` 0.0013928413391113
(617) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1049') 0.00021195411682129
(618) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00018310546875
(619) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017094612121582
(620) DESCRIBE `itineraries` 0.00074100494384766
(621) DESCRIBE `ports` 0.00072503089904785
(622) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00025296211242676
(623) DESCRIBE `ports` 0.00075507164001465
(624) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00020980834960938
(625) DESCRIBE `ports` 0.00069785118103027
(626) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00020384788513184
(627) DESCRIBE `specialsailingdates` 0.00060892105102539
(628) DESCRIBE `sailingdates` 0.00063300132751465
(629) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396477))) 0.00024104118347168
(630) DESCRIBE `sailingdates` 0.00061297416687012
(631) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396478))) 0.0001978874206543
(632) DESCRIBE `ports` 0.00078511238098145
(633) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00023102760314941
(634) DESCRIBE `ports` 0.00075793266296387
(635) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00021004676818848
(636) DESCRIBE `ports` 0.00070500373840332
(637) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1548))) 0.00022506713867188
(638) DESCRIBE `ports` 0.0007178783416748
(639) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1548') 0.00018882751464844
(640) DESCRIBE `ports` 0.00067996978759766
(641) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1550))) 0.00021195411682129
(642) DESCRIBE `ports` 0.00070714950561523
(643) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1550') 0.00018787384033203
(644) DESCRIBE `ports` 0.00069308280944824
(645) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1508))) 0.00020480155944824
(646) DESCRIBE `ports` 0.00069403648376465
(647) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1508') 0.00018405914306641
(648) DESCRIBE `ports` 0.00075292587280273
(649) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1510))) 0.00020503997802734
(650) DESCRIBE `ports` 0.00080490112304688
(651) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1510') 0.00019001960754395
(652) DESCRIBE `ports` 0.00090980529785156
(653) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1552))) 0.00027298927307129
(654) DESCRIBE `ports` 0.0010180473327637
(655) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1552') 0.00024294853210449
(656) DESCRIBE `ports` 0.0010480880737305
(657) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1551))) 0.00028300285339355
(658) DESCRIBE `ports` 0.0010209083557129
(659) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1551') 0.00024294853210449
(660) DESCRIBE `ports` 0.0010359287261963
(661) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00023007392883301
(662) DESCRIBE `ports` 0.00070714950561523
(663) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00018882751464844
(664) DESCRIBE `cruises` 0.0013611316680908
(665) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 40897))) 0.00030207633972168
(666) DESCRIBE `avid_specials` 0.00069093704223633
(667) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1221707 and class = 'Special') OR (item_id = 40897 and class = 'Cruise') OR (item_id = 1049 AND class = 'Ship') OR (item_id = 144 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.001107931137085
(668) DESCRIBE `cruiselines` 0.0012068748474121
(669) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00026321411132812
(670) DESCRIBE `orchid_image` 0.00078296661376953
(671) DESCRIBE `cruiselines` 0.00099706649780273
(672) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00021815299987793
(673) DESCRIBE `specials` 0.001964807510376
(674) DESCRIBE `specials` 0.0018868446350098
(675) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1221851') 0.00026917457580566
(676) DESCRIBE `ships` 0.0013999938964844
(677) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1064))) 0.00030112266540527
(678) DESCRIBE `ships` 0.0013489723205566
(679) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1064') 0.0001981258392334
(680) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00018596649169922
(681) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017189979553223
(682) DESCRIBE `itineraries` 0.00069999694824219
(683) DESCRIBE `ports` 0.00072479248046875
(684) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00027108192443848
(685) DESCRIBE `ports` 0.00069499015808105
(686) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00020813941955566
(687) DESCRIBE `ports` 0.00069880485534668
(688) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00020003318786621
(689) DESCRIBE `specialsailingdates` 0.00059080123901367
(690) DESCRIBE `sailingdates` 0.00064897537231445
(691) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396362))) 0.00024104118347168
(692) DESCRIBE `sailingdates` 0.00062704086303711
(693) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396363))) 0.00020098686218262
(694) DESCRIBE `sailingdates` 0.00063109397888184
(695) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396364))) 0.0001978874206543
(696) DESCRIBE `sailingdates` 0.00060582160949707
(697) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396365))) 0.00022602081298828
(698) DESCRIBE `sailingdates` 0.00060606002807617
(699) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396366))) 0.00019598007202148
(700) DESCRIBE `ports` 0.00070905685424805
(701) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00022792816162109
(702) DESCRIBE `ports` 0.00070405006408691
(703) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.0001988410949707
(704) DESCRIBE `ports` 0.00073695182800293
(705) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2673))) 0.00020885467529297
(706) DESCRIBE `ports` 0.00071501731872559
(707) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2673') 0.00018692016601562
(708) DESCRIBE `ports` 0.00069499015808105
(709) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4086))) 0.00029516220092773
(710) DESCRIBE `ports` 0.00072813034057617
(711) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4086') 0.00019717216491699
(712) DESCRIBE `ports` 0.00067710876464844
(713) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4088))) 0.00020503997802734
(714) DESCRIBE `ports` 0.0007169246673584
(715) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4088') 0.00018095970153809
(716) DESCRIBE `ports` 0.00068306922912598
(717) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00021100044250488
(718) DESCRIBE `ports` 0.00070691108703613
(719) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00019311904907227
(720) DESCRIBE `ports` 0.00079584121704102
(721) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00022006034851074
(722) DESCRIBE `ports` 0.00068807601928711
(723) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00018310546875
(724) DESCRIBE `cruises` 0.00136399269104
(725) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 41319))) 0.00030994415283203
(726) DESCRIBE `avid_specials` 0.00063705444335938
(727) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1221851 and class = 'Special') OR (item_id = 41319 and class = 'Cruise') OR (item_id = 1064 AND class = 'Ship') OR (item_id = 144 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.00088620185852051
(728) DESCRIBE `cruiselines` 0.00098085403442383
(729) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.0002448558807373
(730) DESCRIBE `orchid_image` 0.0007469654083252
(731) DESCRIBE `cruiselines` 0.0009920597076416
(732) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.0002129077911377
(733) DESCRIBE `cruiselines` 0.0011539459228516
(734) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('144', '38', '101', '91', '47', '171', '147', '18', '23', '24', '15', '263', '114', '208', '262', '19', '33', '20', '37', '188', '8', '29', '151', '187', '218')) ORDER BY FIND_IN_SET(id, '144,38,101,91,47,171,147,18,23,24,15,263,114,208,262,19,33,20,37,188,8,29,151,187,218') 0.001021146774292
(735) DESCRIBE `ships` 0.0015881061553955
(736) SELECT `ships`.* FROM `ships` WHERE (id IN ('189', '1068', '1063', '1064', '517', '644', '1035', '1134', '1232', '650', '1206', '1468', '1036', '394', '709', '1045', '1409', '1483', '1047', '1318', '966', '988', '1040', '1049', '1060', '1154', '1492', '547', '973', '1051', '1052', '1108', '1293', '82', '258', '338', '796', '850', '1139', '1456', '75', '111', '451', '643', '780', '786', '871', '1028', '1055', '1067', '1138', '1464', '1465', '108', '163', '448', '508', '795', '823', '888', '972', '1029', '1044', '1062', '1223', '1286', '1319', '223', '253', '585', '652', '683', '765', '785', '1038', '1043', '1050', '1106', '1168', '1224', '1266', '1284', '1321', '1371', '1579', '1617')) ORDER BY FIND_IN_SET(id, '189,1068,1063,1064,517,644,1035,1134,1232,650,1206,1468,1036,394,709,1045,1409,1483,1047,1318,966,988,1040,1049,1060,1154,1492,547,973,1051,1052,1108,1293,82,258,338,796,850,1139,1456,75,111,451,643,780,786,871,1028,1055,1067,1138,1464,1465,108,163,448,508,795,823,888,972,1029,1044,1062,1223,1286,1319,223,253,585,652,683,765,785,1038,1043,1050,1106,1168,1224,1266,1284,1321,1371,1579,1617') 0.0034139156341553
(737) DESCRIBE `cruisetypes` 0.0010390281677246
(738) DESCRIBE `destinations` 0.0011692047119141
(739) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '35', '43', '22', '54', '40', '8', '53', '26', '12', '2', '48', '7', '11', '38', '21', '28', '34')) ORDER BY FIND_IN_SET(id, '50,35,43,22,54,40,8,53,26,12,2,48,7,11,38,21,28,34') 0.00080204010009766