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

Total elapsed time: 0.30239272117615

# Query Time
(1) connect 0.00061178207397461
(2) DESCRIBE `cruises` 0.0015189647674561
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (60787, 58792, 58793, 53812, 46360, 45258, 62014, 53020, 53022, 54920)) ORDER BY FIND_IN_SET(id, '60787,58792,58793,53812,46360,45258,62014,53020,53022,54920') 0.0011940002441406
(4) DESCRIBE `specials` 0.0017111301422119
(5) DESCRIBE `specials` 0.0016310214996338
(6) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1172032') 0.0003349781036377
(7) DESCRIBE `ships` 0.0012450218200684
(8) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 189))) 0.00033211708068848
(9) DESCRIBE `ships` 0.0010988712310791
(10) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '189') 0.00023388862609863
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00022792816162109
(12) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021600723266602
(13) DESCRIBE `itineraries` 0.00065708160400391
(14) DESCRIBE `ports` 0.00062799453735352
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00023007392883301
(16) DESCRIBE `ports` 0.00048089027404785
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00026488304138184
(18) DESCRIBE `ports` 0.00047993659973145
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00018477439880371
(20) DESCRIBE `specialsailingdates` 0.00043296813964844
(21) DESCRIBE `sailingdates` 0.0004730224609375
(22) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 385231))) 0.00034403800964355
(23) DESCRIBE `sailingdates` 0.00044608116149902
(24) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 385232))) 0.00019288063049316
(25) DESCRIBE `sailingdates` 0.00043988227844238
(26) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 385233))) 0.00019001960754395
(27) DESCRIBE `sailingdates` 0.00046300888061523
(28) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 385234))) 0.00022006034851074
(29) DESCRIBE `sailingdates` 0.00060200691223145
(30) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 385235))) 0.00021600723266602
(31) DESCRIBE `sailingdates` 0.00046801567077637
(32) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 385236))) 0.00019001960754395
(33) DESCRIBE `sailingdates` 0.00044083595275879
(34) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 385237))) 0.00019097328186035
(35) DESCRIBE `sailingdates` 0.00043916702270508
(36) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 385238))) 0.00018906593322754
(37) DESCRIBE `sailingdates` 0.00044012069702148
(38) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 385239))) 0.00018906593322754
(39) DESCRIBE `sailingdates` 0.00048017501831055
(40) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 385240))) 0.00019001960754395
(41) DESCRIBE `sailingdates` 0.00053620338439941
(42) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 385241))) 0.00022506713867188
(43) DESCRIBE `sailingdates` 0.00056099891662598
(44) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 385242))) 0.00019097328186035
(45) DESCRIBE `sailingdates` 0.00053882598876953
(46) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 385243))) 0.00022196769714355
(47) DESCRIBE `sailingdates` 0.00051593780517578
(48) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 385244))) 0.00019407272338867
(49) DESCRIBE `sailingdates` 0.00063204765319824
(50) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 385245))) 0.00019407272338867
(51) DESCRIBE `sailingdates` 0.0004420280456543
(52) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 385246))) 0.00019001960754395
(53) DESCRIBE `sailingdates` 0.00050997734069824
(54) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 385247))) 0.00018906593322754
(55) DESCRIBE `sailingdates` 0.00046110153198242
(56) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 385248))) 0.00018906593322754
(57) DESCRIBE `ports` 0.00050997734069824
(58) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.0002138614654541
(59) DESCRIBE `ports` 0.00054597854614258
(60) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00019097328186035
(61) DESCRIBE `ports` 0.00051403045654297
(62) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1424))) 0.00021910667419434
(63) DESCRIBE `ports` 0.00047898292541504
(64) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1424') 0.0002140998840332
(65) DESCRIBE `ports` 0.00047588348388672
(66) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 187))) 0.0001990795135498
(67) DESCRIBE `ports` 0.00049400329589844
(68) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '187') 0.00017690658569336
(69) DESCRIBE `ports` 0.00055384635925293
(70) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 189))) 0.00020790100097656
(71) DESCRIBE `ports` 0.00047898292541504
(72) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '189') 0.00018000602722168
(73) DESCRIBE `ports` 0.00051593780517578
(74) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1424))) 0.0002129077911377
(75) DESCRIBE `ports` 0.00048398971557617
(76) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1424') 0.00019192695617676
(77) DESCRIBE `ports` 0.00047516822814941
(78) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00019407272338867
(79) DESCRIBE `ports` 0.00049901008605957
(80) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00019383430480957
(81) DESCRIBE `cruises` 0.00087594985961914
(82) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 60787))) 0.0002739429473877
(83) DESCRIBE `avid_specials` 0.00045299530029297
(84) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1172032 and class = 'Special') OR (item_id = 60787 and class = 'Cruise') OR (item_id = 189 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.00074601173400879
(85) DESCRIBE `cruiselines` 0.00066804885864258
(86) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 38))) 0.00022602081298828
(87) DESCRIBE `orchid_image` 0.0005340576171875
(88) DESCRIBE `cruiselines` 0.00061416625976562
(89) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '38') 0.00018715858459473
(90) DESCRIBE `specials` 0.0011470317840576
(91) DESCRIBE `specials` 0.0010049343109131
(92) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1171996') 0.00021791458129883
(93) DESCRIBE `ships` 0.00079703330993652
(94) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1082))) 0.00024914741516113
(95) DESCRIBE `ships` 0.00076007843017578
(96) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1082') 0.00018787384033203
(97) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00018191337585449
(98) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00017619132995605
(99) DESCRIBE `itineraries` 0.0005180835723877
(100) DESCRIBE `ports` 0.00048708915710449
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00020194053649902
(102) DESCRIBE `ports` 0.00047898292541504
(103) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.0001990795135498
(104) DESCRIBE `ports` 0.00049901008605957
(105) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00017690658569336
(106) DESCRIBE `specialsailingdates` 0.00043988227844238
(107) DESCRIBE `sailingdates` 0.00044488906860352
(108) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369625))) 0.00020718574523926
(109) DESCRIBE `sailingdates` 0.00047016143798828
(110) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369626))) 0.00019001960754395
(111) DESCRIBE `sailingdates` 0.00044703483581543
(112) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369627))) 0.00018811225891113
(113) DESCRIBE `sailingdates` 0.00043582916259766
(114) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369628))) 0.00019001960754395
(115) DESCRIBE `sailingdates` 0.00043511390686035
(116) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 380892))) 0.00019192695617676
(117) DESCRIBE `sailingdates` 0.00048398971557617
(118) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369629))) 0.00018787384033203
(119) DESCRIBE `sailingdates` 0.00043487548828125
(120) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369630))) 0.00018906593322754
(121) DESCRIBE `sailingdates` 0.00043392181396484
(122) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369631))) 0.00021505355834961
(123) DESCRIBE `sailingdates` 0.00043582916259766
(124) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369632))) 0.00018882751464844
(125) DESCRIBE `sailingdates` 0.00043606758117676
(126) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369633))) 0.00018811225891113
(127) DESCRIBE `ports` 0.00048208236694336
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00021004676818848
(129) DESCRIBE `ports` 0.00047802925109863
(130) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00018000602722168
(131) DESCRIBE `ports` 0.00047612190246582
(132) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 176))) 0.00020098686218262
(133) DESCRIBE `ports` 0.00051093101501465
(134) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '176') 0.00017809867858887
(135) DESCRIBE `ports` 0.00051188468933105
(136) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 535))) 0.00019621849060059
(137) DESCRIBE `ports` 0.00047707557678223
(138) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '535') 0.00017619132995605
(139) DESCRIBE `ports` 0.00047206878662109
(140) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00019192695617676
(141) DESCRIBE `ports` 0.00047111511230469
(142) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00017619132995605
(143) DESCRIBE `ports` 0.00048279762268066
(144) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 535))) 0.00019407272338867
(145) DESCRIBE `ports` 0.0004730224609375
(146) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '535') 0.00017499923706055
(147) DESCRIBE `ports` 0.0004730224609375
(148) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00022602081298828
(149) DESCRIBE `ports` 0.00047397613525391
(150) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00017881393432617
(151) DESCRIBE `cruises` 0.00083303451538086
(152) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 58792))) 0.0002591609954834
(153) DESCRIBE `avid_specials` 0.00046706199645996
(154) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1171996 and class = 'Special') OR (item_id = 58792 and class = 'Cruise') OR (item_id = 1082 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.00076794624328613
(155) DESCRIBE `cruiselines` 0.0006258487701416
(156) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 38))) 0.00021505355834961
(157) DESCRIBE `orchid_image` 0.00052499771118164
(158) DESCRIBE `cruiselines` 0.00067806243896484
(159) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '38') 0.00022602081298828
(160) DESCRIBE `specials` 0.001492977142334
(161) DESCRIBE `specials` 0.0010960102081299
(162) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1172024') 0.00025200843811035
(163) DESCRIBE `ships` 0.00082683563232422
(164) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1082))) 0.0002739429473877
(165) DESCRIBE `ships` 0.00076699256896973
(166) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1082') 0.00019121170043945
(167) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00018191337585449
(168) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00017118453979492
(169) DESCRIBE `itineraries` 0.00055885314941406
(170) DESCRIBE `ports` 0.00050902366638184
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.0002129077911377
(172) DESCRIBE `ports` 0.00048303604125977
(173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.0001981258392334
(174) DESCRIBE `ports` 0.00047898292541504
(175) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00018000602722168
(176) DESCRIBE `specialsailingdates` 0.0004279613494873
(177) DESCRIBE `sailingdates` 0.00044989585876465
(178) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369671))) 0.00022482872009277
(179) DESCRIBE `sailingdates` 0.00043892860412598
(180) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369672))) 0.00019311904907227
(181) DESCRIBE `sailingdates` 0.00043702125549316
(182) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369673))) 0.00021696090698242
(183) DESCRIBE `sailingdates` 0.00043416023254395
(184) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369674))) 0.00019001960754395
(185) DESCRIBE `sailingdates` 0.00043702125549316
(186) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369675))) 0.00019001960754395
(187) DESCRIBE `sailingdates` 0.00043797492980957
(188) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369676))) 0.00019001960754395
(189) DESCRIBE `sailingdates` 0.00043511390686035
(190) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369677))) 0.0001990795135498
(191) DESCRIBE `sailingdates` 0.00043678283691406
(192) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369678))) 0.00020909309387207
(193) DESCRIBE `sailingdates` 0.00044107437133789
(194) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369679))) 0.00018906593322754
(195) DESCRIBE `ports` 0.00052213668823242
(196) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00020122528076172
(197) DESCRIBE `ports` 0.00048303604125977
(198) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00018095970153809
(199) DESCRIBE `ports` 0.00057697296142578
(200) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 176))) 0.00020480155944824
(201) DESCRIBE `ports` 0.00058197975158691
(202) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '176') 0.0002129077911377
(203) DESCRIBE `ports` 0.00047707557678223
(204) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 535))) 0.00019693374633789
(205) DESCRIBE `ports` 0.00047588348388672
(206) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '535') 0.00019311904907227
(207) DESCRIBE `ports` 0.00051498413085938
(208) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00019598007202148
(209) DESCRIBE `ports` 0.00048398971557617
(210) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00017714500427246
(211) DESCRIBE `cruises` 0.0008540153503418
(212) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 58793))) 0.00028800964355469
(213) DESCRIBE `avid_specials` 0.00045299530029297
(214) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1172024 and class = 'Special') OR (item_id = 58793 and class = 'Cruise') OR (item_id = 1082 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.00077199935913086
(215) DESCRIBE `cruiselines` 0.00062990188598633
(216) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 38))) 0.00021600723266602
(217) DESCRIBE `orchid_image` 0.000640869140625
(218) DESCRIBE `cruiselines` 0.00060200691223145
(219) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '38') 0.00018620491027832
(220) DESCRIBE `specials` 0.0011389255523682
(221) DESCRIBE `specials` 0.0010528564453125
(222) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1173626') 0.00022006034851074
(223) DESCRIBE `ships` 0.00078296661376953
(224) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 394))) 0.00025296211242676
(225) DESCRIBE `ships` 0.00084114074707031
(226) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '394') 0.00018310546875
(227) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00018215179443359
(228) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00016999244689941
(229) DESCRIBE `itineraries` 0.00049114227294922
(230) DESCRIBE `ports` 0.00049304962158203
(231) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00021004676818848
(232) DESCRIBE `ports` 0.0004880428314209
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00020909309387207
(234) DESCRIBE `ports` 0.00047802925109863
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00017905235290527
(236) DESCRIBE `specialsailingdates` 0.00042891502380371
(237) DESCRIBE `sailingdates` 0.00049400329589844
(238) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 339722))) 0.0003352165222168
(239) DESCRIBE `ports` 0.00048398971557617
(240) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00020623207092285
(241) DESCRIBE `ports` 0.00047707557678223
(242) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00017905235290527
(243) DESCRIBE `ports` 0.00052094459533691
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.0001978874206543
(245) DESCRIBE `ports` 0.00050187110900879
(246) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00018310546875
(247) DESCRIBE `ports` 0.00050115585327148
(248) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00019693374633789
(249) DESCRIBE `ports` 0.00051403045654297
(250) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.0001981258392334
(251) DESCRIBE `ports` 0.00050520896911621
(252) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 34))) 0.00019502639770508
(253) DESCRIBE `ports` 0.00047588348388672
(254) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '34') 0.00017714500427246
(255) DESCRIBE `ports` 0.00047397613525391
(256) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00020194053649902
(257) DESCRIBE `ports` 0.00047492980957031
(258) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00017714500427246
(259) DESCRIBE `ports` 0.00047492980957031
(260) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00019407272338867
(261) DESCRIBE `ports` 0.00047993659973145
(262) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00018715858459473
(263) DESCRIBE `ports` 0.00052094459533691
(264) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 295))) 0.00024104118347168
(265) DESCRIBE `ports` 0.0004730224609375
(266) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '295') 0.00017905235290527
(267) DESCRIBE `ports` 0.00048112869262695
(268) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 29))) 0.00019502639770508
(269) DESCRIBE `ports` 0.00048708915710449
(270) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '29') 0.00017714500427246
(271) DESCRIBE `ports` 0.00050091743469238
(272) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 112))) 0.0001988410949707
(273) DESCRIBE `ports` 0.00047492980957031
(274) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '112') 0.00017690658569336
(275) DESCRIBE `ports` 0.00049495697021484
(276) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00019598007202148
(277) DESCRIBE `ports` 0.00051093101501465
(278) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00017714500427246
(279) DESCRIBE `cruises` 0.00089097023010254
(280) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 53812))) 0.00031614303588867
(281) DESCRIBE `avid_specials` 0.00048589706420898
(282) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1173626 and class = 'Special') OR (item_id = 53812 and class = 'Cruise') OR (item_id = 394 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 2 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.00071406364440918
(283) DESCRIBE `cruiselines` 0.00063991546630859
(284) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00022101402282715
(285) DESCRIBE `orchid_image` 0.00058293342590332
(286) DESCRIBE `cruiselines` 0.00062108039855957
(287) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00022411346435547
(288) DESCRIBE `specials` 0.0012359619140625
(289) DESCRIBE `specials` 0.0010471343994141
(290) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1083408') 0.00030088424682617
(291) DESCRIBE `ships` 0.001107931137085
(292) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1037))) 0.00032210350036621
(293) DESCRIBE `ships` 0.00081706047058105
(294) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1037') 0.00018978118896484
(295) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00018215179443359
(296) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017213821411133
(297) DESCRIBE `itineraries` 0.00050902366638184
(298) DESCRIBE `ports` 0.00053095817565918
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00020694732666016
(300) DESCRIBE `ports` 0.00048089027404785
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00019478797912598
(302) DESCRIBE `ports` 0.00047922134399414
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00020503997802734
(304) DESCRIBE `specialsailingdates` 0.00047898292541504
(305) DESCRIBE `sailingdates` 0.00045394897460938
(306) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 364863))) 0.00023484230041504
(307) DESCRIBE `ports` 0.00049090385437012
(308) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00020289421081543
(309) DESCRIBE `ports` 0.00048017501831055
(310) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00018501281738281
(311) DESCRIBE `ports` 0.0004880428314209
(312) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2966))) 0.00020194053649902
(313) DESCRIBE `ports` 0.00048589706420898
(314) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2966') 0.00017905235290527
(315) DESCRIBE `ports` 0.00049686431884766
(316) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) 0.00022006034851074
(317) DESCRIBE `ports` 0.00049519538879395
(318) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') 0.00018501281738281
(319) DESCRIBE `ports` 0.00048303604125977
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 714))) 0.00020194053649902
(321) DESCRIBE `ports` 0.00049304962158203
(322) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '714') 0.00017809867858887
(323) DESCRIBE `ports` 0.00048279762268066
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2966))) 0.00020003318786621
(325) DESCRIBE `ports` 0.00048708915710449
(326) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2966') 0.00020217895507812
(327) DESCRIBE `ports` 0.00049090385437012
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00020098686218262
(329) DESCRIBE `ports` 0.00050997734069824
(330) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00017809867858887
(331) DESCRIBE `cruises` 0.00084996223449707
(332) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 46360))) 0.00031518936157227
(333) DESCRIBE `avid_specials` 0.0004580020904541
(334) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1083408 and class = 'Special') OR (item_id = 46360 and class = 'Cruise') OR (item_id = 1037 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.00069189071655273
(335) DESCRIBE `cruiselines` 0.00064992904663086
(336) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00022792816162109
(337) DESCRIBE `orchid_image` 0.00053286552429199
(338) DESCRIBE `cruiselines` 0.00063490867614746
(339) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00019383430480957
(340) DESCRIBE `specials` 0.0011680126190186
(341) DESCRIBE `specials` 0.0010919570922852
(342) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1182304') 0.00024104118347168
(343) DESCRIBE `ships` 0.00083184242248535
(344) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 517))) 0.0002601146697998
(345) DESCRIBE `ships` 0.00081205368041992
(346) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '517') 0.00021910667419434
(347) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00018405914306641
(348) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00017094612121582
(349) DESCRIBE `itineraries` 0.00049114227294922
(350) DESCRIBE `ports` 0.00050497055053711
(351) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00021719932556152
(352) DESCRIBE `ports` 0.00048112869262695
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00020098686218262
(354) DESCRIBE `ports` 0.0004878044128418
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00018906593322754
(356) DESCRIBE `specialsailingdates` 0.00043797492980957
(357) DESCRIBE `sailingdates` 0.00053191184997559
(358) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 366415))) 0.00037503242492676
(359) DESCRIBE `sailingdates` 0.00044608116149902
(360) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 366416))) 0.00020098686218262
(361) DESCRIBE `sailingdates` 0.00044798851013184
(362) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 366417))) 0.00020790100097656
(363) DESCRIBE `sailingdates` 0.000579833984375
(364) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 366418))) 0.00025510787963867
(365) DESCRIBE `ports` 0.00052094459533691
(366) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00021791458129883
(367) DESCRIBE `ports` 0.00070691108703613
(368) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00026297569274902
(369) DESCRIBE `ports` 0.00070714950561523
(370) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00028300285339355
(371) DESCRIBE `ports` 0.00074982643127441
(372) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00024580955505371
(373) DESCRIBE `ports` 0.00071001052856445
(374) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00026488304138184
(375) DESCRIBE `ports` 0.00082921981811523
(376) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00025701522827148
(377) DESCRIBE `ports` 0.00065994262695312
(378) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 288))) 0.00025200843811035
(379) DESCRIBE `ports` 0.00051999092102051
(380) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '288') 0.00018882751464844
(381) DESCRIBE `ports` 0.00055718421936035
(382) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00022006034851074
(383) DESCRIBE `ports` 0.00049090385437012
(384) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00018811225891113
(385) DESCRIBE `ports` 0.00052189826965332
(386) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 285))) 0.00020098686218262
(387) DESCRIBE `ports` 0.00049090385437012
(388) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '285') 0.00018596649169922
(389) DESCRIBE `ports` 0.00054812431335449
(390) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00021219253540039
(391) DESCRIBE `ports` 0.00052499771118164
(392) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.0001828670501709
(393) DESCRIBE `ports` 0.00050187110900879
(394) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00021982192993164
(395) DESCRIBE `ports` 0.00065398216247559
(396) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00019598007202148
(397) DESCRIBE `cruises` 0.0010240077972412
(398) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 45258))) 0.00046110153198242
(399) DESCRIBE `avid_specials` 0.00065493583679199
(400) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1182304 and class = 'Special') OR (item_id = 45258 and class = 'Cruise') OR (item_id = 517 AND class = 'Ship') OR (item_id = 47 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010988712310791
(401) DESCRIBE `cruiselines` 0.00077009201049805
(402) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.00025200843811035
(403) DESCRIBE `orchid_image` 0.00059008598327637
(404) DESCRIBE `cruiselines` 0.00073099136352539
(405) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '47') 0.00029397010803223
(406) DESCRIBE `specials` 0.0014481544494629
(407) DESCRIBE `specials` 0.001215934753418
(408) DESCRIBE `specials` 0.001168966293335
(409) DESCRIBE `cruises` 0.0009000301361084
(410) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62014') 0.00026893615722656
(411) DESCRIBE `specials` 0.0011157989501953
(412) DESCRIBE `ships` 0.00086688995361328
(413) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1456))) 0.00028395652770996
(414) DESCRIBE `ships` 0.00085878372192383
(415) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1456') 0.00024509429931641
(416) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00022101402282715
(417) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00020790100097656
(418) DESCRIBE `itineraries` 0.00064516067504883
(419) DESCRIBE `ports` 0.00076007843017578
(420) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00030088424682617
(421) DESCRIBE `ports` 0.00069904327392578
(422) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00026297569274902
(423) DESCRIBE `ports` 0.00066781044006348
(424) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00025200843811035
(425) DESCRIBE `specials` 0.0012469291687012
(426) DESCRIBE `sailingdates` 0.00053691864013672
(427) DESCRIBE `ports` 0.00060701370239258
(428) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00026798248291016
(429) DESCRIBE `ports` 0.00049901008605957
(430) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00019216537475586
(431) DESCRIBE `ports` 0.00049400329589844
(432) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00020313262939453
(433) DESCRIBE `ports` 0.00049090385437012
(434) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00018310546875
(435) DESCRIBE `ports` 0.00058412551879883
(436) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00025177001953125
(437) DESCRIBE `ports` 0.00050711631774902
(438) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00019001960754395
(439) DESCRIBE `ports` 0.00048589706420898
(440) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2775))) 0.00020003318786621
(441) DESCRIBE `ports` 0.00049495697021484
(442) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2775') 0.00017905235290527
(443) DESCRIBE `ports` 0.0005490779876709
(444) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0.00021505355834961
(445) DESCRIBE `ports` 0.00049304962158203
(446) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 0.00018000602722168
(447) DESCRIBE `ports` 0.00053310394287109
(448) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00020289421081543
(449) DESCRIBE `ports` 0.00052905082702637
(450) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00018501281738281
(451) DESCRIBE `ports` 0.00048708915710449
(452) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00025582313537598
(453) DESCRIBE `ports` 0.00064706802368164
(454) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.000244140625
(455) DESCRIBE `ports` 0.00060796737670898
(456) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4095))) 0.00025081634521484
(457) DESCRIBE `ports` 0.00059795379638672
(458) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4095') 0.00018882751464844
(459) DESCRIBE `ports` 0.00052285194396973
(460) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2779))) 0.00020503997802734
(461) DESCRIBE `ports` 0.00048995018005371
(462) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2779') 0.0002598762512207
(463) DESCRIBE `ports` 0.00048995018005371
(464) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00020503997802734
(465) DESCRIBE `ports` 0.00069999694824219
(466) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00020098686218262
(467) DESCRIBE `ports` 0.00051498413085938
(468) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00020909309387207
(469) DESCRIBE `ports` 0.00050592422485352
(470) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00018000602722168
(471) DESCRIBE `ports` 0.0005488395690918
(472) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00022411346435547
(473) DESCRIBE `ports` 0.00049304962158203
(474) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00018000602722168
(475) DESCRIBE `specials` 0.0012438297271729
(476) DESCRIBE `specials` 0.001392126083374
(477) DESCRIBE `avid_specials` 0.00083398818969727
(478) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62014 and class = 'Cruise') OR (item_id = 1456 AND class = 'Ship') OR (item_id = 263 AND class = 'CruiseLine') OR (item_id = 54 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0012989044189453
(479) DESCRIBE `cruiselines` 0.00099515914916992
(480) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 263))) 0.00031709671020508
(481) DESCRIBE `orchid_image` 0.0007939338684082
(482) DESCRIBE `cruiselines` 0.00070500373840332
(483) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '263') 0.00025606155395508
(484) DESCRIBE `specials` 0.0017890930175781
(485) DESCRIBE `specials` 0.0016200542449951
(486) DESCRIBE `specials` 0.0013790130615234
(487) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1171997') 0.00034022331237793
(488) DESCRIBE `ships` 0.001183032989502
(489) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1082))) 0.00037407875061035
(490) DESCRIBE `ships` 0.0013859272003174
(491) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1082') 0.00025200843811035
(492) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00024008750915527
(493) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00022411346435547
(494) DESCRIBE `itineraries` 0.00068116188049316
(495) DESCRIBE `ports` 0.0007011890411377
(496) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00021696090698242
(497) DESCRIBE `ports` 0.00070285797119141
(498) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00027084350585938
(499) DESCRIBE `ports` 0.00069689750671387
(500) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00022196769714355
(501) DESCRIBE `specialsailingdates` 0.00053596496582031
(502) DESCRIBE `sailingdates` 0.00067496299743652
(503) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369641))) 0.00026106834411621
(504) DESCRIBE `sailingdates` 0.00049901008605957
(505) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369642))) 0.00019192695617676
(506) DESCRIBE `sailingdates` 0.0004570484161377
(507) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369643))) 0.0001988410949707
(508) DESCRIBE `sailingdates` 0.00046992301940918
(509) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369644))) 0.00019693374633789
(510) DESCRIBE `sailingdates` 0.00046706199645996
(511) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369645))) 0.00019598007202148
(512) DESCRIBE `sailingdates` 0.00044798851013184
(513) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369646))) 0.00019001960754395
(514) DESCRIBE `sailingdates` 0.00046992301940918
(515) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369647))) 0.00019598007202148
(516) DESCRIBE `sailingdates` 0.00048995018005371
(517) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369648))) 0.00018978118896484
(518) DESCRIBE `sailingdates` 0.00045084953308105
(519) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369649))) 0.00019407272338867
(520) DESCRIBE `sailingdates` 0.00047087669372559
(521) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369650))) 0.00018787384033203
(522) DESCRIBE `sailingdates` 0.00047993659973145
(523) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369651))) 0.00020098686218262
(524) DESCRIBE `ports` 0.00051689147949219
(525) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00022697448730469
(526) DESCRIBE `ports` 0.00060391426086426
(527) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.0002439022064209
(528) DESCRIBE `ports` 0.00065898895263672
(529) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 176))) 0.00026297569274902
(530) DESCRIBE `ports` 0.00059890747070312
(531) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '176') 0.00018310546875
(532) DESCRIBE `ports` 0.0005037784576416
(533) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 178))) 0.00020599365234375
(534) DESCRIBE `ports` 0.00049996376037598
(535) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '178') 0.00020217895507812
(536) DESCRIBE `ports` 0.00049209594726562
(537) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00020813941955566
(538) DESCRIBE `ports` 0.00050210952758789
(539) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00018191337585449
(540) DESCRIBE `ports` 0.00049400329589844
(541) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2752))) 0.00020503997802734
(542) DESCRIBE `ports` 0.00051403045654297
(543) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2752') 0.00017786026000977
(544) DESCRIBE `ports` 0.0005180835723877
(545) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.0001990795135498
(546) DESCRIBE `ports` 0.00047802925109863
(547) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00017690658569336
(548) DESCRIBE `cruises` 0.0009300708770752
(549) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 53020))) 0.00028896331787109
(550) DESCRIBE `avid_specials` 0.00046586990356445
(551) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1171997 and class = 'Special') OR (item_id = 53020 and class = 'Cruise') OR (item_id = 1082 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.00068998336791992
(552) DESCRIBE `cruiselines` 0.00069117546081543
(553) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 38))) 0.00022101402282715
(554) DESCRIBE `orchid_image` 0.00053691864013672
(555) DESCRIBE `cruiselines` 0.00066184997558594
(556) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '38') 0.00018811225891113
(557) DESCRIBE `specials` 0.0011758804321289
(558) DESCRIBE `specials` 0.0011529922485352
(559) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1172027') 0.00023794174194336
(560) DESCRIBE `ships` 0.00081801414489746
(561) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1082))) 0.00026702880859375
(562) DESCRIBE `ships` 0.00078201293945312
(563) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1082') 0.00020408630371094
(564) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00018811225891113
(565) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00017595291137695
(566) DESCRIBE `itineraries` 0.00049710273742676
(567) DESCRIBE `ports` 0.00049591064453125
(568) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00021600723266602
(569) DESCRIBE `ports` 0.0004889965057373
(570) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00020003318786621
(571) DESCRIBE `ports` 0.00048303604125977
(572) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00017905235290527
(573) DESCRIBE `specialsailingdates` 0.0004279613494873
(574) DESCRIBE `sailingdates` 0.00047111511230469
(575) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369659))) 0.00023198127746582
(576) DESCRIBE `sailingdates` 0.00047898292541504
(577) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369660))) 0.00019407272338867
(578) DESCRIBE `sailingdates` 0.00044393539428711
(579) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369661))) 0.00018882751464844
(580) DESCRIBE `sailingdates` 0.0004420280456543
(581) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369662))) 0.00020217895507812
(582) DESCRIBE `sailingdates` 0.00045013427734375
(583) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369663))) 0.00019001960754395
(584) DESCRIBE `sailingdates` 0.00044894218444824
(585) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369664))) 0.00019598007202148
(586) DESCRIBE `sailingdates` 0.00044512748718262
(587) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369665))) 0.00021910667419434
(588) DESCRIBE `sailingdates` 0.00045299530029297
(589) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369666))) 0.00018787384033203
(590) DESCRIBE `sailingdates` 0.00044989585876465
(591) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369667))) 0.0001990795135498
(592) DESCRIBE `sailingdates` 0.00044584274291992
(593) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369668))) 0.00019001960754395
(594) DESCRIBE `ports` 0.00050902366638184
(595) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.0002140998840332
(596) DESCRIBE `ports` 0.00049400329589844
(597) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00021195411682129
(598) DESCRIBE `ports` 0.00048303604125977
(599) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 176))) 0.00020217895507812
(600) DESCRIBE `ports` 0.00049519538879395
(601) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '176') 0.00018000602722168
(602) DESCRIBE `ports` 0.00048494338989258
(603) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 178))) 0.00021791458129883
(604) DESCRIBE `ports` 0.00049304962158203
(605) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '178') 0.0001838207244873
(606) DESCRIBE `ports` 0.00047993659973145
(607) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00021982192993164
(608) DESCRIBE `ports` 0.00059318542480469
(609) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00020408630371094
(610) DESCRIBE `cruises` 0.00088691711425781
(611) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 53022))) 0.00028204917907715
(612) DESCRIBE `avid_specials` 0.00048089027404785
(613) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1172027 and class = 'Special') OR (item_id = 53022 and class = 'Cruise') OR (item_id = 1082 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.00070691108703613
(614) DESCRIBE `cruiselines` 0.00064206123352051
(615) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 38))) 0.00021791458129883
(616) DESCRIBE `orchid_image` 0.00055313110351562
(617) DESCRIBE `cruiselines` 0.00066304206848145
(618) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '38') 0.00017809867858887
(619) DESCRIBE `specials` 0.0012001991271973
(620) DESCRIBE `specials` 0.0015208721160889
(621) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1173637') 0.0002591609954834
(622) DESCRIBE `ships` 0.0010840892791748
(623) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 108))) 0.00026607513427734
(624) DESCRIBE `ships` 0.00082802772521973
(625) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '108') 0.00018310546875
(626) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00018119812011719
(627) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00017213821411133
(628) DESCRIBE `itineraries` 0.00049495697021484
(629) DESCRIBE `ports` 0.00050902366638184
(630) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.0002138614654541
(631) DESCRIBE `ports` 0.00048112869262695
(632) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00020003318786621
(633) DESCRIBE `ports` 0.00051712989807129
(634) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00017786026000977
(635) DESCRIBE `specialsailingdates` 0.00044512748718262
(636) DESCRIBE `sailingdates` 0.00045299530029297
(637) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 344644))) 0.00021195411682129
(638) DESCRIBE `ports` 0.0005490779876709
(639) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00020503997802734
(640) DESCRIBE `ports` 0.00049614906311035
(641) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00017809867858887
(642) DESCRIBE `ports` 0.00051379203796387
(643) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00020599365234375
(644) DESCRIBE `ports` 0.00052714347839355
(645) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00017905235290527
(646) DESCRIBE `ports` 0.00048398971557617
(647) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.0001988410949707
(648) DESCRIBE `ports` 0.00048398971557617
(649) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00017595291137695
(650) DESCRIBE `ports` 0.00048685073852539
(651) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3963))) 0.00020098686218262
(652) DESCRIBE `ports` 0.00051403045654297
(653) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3963') 0.00018811225891113
(654) DESCRIBE `ports` 0.00048279762268066
(655) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 720))) 0.00023007392883301
(656) DESCRIBE `ports` 0.00047993659973145
(657) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '720') 0.00021195411682129
(658) DESCRIBE `ports` 0.00051212310791016
(659) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00020289421081543
(660) DESCRIBE `ports` 0.0004880428314209
(661) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.0001838207244873
(662) DESCRIBE `ports` 0.00058412551879883
(663) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 581))) 0.00020194053649902
(664) DESCRIBE `ports` 0.00049090385437012
(665) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '581') 0.00017690658569336
(666) DESCRIBE `ports` 0.00049591064453125
(667) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00026488304138184
(668) DESCRIBE `ports` 0.00063896179199219
(669) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00022697448730469
(670) DESCRIBE `cruises` 0.00088381767272949
(671) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 54920))) 0.0003199577331543
(672) DESCRIBE `avid_specials` 0.00050592422485352
(673) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1173637 and class = 'Special') OR (item_id = 54920 and class = 'Cruise') OR (item_id = 108 AND class = 'Ship') OR (item_id = 24 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.00072813034057617
(674) DESCRIBE `cruiselines` 0.00069212913513184
(675) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 24))) 0.00022602081298828
(676) DESCRIBE `orchid_image` 0.00053095817565918
(677) DESCRIBE `cruiselines` 0.00065398216247559
(678) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '24') 0.00018906593322754
(679) DESCRIBE `cruiselines` 0.0007319450378418
(680) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('101', '38', '91', '263', '144', '223', '180', '24', '33', '208', '23', '151', '19', '147', '4', '188', '26', '47', '18', '28', '37', '77', '218', '29', '114', '212', '8', '20', '15', '140', '96', '73')) ORDER BY FIND_IN_SET(id, '101,38,91,263,144,223,180,24,33,208,23,151,19,147,4,188,26,47,18,28,37,77,218,29,114,212,8,20,15,140,96,73') 0.0010530948638916
(681) DESCRIBE `ships` 0.00093197822570801
(682) SELECT `ships`.* FROM `ships` WHERE (id IN ('1082', '684', '1456', '769', '727', '189', '163', '966', '1321', '1223', '1224', '616', '1237', '1063', '650', '1355', '1054', '108', '823', '1457', '338', '517', '850', '988', '1154', '4', '394', '1320', '790', '1013', '508', '796', '977', '1318', '105', '111', '147', '451', '547', '783', '1037', '262', '1051', '1075', '1108', '1319', '43', '82', '124', '253', '258', '287', '288', '349', '573', '580', '704', '726', '937', '938', '1064', '1067', '1078', '1109', '1168', '45', '84', '93', '97', '115', '149', '212', '299', '448', '462', '553', '626', '674', '678', '683', '707', '709', '722', '765', '766', '768', '780', '835', '905', '963', '996', '1021', '1034', '1055', '1073', '1135', '1138', '1145', '1148', '1159', '1233', '1288', '1325', '1453', '1459', '1464')) ORDER BY FIND_IN_SET(id, '1082,684,1456,769,727,189,163,966,1321,1223,1224,616,1237,1063,650,1355,1054,108,823,1457,338,517,850,988,1154,4,394,1320,790,1013,508,796,977,1318,105,111,147,451,547,783,1037,262,1051,1075,1108,1319,43,82,124,253,258,287,288,349,573,580,704,726,937,938,1064,1067,1078,1109,1168,45,84,93,97,115,149,212,299,448,462,553,626,674,678,683,707,709,722,765,766,768,780,835,905,963,996,1021,1034,1055,1073,1135,1138,1145,1148,1159,1233,1288,1325,1453,1459,1464') 0.0035970211029053
(683) DESCRIBE `cruisetypes` 0.00078105926513672
(684) DESCRIBE `destinations` 0.00066709518432617
(685) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '43', '35', '54', '22', '12', '2', '8', '39', '40', '26', '48', '53', '52', '21', '30', '45', '11', '25', '28', '29', '37', '38', '7')) ORDER BY FIND_IN_SET(id, '50,43,35,54,22,12,2,8,39,40,26,48,53,52,21,30,45,11,25,28,29,37,38,7') 0.00082707405090332