or, enquire about your chosen options

  1. REVIEW: P & O Australia’s Pacific Aria
  2. Catch Up on Cruising: Latest News in bite size!
  3. Asian Adventures with Zuleika from the Cruise Factor Team
  4. A short cruise is a good cruise!!
  5. SPOTLIGHT ON: Symphony of the Seas

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

Total elapsed time: 0.33641195297241

# Query Time
(1) connect 0.0005640983581543
(2) DESCRIBE `cruises` 0.0017058849334717
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (71234, 59951, 73201, 61428, 73198, 59772, 61427, 66904, 40396, 67056)) ORDER BY FIND_IN_SET(id, '71234,59951,73201,61428,73198,59772,61427,66904,40396,67056') 0.0011260509490967
(4) DESCRIBE `cruises` 0.001317024230957
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71234') 0.00021696090698242
(6) DESCRIBE `ships` 0.001331090927124
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 792))) 0.0002601146697998
(8) DESCRIBE `ships` 0.0013461112976074
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '792') 0.00018000602722168
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017714500427246
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00016307830810547
(12) DESCRIBE `itineraries` 0.0006871223449707
(13) DESCRIBE `ports` 0.00073385238647461
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00022292137145996
(15) DESCRIBE `ports` 0.00068092346191406
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00021600723266602
(17) DESCRIBE `ports` 0.00069284439086914
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.0001981258392334
(19) DESCRIBE `sailingdates` 0.00060510635375977
(20) DESCRIBE `ports` 0.00071597099304199
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00022697448730469
(22) DESCRIBE `ports` 0.00066804885864258
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00018596649169922
(24) DESCRIBE `ports` 0.00066590309143066
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 36))) 0.00020980834960938
(26) DESCRIBE `ports` 0.00077009201049805
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '36') 0.00017881393432617
(28) DESCRIBE `ports` 0.0006721019744873
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00019288063049316
(30) DESCRIBE `ports` 0.00066804885864258
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00017809867858887
(32) DESCRIBE `ports` 0.00072598457336426
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00019311904907227
(34) DESCRIBE `ports` 0.00066518783569336
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00017309188842773
(36) DESCRIBE `ports` 0.0006711483001709
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00020885467529297
(38) DESCRIBE `ports` 0.00068998336791992
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00017690658569336
(40) DESCRIBE `avid_specials` 0.00059700012207031
(41) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 71234 and class = 'Cruise') OR (item_id = 792 AND class = 'Ship') OR (item_id = 18 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.001007080078125
(42) DESCRIBE `cruiselines` 0.0010149478912354
(43) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.0002138614654541
(44) DESCRIBE `orchid_image` 0.00074505805969238
(45) DESCRIBE `cruiselines` 0.00093603134155273
(46) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00017809867858887
(47) DESCRIBE `cruises` 0.001323938369751
(48) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59951') 0.00020790100097656
(49) DESCRIBE `ships` 0.0012788772583008
(50) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 82))) 0.00023579597473145
(51) DESCRIBE `ships` 0.0014200210571289
(52) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '82') 0.00017809867858887
(53) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017285346984863
(54) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016307830810547
(55) DESCRIBE `itineraries` 0.00065302848815918
(56) DESCRIBE `ports` 0.00068211555480957
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.0002131462097168
(58) DESCRIBE `ports` 0.0007319450378418
(59) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00019598007202148
(60) DESCRIBE `ports` 0.00066590309143066
(61) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00018000602722168
(62) DESCRIBE `sailingdates` 0.00059390068054199
(63) DESCRIBE `ports` 0.00067496299743652
(64) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.0001990795135498
(65) DESCRIBE `ports` 0.00074481964111328
(66) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00018310546875
(67) DESCRIBE `ports` 0.00066494941711426
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00019598007202148
(69) DESCRIBE `ports` 0.0006859302520752
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00017595291137695
(71) DESCRIBE `ports` 0.00067305564880371
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 58))) 0.00023412704467773
(73) DESCRIBE `ports` 0.00067281723022461
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '58') 0.00017809867858887
(75) DESCRIBE `ports` 0.00071811676025391
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00019192695617676
(77) DESCRIBE `ports` 0.00068020820617676
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00017404556274414
(79) DESCRIBE `ports` 0.00068497657775879
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00021505355834961
(81) DESCRIBE `ports` 0.00067687034606934
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00017404556274414
(83) DESCRIBE `ports` 0.00066399574279785
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 36))) 0.00019598007202148
(85) DESCRIBE `ports` 0.00073909759521484
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '36') 0.00022602081298828
(87) DESCRIBE `ports` 0.00076413154602051
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00020718574523926
(89) DESCRIBE `ports` 0.00068807601928711
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00018191337585449
(91) DESCRIBE `ports` 0.00072908401489258
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00019097328186035
(93) DESCRIBE `ports` 0.00066709518432617
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00018811225891113
(95) DESCRIBE `ports` 0.0007328987121582
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.0001981258392334
(97) DESCRIBE `ports` 0.00066804885864258
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00017905235290527
(99) DESCRIBE `avid_specials` 0.00060391426086426
(100) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59951 and class = 'Cruise') OR (item_id = 82 AND class = 'Ship') OR (item_id = 18 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.0010340213775635
(101) DESCRIBE `cruiselines` 0.00097393989562988
(102) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00023198127746582
(103) DESCRIBE `orchid_image` 0.00075006484985352
(104) DESCRIBE `cruiselines` 0.00095295906066895
(105) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00017905235290527
(106) DESCRIBE `cruises` 0.0013298988342285
(107) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73201') 0.00022482872009277
(108) DESCRIBE `ships` 0.0012850761413574
(109) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 81))) 0.00024795532226562
(110) DESCRIBE `ships` 0.0013611316680908
(111) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '81') 0.00020098686218262
(112) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017499923706055
(113) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00016188621520996
(114) DESCRIBE `itineraries` 0.00069999694824219
(115) DESCRIBE `ports` 0.00078797340393066
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00023102760314941
(117) DESCRIBE `ports` 0.00067687034606934
(118) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00025486946105957
(119) DESCRIBE `ports` 0.00067591667175293
(120) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00018501281738281
(121) DESCRIBE `sailingdates` 0.00060081481933594
(122) DESCRIBE `ports` 0.00069689750671387
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00020694732666016
(124) DESCRIBE `ports` 0.00068402290344238
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00018000602722168
(126) DESCRIBE `ports` 0.00066781044006348
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.00021004676818848
(128) DESCRIBE `ports` 0.00075984001159668
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.00019598007202148
(130) DESCRIBE `ports` 0.00081110000610352
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.000244140625
(132) DESCRIBE `ports` 0.00081706047058105
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00017619132995605
(134) DESCRIBE `ports` 0.00068402290344238
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00019097328186035
(136) DESCRIBE `ports` 0.00069093704223633
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00026392936706543
(138) DESCRIBE `ports` 0.0006721019744873
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3349))) 0.00020098686218262
(140) DESCRIBE `ports` 0.00071215629577637
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3349') 0.00019693374633789
(142) DESCRIBE `ports` 0.00074887275695801
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00019502639770508
(144) DESCRIBE `ports` 0.00068283081054688
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00017499923706055
(146) DESCRIBE `ports` 0.00066900253295898
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 414))) 0.00019717216491699
(148) DESCRIBE `ports` 0.00072693824768066
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '414') 0.00017690658569336
(150) DESCRIBE `ports` 0.0007169246673584
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 757))) 0.00019502639770508
(152) DESCRIBE `ports` 0.00073385238647461
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '757') 0.00017690658569336
(154) DESCRIBE `ports` 0.00066900253295898
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.0001990795135498
(156) DESCRIBE `ports` 0.00066494941711426
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00017595291137695
(158) DESCRIBE `ports` 0.00067377090454102
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 119))) 0.00022697448730469
(160) DESCRIBE `ports` 0.00066208839416504
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '119') 0.00018811225891113
(162) DESCRIBE `ports` 0.0006868839263916
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) 0.00019407272338867
(164) DESCRIBE `ports` 0.00066494941711426
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') 0.00017380714416504
(166) DESCRIBE `ports` 0.00076413154602051
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 117))) 0.00021195411682129
(168) DESCRIBE `ports` 0.00069093704223633
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '117') 0.00017905235290527
(170) DESCRIBE `ports` 0.00075507164001465
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 702))) 0.00019598007202148
(172) DESCRIBE `ports` 0.00068902969360352
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '702') 0.00017404556274414
(174) DESCRIBE `ports` 0.0006718635559082
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2200))) 0.00019311904907227
(176) DESCRIBE `ports` 0.00067901611328125
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2200') 0.00017285346984863
(178) DESCRIBE `ports` 0.00068807601928711
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.00020289421081543
(180) DESCRIBE `ports` 0.00066709518432617
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.00017309188842773
(182) DESCRIBE `ports` 0.00066304206848145
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2200))) 0.00020408630371094
(184) DESCRIBE `ports` 0.00067400932312012
(185) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2200') 0.00021100044250488
(186) DESCRIBE `ports` 0.00080204010009766
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.0002129077911377
(188) DESCRIBE `ports` 0.0006709098815918
(189) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '116') 0.00019001960754395
(190) DESCRIBE `avid_specials` 0.00060486793518066
(191) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73201 and class = 'Cruise') OR (item_id = 81 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 12 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010008811950684
(192) DESCRIBE `cruiselines` 0.00098681449890137
(193) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00021696090698242
(194) DESCRIBE `orchid_image` 0.00075411796569824
(195) DESCRIBE `cruiselines` 0.00094318389892578
(196) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00017690658569336
(197) DESCRIBE `cruises` 0.0012528896331787
(198) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '61428') 0.00019407272338867
(199) DESCRIBE `ships` 0.0012707710266113
(200) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 75))) 0.00024509429931641
(201) DESCRIBE `ships` 0.0013527870178223
(202) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '75') 0.00019979476928711
(203) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017786026000977
(204) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00016593933105469
(205) DESCRIBE `itineraries` 0.00073599815368652
(206) DESCRIBE `ports` 0.00071001052856445
(207) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.00022411346435547
(208) DESCRIBE `ports` 0.00068402290344238
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.00019693374633789
(210) DESCRIBE `ports` 0.00068187713623047
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '116') 0.00018501281738281
(212) DESCRIBE `sailingdates` 0.00064301490783691
(213) DESCRIBE `ports` 0.00071001052856445
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.00020003318786621
(215) DESCRIBE `ports` 0.00072598457336426
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '116') 0.00017976760864258
(217) DESCRIBE `ports` 0.00075697898864746
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2200))) 0.00021910667419434
(219) DESCRIBE `ports` 0.00081682205200195
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2200') 0.00021791458129883
(221) DESCRIBE `ports` 0.00068116188049316
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.00020313262939453
(223) DESCRIBE `ports` 0.00067591667175293
(224) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.00018000602722168
(225) DESCRIBE `ports` 0.00067591667175293
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 702))) 0.00019598007202148
(227) DESCRIBE `ports` 0.00091195106506348
(228) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '702') 0.00022697448730469
(229) DESCRIBE `ports` 0.00068807601928711
(230) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 117))) 0.00019001960754395
(231) DESCRIBE `ports` 0.00066995620727539
(232) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '117') 0.00017809867858887
(233) DESCRIBE `ports` 0.00070691108703613
(234) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) 0.0001981258392334
(235) DESCRIBE `ports` 0.00078415870666504
(236) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') 0.0001978874206543
(237) DESCRIBE `ports` 0.00066900253295898
(238) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 119))) 0.00019717216491699
(239) DESCRIBE `ports` 0.00072002410888672
(240) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '119') 0.00017404556274414
(241) DESCRIBE `ports` 0.00069093704223633
(242) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.0002439022064209
(243) DESCRIBE `ports` 0.00066900253295898
(244) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00017690658569336
(245) DESCRIBE `ports` 0.0007321834564209
(246) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 119))) 0.00019097328186035
(247) DESCRIBE `ports` 0.00066494941711426
(248) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '119') 0.00017285346984863
(249) DESCRIBE `ports` 0.00066685676574707
(250) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) 0.00019717216491699
(251) DESCRIBE `ports` 0.00068092346191406
(252) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') 0.00017309188842773
(253) DESCRIBE `ports` 0.00065708160400391
(254) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 117))) 0.00019311904907227
(255) DESCRIBE `ports` 0.00066685676574707
(256) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '117') 0.00018501281738281
(257) DESCRIBE `ports` 0.00066208839416504
(258) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 702))) 0.00019192695617676
(259) DESCRIBE `ports` 0.00066089630126953
(260) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '702') 0.00018501281738281
(261) DESCRIBE `ports` 0.00065898895263672
(262) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.00020313262939453
(263) DESCRIBE `ports` 0.00067901611328125
(264) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.00017309188842773
(265) DESCRIBE `ports` 0.00066089630126953
(266) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2200))) 0.00019502639770508
(267) DESCRIBE `ports` 0.00066399574279785
(268) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2200') 0.00018906593322754
(269) DESCRIBE `ports` 0.00077414512634277
(270) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.00026202201843262
(271) DESCRIBE `ports` 0.00083518028259277
(272) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '116') 0.00024199485778809
(273) DESCRIBE `avid_specials` 0.00083088874816895
(274) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 61428 and class = 'Cruise') OR (item_id = 75 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 11 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.0013480186462402
(275) DESCRIBE `cruiselines` 0.001039981842041
(276) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00022387504577637
(277) DESCRIBE `orchid_image` 0.00075387954711914
(278) DESCRIBE `cruiselines` 0.0010280609130859
(279) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00019621849060059
(280) DESCRIBE `cruises` 0.0013828277587891
(281) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73198') 0.00026488304138184
(282) DESCRIBE `ships` 0.001284122467041
(283) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 81))) 0.00028395652770996
(284) DESCRIBE `ships` 0.0013210773468018
(285) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '81') 0.00019097328186035
(286) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017714500427246
(287) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00016593933105469
(288) DESCRIBE `itineraries` 0.00069284439086914
(289) DESCRIBE `ports` 0.00074291229248047
(290) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00021505355834961
(291) DESCRIBE `ports` 0.00069189071655273
(292) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00021004676818848
(293) DESCRIBE `ports` 0.00086307525634766
(294) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00018596649169922
(295) DESCRIBE `sailingdates` 0.00063395500183105
(296) DESCRIBE `ports` 0.00068902969360352
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00019407272338867
(298) DESCRIBE `ports` 0.0006871223449707
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00017690658569336
(300) DESCRIBE `ports` 0.0006718635559082
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.00019598007202148
(302) DESCRIBE `ports` 0.00068402290344238
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.00017595291137695
(304) DESCRIBE `ports` 0.00069499015808105
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00019407272338867
(306) DESCRIBE `ports` 0.00066518783569336
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00018215179443359
(308) DESCRIBE `ports` 0.00081300735473633
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00024795532226562
(310) DESCRIBE `ports` 0.00098013877868652
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00021696090698242
(312) DESCRIBE `ports` 0.00085091590881348
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3349))) 0.00020098686218262
(314) DESCRIBE `ports` 0.00089383125305176
(315) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3349') 0.00023388862609863
(316) DESCRIBE `ports` 0.00083184242248535
(317) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00026392936706543
(318) DESCRIBE `ports` 0.0008389949798584
(319) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00019311904907227
(320) DESCRIBE `ports` 0.00068497657775879
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 414))) 0.00023317337036133
(322) DESCRIBE `ports` 0.0006721019744873
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '414') 0.00019288063049316
(324) DESCRIBE `ports` 0.00078988075256348
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 757))) 0.00028395652770996
(326) DESCRIBE `ports` 0.0012238025665283
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '757') 0.00027894973754883
(328) DESCRIBE `ports` 0.00091004371643066
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00025296211242676
(330) DESCRIBE `ports` 0.00099802017211914
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00025200843811035
(332) DESCRIBE `avid_specials` 0.00085592269897461
(333) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73198 and class = 'Cruise') OR (item_id = 81 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 12 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0015730857849121
(334) DESCRIBE `cruiselines` 0.0013890266418457
(335) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00026392936706543
(336) DESCRIBE `orchid_image` 0.00096797943115234
(337) DESCRIBE `cruiselines` 0.0014059543609619
(338) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00026106834411621
(339) DESCRIBE `cruises` 0.00136399269104
(340) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59772') 0.0002439022064209
(341) DESCRIBE `ships` 0.0018630027770996
(342) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 792))) 0.00037097930908203
(343) DESCRIBE `ships` 0.0021970272064209
(344) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '792') 0.00032520294189453
(345) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00023579597473145
(346) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00021910667419434
(347) DESCRIBE `itineraries` 0.00096392631530762
(348) DESCRIBE `ports` 0.00070905685424805
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00022602081298828
(350) DESCRIBE `ports` 0.00074911117553711
(351) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00020098686218262
(352) DESCRIBE `ports` 0.00068998336791992
(353) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00020003318786621
(354) DESCRIBE `sailingdates` 0.00060510635375977
(355) DESCRIBE `ports` 0.00075411796569824
(356) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00021696090698242
(357) DESCRIBE `ports` 0.00067496299743652
(358) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00018811225891113
(359) DESCRIBE `ports` 0.00080704689025879
(360) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00019598007202148
(361) DESCRIBE `ports` 0.00068998336791992
(362) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00017499923706055
(363) DESCRIBE `ports` 0.0006871223449707
(364) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 58))) 0.00020098686218262
(365) DESCRIBE `ports` 0.00066995620727539
(366) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '58') 0.00017285346984863
(367) DESCRIBE `ports` 0.00066614151000977
(368) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00019383430480957
(369) DESCRIBE `ports` 0.00070500373840332
(370) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00018000602722168
(371) DESCRIBE `ports` 0.00066804885864258
(372) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00019598007202148
(373) DESCRIBE `ports` 0.00066709518432617
(374) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00017213821411133
(375) DESCRIBE `ports` 0.00077700614929199
(376) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 36))) 0.00023007392883301
(377) DESCRIBE `ports` 0.00080299377441406
(378) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '36') 0.00019383430480957
(379) DESCRIBE `ports` 0.00070905685424805
(380) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00019717216491699
(381) DESCRIBE `ports` 0.00067615509033203
(382) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00017380714416504
(383) DESCRIBE `ports` 0.0006859302520752
(384) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00021910667419434
(385) DESCRIBE `ports` 0.00084710121154785
(386) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.0001978874206543
(387) DESCRIBE `ports` 0.00067400932312012
(388) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00020694732666016
(389) DESCRIBE `ports` 0.00071310997009277
(390) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00017809867858887
(391) DESCRIBE `avid_specials` 0.00065088272094727
(392) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59772 and class = 'Cruise') OR (item_id = 792 AND class = 'Ship') OR (item_id = 18 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.00095796585083008
(393) DESCRIBE `cruiselines` 0.00098609924316406
(394) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00021815299987793
(395) DESCRIBE `orchid_image` 0.0010612010955811
(396) DESCRIBE `cruiselines` 0.00105881690979
(397) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00022506713867188
(398) DESCRIBE `cruises` 0.0013630390167236
(399) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '61427') 0.00023794174194336
(400) DESCRIBE `ships` 0.0013439655303955
(401) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 75))) 0.00026392936706543
(402) DESCRIBE `ships` 0.0013439655303955
(403) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '75') 0.00019001960754395
(404) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017309188842773
(405) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00016093254089355
(406) DESCRIBE `itineraries` 0.00067400932312012
(407) DESCRIBE `ports` 0.00075483322143555
(408) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.00025105476379395
(409) DESCRIBE `ports` 0.00081610679626465
(410) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.00023603439331055
(411) DESCRIBE `ports` 0.00075507164001465
(412) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '116') 0.00018405914306641
(413) DESCRIBE `sailingdates` 0.00062298774719238
(414) DESCRIBE `ports` 0.0007331371307373
(415) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.00021910667419434
(416) DESCRIBE `ports` 0.00068998336791992
(417) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '116') 0.00018405914306641
(418) DESCRIBE `ports` 0.00066900253295898
(419) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2200))) 0.00019717216491699
(420) DESCRIBE `ports` 0.00072288513183594
(421) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2200') 0.00021004676818848
(422) DESCRIBE `ports` 0.00078296661376953
(423) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.0002138614654541
(424) DESCRIBE `ports` 0.00077605247497559
(425) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.00020813941955566
(426) DESCRIBE `ports` 0.00084495544433594
(427) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 702))) 0.00026607513427734
(428) DESCRIBE `ports` 0.00091695785522461
(429) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '702') 0.00026082992553711
(430) DESCRIBE `ports` 0.00093507766723633
(431) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 117))) 0.00026321411132812
(432) DESCRIBE `ports` 0.00089311599731445
(433) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '117') 0.00027704238891602
(434) DESCRIBE `ports` 0.00072908401489258
(435) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) 0.00020408630371094
(436) DESCRIBE `ports` 0.00080394744873047
(437) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') 0.00017809867858887
(438) DESCRIBE `ports` 0.0007169246673584
(439) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 119))) 0.00020694732666016
(440) DESCRIBE `ports` 0.00087308883666992
(441) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '119') 0.00017905235290527
(442) DESCRIBE `ports` 0.00072002410888672
(443) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00024986267089844
(444) DESCRIBE `ports` 0.00091099739074707
(445) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.0001990795135498
(446) DESCRIBE `avid_specials` 0.00069212913513184
(447) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 61427 and class = 'Cruise') OR (item_id = 75 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 11 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.0010919570922852
(448) DESCRIBE `cruiselines` 0.0010311603546143
(449) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00022602081298828
(450) DESCRIBE `orchid_image` 0.00081419944763184
(451) DESCRIBE `cruiselines` 0.0011370182037354
(452) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.0001988410949707
(453) DESCRIBE `cruises` 0.001370906829834
(454) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66904') 0.00025105476379395
(455) DESCRIBE `ships` 0.0013339519500732
(456) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 657))) 0.00026702880859375
(457) DESCRIBE `ships` 0.0014500617980957
(458) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '657') 0.00018906593322754
(459) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017619132995605
(460) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00016188621520996
(461) DESCRIBE `itineraries` 0.000701904296875
(462) DESCRIBE `ports` 0.00071501731872559
(463) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00021195411682129
(464) DESCRIBE `ports` 0.00067996978759766
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00019121170043945
(466) DESCRIBE `ports` 0.00066900253295898
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00017499923706055
(468) DESCRIBE `sailingdates` 0.0006101131439209
(469) DESCRIBE `ports` 0.0006871223449707
(470) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00020098686218262
(471) DESCRIBE `ports` 0.00066900253295898
(472) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00017690658569336
(473) DESCRIBE `ports` 0.00068020820617676
(474) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00019502639770508
(475) DESCRIBE `ports` 0.00066089630126953
(476) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00017380714416504
(477) DESCRIBE `ports` 0.00065898895263672
(478) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 36))) 0.00019478797912598
(479) DESCRIBE `ports` 0.00066399574279785
(480) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '36') 0.00017881393432617
(481) DESCRIBE `ports` 0.00068998336791992
(482) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 29))) 0.00019001960754395
(483) DESCRIBE `ports` 0.00072503089904785
(484) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '29') 0.00017404556274414
(485) DESCRIBE `ports` 0.00074505805969238
(486) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00037002563476562
(487) DESCRIBE `ports` 0.00086712837219238
(488) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00019097328186035
(489) DESCRIBE `ports` 0.00093984603881836
(490) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 112))) 0.0001990795135498
(491) DESCRIBE `ports` 0.00067400932312012
(492) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '112') 0.00017690658569336
(493) DESCRIBE `ports` 0.0006868839263916
(494) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00023102760314941
(495) DESCRIBE `ports` 0.00075387954711914
(496) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00017786026000977
(497) DESCRIBE `avid_specials` 0.00061416625976562
(498) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66904 and class = 'Cruise') OR (item_id = 657 AND class = 'Ship') OR (item_id = 18 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.0010061264038086
(499) DESCRIBE `cruiselines` 0.00098800659179688
(500) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00021696090698242
(501) DESCRIBE `orchid_image` 0.00075221061706543
(502) DESCRIBE `cruiselines` 0.00092291831970215
(503) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00017714500427246
(504) DESCRIBE `cruises` 0.0013070106506348
(505) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '40396') 0.00018405914306641
(506) DESCRIBE `ships` 0.0013110637664795
(507) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 82))) 0.00025010108947754
(508) DESCRIBE `ships` 0.0013370513916016
(509) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '82') 0.00019192695617676
(510) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017499923706055
(511) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016188621520996
(512) DESCRIBE `itineraries` 0.00068116188049316
(513) DESCRIBE `ports` 0.0006859302520752
(514) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00021600723266602
(515) DESCRIBE `ports` 0.00071811676025391
(516) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00020003318786621
(517) DESCRIBE `ports` 0.00078415870666504
(518) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00020909309387207
(519) DESCRIBE `sailingdates` 0.00073981285095215
(520) DESCRIBE `ports` 0.00072789192199707
(521) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.0002129077911377
(522) DESCRIBE `ports` 0.00067806243896484
(523) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00018000602722168
(524) DESCRIBE `ports` 0.00069403648376465
(525) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 36))) 0.0001978874206543
(526) DESCRIBE `ports` 0.00068402290344238
(527) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '36') 0.00018811225891113
(528) DESCRIBE `ports` 0.00066494941711426
(529) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00019407272338867
(530) DESCRIBE `ports` 0.00068497657775879
(531) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00018191337585449
(532) DESCRIBE `ports` 0.00066614151000977
(533) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00019097328186035
(534) DESCRIBE `ports` 0.00066590309143066
(535) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00017404556274414
(536) DESCRIBE `ports` 0.00069284439086914
(537) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00021195411682129
(538) DESCRIBE `ports` 0.00066900253295898
(539) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00017690658569336
(540) DESCRIBE `avid_specials` 0.00059890747070312
(541) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 40396 and class = 'Cruise') OR (item_id = 82 AND class = 'Ship') OR (item_id = 18 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.0010428428649902
(542) DESCRIBE `cruiselines` 0.0010120868682861
(543) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00021505355834961
(544) DESCRIBE `orchid_image` 0.00075602531433105
(545) DESCRIBE `cruiselines` 0.0009620189666748
(546) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00017786026000977
(547) DESCRIBE `cruises` 0.0013651847839355
(548) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67056') 0.00020194053649902
(549) DESCRIBE `ships` 0.0012948513031006
(550) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1302))) 0.00025105476379395
(551) DESCRIBE `ships` 0.0013020038604736
(552) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1302') 0.00019097328186035
(553) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00017189979553223
(554) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00016307830810547
(555) DESCRIBE `itineraries` 0.00065779685974121
(556) DESCRIBE `ports` 0.00069403648376465
(557) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.00020480155944824
(558) DESCRIBE `ports` 0.00067615509033203
(559) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.00019097328186035
(560) DESCRIBE `ports` 0.0008389949798584
(561) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.00019311904907227
(562) DESCRIBE `sailingdates` 0.00065898895263672
(563) DESCRIBE `ports` 0.000762939453125
(564) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.0001978874206543
(565) DESCRIBE `ports` 0.00075602531433105
(566) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.00017809867858887
(567) DESCRIBE `ports` 0.00071215629577637
(568) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 220))) 0.00019502639770508
(569) DESCRIBE `ports` 0.00069904327392578
(570) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '220') 0.00018191337585449
(571) DESCRIBE `ports` 0.00080204010009766
(572) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 522))) 0.00020194053649902
(573) DESCRIBE `ports` 0.00069785118103027
(574) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '522') 0.00019097328186035
(575) DESCRIBE `ports` 0.00067901611328125
(576) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 574))) 0.00019598007202148
(577) DESCRIBE `ports` 0.0006861686706543
(578) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '574') 0.00018787384033203
(579) DESCRIBE `ports` 0.00071406364440918
(580) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 521))) 0.00019598007202148
(581) DESCRIBE `ports` 0.00083494186401367
(582) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '521') 0.00017809867858887
(583) DESCRIBE `ports` 0.00066590309143066
(584) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1187))) 0.00019598007202148
(585) DESCRIBE `ports` 0.00068211555480957
(586) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1187') 0.00018882751464844
(587) DESCRIBE `ports` 0.00066494941711426
(588) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.00024700164794922
(589) DESCRIBE `ports` 0.0006718635559082
(590) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.00017595291137695
(591) DESCRIBE `ports` 0.00069689750671387
(592) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 573))) 0.00020313262939453
(593) DESCRIBE `ports` 0.00066590309143066
(594) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '573') 0.00017309188842773
(595) DESCRIBE `ports` 0.0007472038269043
(596) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 829))) 0.00023102760314941
(597) DESCRIBE `ports` 0.00067019462585449
(598) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '829') 0.00017499923706055
(599) DESCRIBE `ports` 0.00069403648376465
(600) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 523))) 0.00019311904907227
(601) DESCRIBE `ports` 0.00066304206848145
(602) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '523') 0.00019001960754395
(603) DESCRIBE `ports` 0.00066685676574707
(604) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 226))) 0.00020408630371094
(605) DESCRIBE `ports` 0.00066184997558594
(606) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '226') 0.0001981258392334
(607) DESCRIBE `ports` 0.00067996978759766
(608) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 828))) 0.00019383430480957
(609) DESCRIBE `ports` 0.00065898895263672
(610) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '828') 0.00017595291137695
(611) DESCRIBE `ports` 0.00066399574279785
(612) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00019383430480957
(613) DESCRIBE `ports` 0.00084185600280762
(614) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00017786026000977
(615) DESCRIBE `ports` 0.00066304206848145
(616) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.00019288063049316
(617) DESCRIBE `ports` 0.00066304206848145
(618) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.00017595291137695
(619) DESCRIBE `avid_specials` 0.00060606002807617
(620) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67056 and class = 'Cruise') OR (item_id = 1302 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 25 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00097393989562988
(621) DESCRIBE `cruiselines` 0.0010139942169189
(622) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00024604797363281
(623) DESCRIBE `orchid_image` 0.00075101852416992
(624) DESCRIBE `cruiselines` 0.0010299682617188
(625) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00018095970153809
(626) DESCRIBE `ships` 0.0013699531555176
(627) SELECT `ships`.* FROM `ships` WHERE (id IN ('792', '1607', '78', '340', '1302', '81', '547', '82', '84', '657', '335', '401', '313', '74', '75')) ORDER BY FIND_IN_SET(id, '792,1607,78,340,1302,81,547,82,84,657,335,401,313,74,75') 0.00071501731872559
(628) DESCRIBE `cruisetypes` 0.0010490417480469
(629) DESCRIBE `destinations` 0.0016269683837891
(630) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('12', '2', '11', '48', '22', '25', '43', '35', '53', '37', '38', '26', '40', '49', '29', '34', '21', '28', '8', '9', '30')) ORDER BY FIND_IN_SET(id, '12,2,11,48,22,25,43,35,53,37,38,26,40,49,29,34,21,28,8,9,30') 0.0013601779937744
(631) DESCRIBE `cruiselines` 0.0010011196136475
(632) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00025296211242676
(633) DESCRIBE `cruiselines` 0.00099301338195801
(634) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00021696090698242