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

Total elapsed time: 0.50290632247925

# Query Time
(1) connect 0.00080490112304688
(2) DESCRIBE `cruises` 0.0025050640106201
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (69942, 55776, 63536, 66489, 66493, 68950, 69999, 52341, 69921, 61260)) ORDER BY FIND_IN_SET(id, '69942,55776,63536,66489,66493,68950,69999,52341,69921,61260') 0.0019369125366211
(4) DESCRIBE `cruises` 0.0022640228271484
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69942') 0.00036501884460449
(6) DESCRIBE `ships` 0.0019819736480713
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 883))) 0.00027799606323242
(8) DESCRIBE `ships` 0.0013020038604736
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '883') 0.00018215179443359
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00019097328186035
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017189979553223
(12) DESCRIBE `itineraries` 0.00071811676025391
(13) DESCRIBE `ports` 0.00091385841369629
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00022602081298828
(15) DESCRIBE `ports` 0.00069999694824219
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.0001978874206543
(17) DESCRIBE `ports` 0.00067710876464844
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00021505355834961
(19) DESCRIBE `sailingdates` 0.00084710121154785
(20) DESCRIBE `ports` 0.00069212913513184
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00022482872009277
(22) DESCRIBE `ports` 0.00071310997009277
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00018000602722168
(24) DESCRIBE `ports` 0.00067901611328125
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00022101402282715
(26) DESCRIBE `ports` 0.00069808959960938
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00017905235290527
(28) DESCRIBE `ports` 0.00066590309143066
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2028))) 0.0001988410949707
(30) DESCRIBE `ports` 0.00067782402038574
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2028') 0.00017809867858887
(32) DESCRIBE `ports` 0.00071001052856445
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2028))) 0.00020098686218262
(34) DESCRIBE `ports` 0.00067305564880371
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2028') 0.00017499923706055
(36) DESCRIBE `ports` 0.0006871223449707
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2202))) 0.00020408630371094
(38) DESCRIBE `ports` 0.00070309638977051
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2202') 0.00017905235290527
(40) DESCRIBE `ports` 0.00068783760070801
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2203))) 0.00021004676818848
(42) DESCRIBE `ports` 0.00067496299743652
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2203') 0.00022101402282715
(44) DESCRIBE `ports` 0.00067496299743652
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2201))) 0.00020122528076172
(46) DESCRIBE `ports` 0.00066995620727539
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2201') 0.00017905235290527
(48) DESCRIBE `ports` 0.00066614151000977
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2831))) 0.00021600723266602
(50) DESCRIBE `ports` 0.00068283081054688
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2831') 0.00018405914306641
(52) DESCRIBE `ports` 0.00070381164550781
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2832))) 0.00020599365234375
(54) DESCRIBE `ports` 0.00070405006408691
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2832') 0.00017976760864258
(56) DESCRIBE `ports` 0.0006711483001709
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2204))) 0.00019192695617676
(58) DESCRIBE `ports` 0.00066184997558594
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2204') 0.00017499923706055
(60) DESCRIBE `ports` 0.00071287155151367
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1204))) 0.00022602081298828
(62) DESCRIBE `ports` 0.00079894065856934
(63) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1204') 0.00018596649169922
(64) DESCRIBE `ports` 0.00067782402038574
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3324))) 0.00020503997802734
(66) DESCRIBE `ports` 0.00069403648376465
(67) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3324') 0.00021100044250488
(68) DESCRIBE `ports` 0.0010879039764404
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3324))) 0.00022196769714355
(70) DESCRIBE `ports` 0.00077199935913086
(71) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3324') 0.00018405914306641
(72) DESCRIBE `ports` 0.0006871223449707
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3324))) 0.0001978874206543
(74) DESCRIBE `ports` 0.00066900253295898
(75) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3324') 0.00019001960754395
(76) DESCRIBE `ports` 0.00066208839416504
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 563))) 0.00028705596923828
(78) DESCRIBE `ports` 0.00070405006408691
(79) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '563') 0.00018501281738281
(80) DESCRIBE `ports` 0.00065803527832031
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 563))) 0.00021696090698242
(82) DESCRIBE `ports` 0.0006568431854248
(83) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '563') 0.00018501281738281
(84) DESCRIBE `ports` 0.00067591667175293
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4384))) 0.00021219253540039
(86) DESCRIBE `ports` 0.00069379806518555
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4384') 0.00017809867858887
(88) DESCRIBE `ports` 0.00065708160400391
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4384))) 0.00022101402282715
(90) DESCRIBE `ports` 0.00066709518432617
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4384') 0.00017714500427246
(92) DESCRIBE `ports` 0.00069308280944824
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4384))) 0.00019001960754395
(94) DESCRIBE `ports` 0.00066113471984863
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4384') 0.00017786026000977
(96) DESCRIBE `ports` 0.00068879127502441
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4384))) 0.0002899169921875
(98) DESCRIBE `ports` 0.001060962677002
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4384') 0.00024819374084473
(100) DESCRIBE `avid_specials` 0.00082302093505859
(101) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69942 and class = 'Cruise') OR (item_id = 883 AND class = 'Ship') OR (item_id = 77 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.0013008117675781
(102) DESCRIBE `cruiselines` 0.0011398792266846
(103) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.00022411346435547
(104) DESCRIBE `orchid_image` 0.0007622241973877
(105) DESCRIBE `cruiselines` 0.00096511840820312
(106) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.00018405914306641
(107) DESCRIBE `cruises` 0.0013351440429688
(108) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '55776') 0.00020718574523926
(109) DESCRIBE `ships` 0.0012819766998291
(110) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1316))) 0.00042915344238281
(111) DESCRIBE `ships` 0.002126932144165
(112) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1316') 0.00031900405883789
(113) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00031185150146484
(114) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00028514862060547
(115) DESCRIBE `itineraries` 0.00079989433288574
(116) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '55776') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00066113471984863
(117) DESCRIBE `ports` 0.001600980758667
(118) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00029706954956055
(119) DESCRIBE `ports` 0.0010590553283691
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00027894973754883
(121) DESCRIBE `ports` 0.0011348724365234
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00032997131347656
(123) DESCRIBE `sailingdates` 0.00089812278747559
(124) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '55776') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00089883804321289
(125) DESCRIBE `ports` 0.0011849403381348
(126) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.0001990795135498
(127) DESCRIBE `ports` 0.00066685676574707
(128) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00017714500427246
(129) DESCRIBE `ports` 0.00070786476135254
(130) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00019097328186035
(131) DESCRIBE `ports` 0.00066995620727539
(132) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00018501281738281
(133) DESCRIBE `ports` 0.00066208839416504
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00020098686218262
(135) DESCRIBE `ports` 0.00065803527832031
(136) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00018596649169922
(137) DESCRIBE `ports` 0.00068783760070801
(138) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00019001960754395
(139) DESCRIBE `ports` 0.00075411796569824
(140) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00020003318786621
(141) DESCRIBE `ports` 0.00072383880615234
(142) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1576))) 0.00023603439331055
(143) DESCRIBE `ports` 0.00066781044006348
(144) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1576') 0.00017690658569336
(145) DESCRIBE `ports` 0.00066995620727539
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00020384788513184
(147) DESCRIBE `ports` 0.00067710876464844
(148) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00017499923706055
(149) DESCRIBE `ports` 0.00070285797119141
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1574))) 0.00021004676818848
(151) DESCRIBE `ports` 0.00067305564880371
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1574') 0.00017595291137695
(153) DESCRIBE `ports` 0.00067400932312012
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00019288063049316
(155) DESCRIBE `ports` 0.00066399574279785
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.00018596649169922
(157) DESCRIBE `ports` 0.00066089630126953
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1570))) 0.00020718574523926
(159) DESCRIBE `ports` 0.00066494941711426
(160) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1570') 0.00018787384033203
(161) DESCRIBE `ports` 0.00066280364990234
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1600))) 0.00020194053649902
(163) DESCRIBE `ports` 0.00065898895263672
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1600') 0.00017714500427246
(165) DESCRIBE `ports` 0.00067591667175293
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1567))) 0.00020790100097656
(167) DESCRIBE `ports` 0.00069689750671387
(168) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1567') 0.00017714500427246
(169) DESCRIBE `ports` 0.00065994262695312
(170) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1563))) 0.00019407272338867
(171) DESCRIBE `ports` 0.00067615509033203
(172) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1563') 0.00018596649169922
(173) DESCRIBE `ports` 0.00066304206848145
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1592))) 0.00020003318786621
(175) DESCRIBE `ports` 0.00065517425537109
(176) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1592') 0.00017499923706055
(177) DESCRIBE `ports` 0.00065803527832031
(178) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3685))) 0.00020503997802734
(179) DESCRIBE `ports` 0.00066494941711426
(180) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3685') 0.00018000602722168
(181) DESCRIBE `ports` 0.0006861686706543
(182) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00019288063049316
(183) DESCRIBE `ports` 0.00065803527832031
(184) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00018501281738281
(185) DESCRIBE `avid_specials` 0.00060391426086426
(186) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 55776 and class = 'Cruise') OR (item_id = 1316 AND class = 'Ship') OR (item_id = 77 AND class = 'CruiseLine') OR (item_id = 50 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011701583862305
(187) DESCRIBE `cruiselines` 0.00095510482788086
(188) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.00021696090698242
(189) DESCRIBE `orchid_image` 0.00073981285095215
(190) DESCRIBE `cruiselines` 0.00097298622131348
(191) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.00018405914306641
(192) DESCRIBE `cruises` 0.0012979507446289
(193) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63536') 0.00020313262939453
(194) DESCRIBE `ships` 0.0012528896331787
(195) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 454))) 0.00023984909057617
(196) DESCRIBE `ships` 0.0012509822845459
(197) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '454') 0.00017690658569336
(198) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017809867858887
(199) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017285346984863
(200) DESCRIBE `itineraries` 0.00070714950561523
(201) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '63536') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00052499771118164
(202) DESCRIBE `ports` 0.00077295303344727
(203) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 864))) 0.00020217895507812
(204) DESCRIBE `ports` 0.00066685676574707
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 864))) 0.00019693374633789
(206) DESCRIBE `ports` 0.00066113471984863
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '864') 0.00019478797912598
(208) DESCRIBE `sailingdates` 0.00062012672424316
(209) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '63536') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00047802925109863
(210) DESCRIBE `ports` 0.00076913833618164
(211) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 864))) 0.00028610229492188
(212) DESCRIBE `ports` 0.00082612037658691
(213) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '864') 0.00025296211242676
(214) DESCRIBE `ports` 0.00099611282348633
(215) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00024318695068359
(216) DESCRIBE `ports` 0.00067710876464844
(217) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00018787384033203
(218) DESCRIBE `ports` 0.00069499015808105
(219) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00021195411682129
(220) DESCRIBE `ports` 0.00069308280944824
(221) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00018715858459473
(222) DESCRIBE `ports` 0.00066900253295898
(223) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00021219253540039
(224) DESCRIBE `ports` 0.0006711483001709
(225) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00018692016601562
(226) DESCRIBE `ports` 0.00071096420288086
(227) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 566))) 0.00020408630371094
(228) DESCRIBE `ports` 0.00067901611328125
(229) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '566') 0.00018310546875
(230) DESCRIBE `ports` 0.00066709518432617
(231) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 248))) 0.00021696090698242
(232) DESCRIBE `ports` 0.00071597099304199
(233) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '248') 0.00018191337585449
(234) DESCRIBE `ports` 0.0006709098815918
(235) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2404))) 0.00020003318786621
(236) DESCRIBE `ports` 0.0007929801940918
(237) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2404') 0.00018405914306641
(238) DESCRIBE `ports` 0.00066399574279785
(239) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.00020885467529297
(240) DESCRIBE `ports` 0.0006709098815918
(241) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.00018191337585449
(242) DESCRIBE `ports` 0.00069403648376465
(243) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00022411346435547
(244) DESCRIBE `ports` 0.00073409080505371
(245) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00019288063049316
(246) DESCRIBE `ports` 0.0006709098815918
(247) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00020384788513184
(248) DESCRIBE `ports` 0.00068306922912598
(249) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00018310546875
(250) DESCRIBE `ports` 0.0006718635559082
(251) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00019693374633789
(252) DESCRIBE `ports` 0.00068807601928711
(253) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00018310546875
(254) DESCRIBE `avid_specials` 0.0006098747253418
(255) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63536 and class = 'Cruise') OR (item_id = 454 AND class = 'Ship') OR (item_id = 12 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00096917152404785
(256) DESCRIBE `cruiselines` 0.00098776817321777
(257) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 12))) 0.00023412704467773
(258) DESCRIBE `orchid_image` 0.00088810920715332
(259) DESCRIBE `cruiselines` 0.00096511840820312
(260) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '12') 0.00020003318786621
(261) DESCRIBE `cruises` 0.0013189315795898
(262) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66489') 0.0002291202545166
(263) DESCRIBE `ships` 0.0012729167938232
(264) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1311))) 0.00028896331787109
(265) DESCRIBE `ships` 0.0012879371643066
(266) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1311') 0.00020694732666016
(267) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00019001960754395
(268) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017404556274414
(269) DESCRIBE `itineraries` 0.0007021427154541
(270) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66489') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00058984756469727
(271) DESCRIBE `ports` 0.001147985458374
(272) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00031685829162598
(273) DESCRIBE `ports` 0.00069594383239746
(274) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.0002748966217041
(275) DESCRIBE `ports` 0.0015969276428223
(276) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00040197372436523
(277) DESCRIBE `sailingdates` 0.00091981887817383
(278) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66489') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00081896781921387
(279) DESCRIBE `ports` 0.0011348724365234
(280) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00030708312988281
(281) DESCRIBE `ports` 0.00099301338195801
(282) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00025010108947754
(283) DESCRIBE `ports` 0.0010011196136475
(284) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00026988983154297
(285) DESCRIBE `ports` 0.00098299980163574
(286) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00024580955505371
(287) DESCRIBE `ports` 0.0010039806365967
(288) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00028896331787109
(289) DESCRIBE `ports` 0.0010120868682861
(290) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.0002448558807373
(291) DESCRIBE `ports` 0.00099396705627441
(292) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00026607513427734
(293) DESCRIBE `ports` 0.0010209083557129
(294) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00023889541625977
(295) DESCRIBE `ports` 0.0010890960693359
(296) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1601))) 0.0006251335144043
(297) DESCRIBE `ports` 0.001450777053833
(298) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1601') 0.00033783912658691
(299) DESCRIBE `ports` 0.0012190341949463
(300) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1576))) 0.00040388107299805
(301) DESCRIBE `ports` 0.0012359619140625
(302) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1576') 0.00041580200195312
(303) DESCRIBE `ports` 0.0014030933380127
(304) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1581))) 0.0004880428314209
(305) DESCRIBE `ports` 0.0013370513916016
(306) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1581') 0.00035595893859863
(307) DESCRIBE `ports` 0.0012350082397461
(308) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00036120414733887
(309) DESCRIBE `ports` 0.00091099739074707
(310) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00019693374633789
(311) DESCRIBE `ports` 0.00067782402038574
(312) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1574))) 0.00020813941955566
(313) DESCRIBE `ports` 0.00071001052856445
(314) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1574') 0.00022315979003906
(315) DESCRIBE `ports` 0.00067806243896484
(316) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00021195411682129
(317) DESCRIBE `ports` 0.00073695182800293
(318) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.00018906593322754
(319) DESCRIBE `ports` 0.00067400932312012
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1570))) 0.00025105476379395
(321) DESCRIBE `ports` 0.00070810317993164
(322) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1570') 0.00023007392883301
(323) DESCRIBE `ports` 0.00084280967712402
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1600))) 0.00021910667419434
(325) DESCRIBE `ports` 0.00070095062255859
(326) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1600') 0.0002138614654541
(327) DESCRIBE `ports` 0.000701904296875
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1566))) 0.0002140998840332
(329) DESCRIBE `ports` 0.00069093704223633
(330) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1566') 0.00019288063049316
(331) DESCRIBE `ports` 0.00067019462585449
(332) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1564))) 0.00020313262939453
(333) DESCRIBE `ports` 0.00067996978759766
(334) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1564') 0.00018501281738281
(335) DESCRIBE `ports` 0.0006721019744873
(336) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1592))) 0.00020694732666016
(337) DESCRIBE `ports` 0.00074911117553711
(338) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1592') 0.00018501281738281
(339) DESCRIBE `ports` 0.00079894065856934
(340) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00022101402282715
(341) DESCRIBE `ports` 0.00073504447937012
(342) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00020599365234375
(343) DESCRIBE `ports` 0.00067901611328125
(344) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00020313262939453
(345) DESCRIBE `ports` 0.00068283081054688
(346) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00018405914306641
(347) DESCRIBE `avid_specials` 0.00072717666625977
(348) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66489 and class = 'Cruise') OR (item_id = 1311 AND class = 'Ship') OR (item_id = 249 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.00095605850219727
(349) DESCRIBE `cruiselines` 0.00098800659179688
(350) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 249))) 0.00023603439331055
(351) DESCRIBE `orchid_image` 0.00078105926513672
(352) DESCRIBE `cruiselines` 0.0010499954223633
(353) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '249') 0.00024795532226562
(354) DESCRIBE `cruises` 0.0016238689422607
(355) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66493') 0.00027203559875488
(356) DESCRIBE `ships` 0.0013298988342285
(357) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1310))) 0.00031709671020508
(358) DESCRIBE `ships` 0.0012600421905518
(359) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1310') 0.00020408630371094
(360) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00018692016601562
(361) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017499923706055
(362) DESCRIBE `itineraries` 0.00072884559631348
(363) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66493') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00046396255493164
(364) DESCRIBE `ports` 0.00078415870666504
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00022292137145996
(366) DESCRIBE `ports` 0.00067710876464844
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00020408630371094
(368) DESCRIBE `ports` 0.0006711483001709
(369) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00019097328186035
(370) DESCRIBE `sailingdates` 0.0006101131439209
(371) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66493') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00039005279541016
(372) DESCRIBE `ports` 0.00074505805969238
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00022101402282715
(374) DESCRIBE `ports` 0.00068402290344238
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00019478797912598
(376) DESCRIBE `ports` 0.00066995620727539
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2634))) 0.00020718574523926
(378) DESCRIBE `ports` 0.00067687034606934
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2634') 0.00018501281738281
(380) DESCRIBE `ports` 0.0006711483001709
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1592))) 0.00020503997802734
(382) DESCRIBE `ports` 0.00068902969360352
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1592') 0.00018501281738281
(384) DESCRIBE `ports` 0.00068998336791992
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1564))) 0.000244140625
(386) DESCRIBE `ports` 0.00067496299743652
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1564') 0.00022196769714355
(388) DESCRIBE `ports` 0.00066804885864258
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1566))) 0.00020098686218262
(390) DESCRIBE `ports` 0.00066685676574707
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1566') 0.00018310546875
(392) DESCRIBE `ports` 0.00067996978759766
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1600))) 0.00020194053649902
(394) DESCRIBE `ports` 0.00071811676025391
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1600') 0.00018405914306641
(396) DESCRIBE `ports` 0.00069499015808105
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1570))) 0.00024199485778809
(398) DESCRIBE `ports` 0.00068902969360352
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1570') 0.00018310546875
(400) DESCRIBE `ports` 0.00066900253295898
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.0001988410949707
(402) DESCRIBE `ports` 0.00066614151000977
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.0001981258392334
(404) DESCRIBE `ports` 0.0006718635559082
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1574))) 0.00020003318786621
(406) DESCRIBE `ports` 0.00068497657775879
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1574') 0.00018405914306641
(408) DESCRIBE `ports` 0.00066494941711426
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.0001988410949707
(410) DESCRIBE `ports` 0.00066900253295898
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.0001828670501709
(412) DESCRIBE `ports` 0.00066399574279785
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1576))) 0.00020503997802734
(414) DESCRIBE `ports` 0.00068497657775879
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1576') 0.00018405914306641
(416) DESCRIBE `ports` 0.00066590309143066
(417) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1601))) 0.00020480155944824
(418) DESCRIBE `ports` 0.00066399574279785
(419) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1601') 0.00018310546875
(420) DESCRIBE `ports` 0.00066399574279785
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00020384788513184
(422) DESCRIBE `ports` 0.00066494941711426
(423) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00018310546875
(424) DESCRIBE `ports` 0.00076603889465332
(425) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00020694732666016
(426) DESCRIBE `ports` 0.00068116188049316
(427) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00018405914306641
(428) DESCRIBE `ports` 0.00068783760070801
(429) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00020098686218262
(430) DESCRIBE `ports` 0.00071501731872559
(431) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00019216537475586
(432) DESCRIBE `ports` 0.00066804885864258
(433) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00020098686218262
(434) DESCRIBE `ports` 0.00072002410888672
(435) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00018310546875
(436) DESCRIBE `avid_specials` 0.000762939453125
(437) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66493 and class = 'Cruise') OR (item_id = 1310 AND class = 'Ship') OR (item_id = 249 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.00095605850219727
(438) DESCRIBE `cruiselines` 0.00096797943115234
(439) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 249))) 0.00023198127746582
(440) DESCRIBE `orchid_image` 0.00075793266296387
(441) DESCRIBE `cruiselines` 0.00091695785522461
(442) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '249') 0.00018787384033203
(443) DESCRIBE `cruises` 0.0014381408691406
(444) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68950') 0.00021505355834961
(445) DESCRIBE `ships` 0.0012881755828857
(446) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1342))) 0.00026893615722656
(447) DESCRIBE `ships` 0.0012660026550293
(448) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1342') 0.0001990795135498
(449) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00022792816162109
(450) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00020599365234375
(451) DESCRIBE `itineraries` 0.00074291229248047
(452) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68950') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00061511993408203
(453) DESCRIBE `ports` 0.00071501731872559
(454) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00023102760314941
(455) DESCRIBE `ports` 0.00068998336791992
(456) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00020194053649902
(457) DESCRIBE `ports` 0.00068902969360352
(458) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.0002291202545166
(459) DESCRIBE `sailingdates` 0.00085997581481934
(460) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '68950') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00052785873413086
(461) DESCRIBE `ports` 0.0014598369598389
(462) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00027799606323242
(463) DESCRIBE `ports` 0.00069499015808105
(464) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00019383430480957
(465) DESCRIBE `ports` 0.00067687034606934
(466) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3685))) 0.00027704238891602
(467) DESCRIBE `ports` 0.0006709098815918
(468) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3685') 0.00019192695617676
(469) DESCRIBE `ports` 0.0006721019744873
(470) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1592))) 0.00020885467529297
(471) DESCRIBE `ports` 0.00067496299743652
(472) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1592') 0.00018692016601562
(473) DESCRIBE `ports` 0.00069499015808105
(474) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1563))) 0.00020289421081543
(475) DESCRIBE `ports` 0.00067305564880371
(476) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1563') 0.00018501281738281
(477) DESCRIBE `ports` 0.00066494941711426
(478) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1566))) 0.00022196769714355
(479) DESCRIBE `ports` 0.00067496299743652
(480) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1566') 0.00018906593322754
(481) DESCRIBE `ports` 0.00069999694824219
(482) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1600))) 0.00020408630371094
(483) DESCRIBE `ports` 0.00066709518432617
(484) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1600') 0.0001828670501709
(485) DESCRIBE `ports` 0.00066804885864258
(486) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1570))) 0.00020098686218262
(487) DESCRIBE `ports` 0.00067996978759766
(488) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1570') 0.0001828670501709
(489) DESCRIBE `ports` 0.0006871223449707
(490) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00020313262939453
(491) DESCRIBE `ports` 0.00066804885864258
(492) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.0001828670501709
(493) DESCRIBE `ports` 0.00065493583679199
(494) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1574))) 0.00021004676818848
(495) DESCRIBE `ports` 0.00065898895263672
(496) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1574') 0.00018692016601562
(497) DESCRIBE `ports` 0.0006561279296875
(498) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00020194053649902
(499) DESCRIBE `ports` 0.00065493583679199
(500) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00022006034851074
(501) DESCRIBE `ports` 0.00075697898864746
(502) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1576))) 0.00020503997802734
(503) DESCRIBE `ports` 0.00065803527832031
(504) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1576') 0.00019288063049316
(505) DESCRIBE `ports` 0.00073003768920898
(506) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2914))) 0.00020790100097656
(507) DESCRIBE `ports` 0.0006568431854248
(508) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2914') 0.00018692016601562
(509) DESCRIBE `ports` 0.00068902969360352
(510) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00020790100097656
(511) DESCRIBE `ports` 0.00065708160400391
(512) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00018692016601562
(513) DESCRIBE `ports` 0.00065803527832031
(514) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00020503997802734
(515) DESCRIBE `ports` 0.00067400932312012
(516) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00018978118896484
(517) DESCRIBE `ports` 0.00066018104553223
(518) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00020909309387207
(519) DESCRIBE `ports` 0.00066590309143066
(520) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00020098686218262
(521) DESCRIBE `ports` 0.00068902969360352
(522) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00020194053649902
(523) DESCRIBE `ports` 0.00070500373840332
(524) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00019001960754395
(525) DESCRIBE `avid_specials` 0.00060701370239258
(526) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68950 and class = 'Cruise') OR (item_id = 1342 AND class = 'Ship') OR (item_id = 77 AND class = 'CruiseLine') OR (item_id = 50 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00098395347595215
(527) DESCRIBE `cruiselines` 0.001007080078125
(528) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.00027799606323242
(529) DESCRIBE `orchid_image` 0.00082707405090332
(530) DESCRIBE `cruiselines` 0.0009310245513916
(531) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.00018906593322754
(532) DESCRIBE `cruises` 0.0012447834014893
(533) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69999') 0.00022602081298828
(534) DESCRIBE `ships` 0.0012640953063965
(535) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 979))) 0.00027298927307129
(536) DESCRIBE `ships` 0.0012390613555908
(537) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '979') 0.00019288063049316
(538) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00018215179443359
(539) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017309188842773
(540) DESCRIBE `itineraries` 0.00067400932312012
(541) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69999') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0010859966278076
(542) DESCRIBE `ports` 0.00069689750671387
(543) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00021195411682129
(544) DESCRIBE `ports` 0.00066900253295898
(545) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.0001990795135498
(546) DESCRIBE `ports` 0.0006718635559082
(547) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.0001838207244873
(548) DESCRIBE `sailingdates` 0.00060606002807617
(549) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69999') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00048589706420898
(550) DESCRIBE `ports` 0.00069594383239746
(551) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00020408630371094
(552) DESCRIBE `ports` 0.00067305564880371
(553) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00018405914306641
(554) DESCRIBE `ports` 0.00066804885864258
(555) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.0001981258392334
(556) DESCRIBE `ports` 0.00068497657775879
(557) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00018191337585449
(558) DESCRIBE `ports` 0.00066709518432617
(559) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1592))) 0.00020980834960938
(560) DESCRIBE `ports` 0.00067710876464844
(561) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1592') 0.00018215179443359
(562) DESCRIBE `ports` 0.00066518783569336
(563) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1564))) 0.0001988410949707
(564) DESCRIBE `ports` 0.00078797340393066
(565) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1564') 0.00018501281738281
(566) DESCRIBE `ports` 0.00071406364440918
(567) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1600))) 0.00020480155944824
(568) DESCRIBE `ports` 0.00072002410888672
(569) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1600') 0.00025701522827148
(570) DESCRIBE `ports` 0.00085997581481934
(571) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1600))) 0.0001978874206543
(572) DESCRIBE `ports` 0.00067305564880371
(573) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1600') 0.0002439022064209
(574) DESCRIBE `ports` 0.00070095062255859
(575) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1570))) 0.00020694732666016
(576) DESCRIBE `ports` 0.00067496299743652
(577) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1570') 0.00018715858459473
(578) DESCRIBE `ports` 0.00066995620727539
(579) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00022697448730469
(580) DESCRIBE `ports` 0.00079083442687988
(581) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.00033283233642578
(582) DESCRIBE `ports` 0.00087404251098633
(583) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1574))) 0.0002140998840332
(584) DESCRIBE `ports` 0.00067901611328125
(585) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1574') 0.00018501281738281
(586) DESCRIBE `ports` 0.0006721019744873
(587) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00020790100097656
(588) DESCRIBE `ports` 0.00072383880615234
(589) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00018620491027832
(590) DESCRIBE `ports` 0.0006868839263916
(591) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2094))) 0.00020503997802734
(592) DESCRIBE `ports` 0.00067281723022461
(593) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2094') 0.0001838207244873
(594) DESCRIBE `ports` 0.00066900253295898
(595) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1576))) 0.0001981258392334
(596) DESCRIBE `ports` 0.00066995620727539
(597) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1576') 0.00018191337585449
(598) DESCRIBE `ports` 0.00066113471984863
(599) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1601))) 0.00020003318786621
(600) DESCRIBE `ports` 0.00067496299743652
(601) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1601') 0.00018405914306641
(602) DESCRIBE `ports` 0.00067400932312012
(603) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00020599365234375
(604) DESCRIBE `ports` 0.0006709098815918
(605) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00018405914306641
(606) DESCRIBE `ports` 0.00070309638977051
(607) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.0001988410949707
(608) DESCRIBE `ports` 0.00067591667175293
(609) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.0001828670501709
(610) DESCRIBE `ports` 0.00066781044006348
(611) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00020313262939453
(612) DESCRIBE `ports` 0.00069189071655273
(613) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00018310546875
(614) DESCRIBE `ports` 0.00067305564880371
(615) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.0001988410949707
(616) DESCRIBE `ports` 0.00067496299743652
(617) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00020813941955566
(618) DESCRIBE `avid_specials` 0.0006260871887207
(619) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69999 and class = 'Cruise') OR (item_id = 979 AND class = 'Ship') OR (item_id = 156 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.0009770393371582
(620) DESCRIBE `cruiselines` 0.0010299682617188
(621) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 156))) 0.00024795532226562
(622) DESCRIBE `orchid_image` 0.00079202651977539
(623) DESCRIBE `cruiselines` 0.0010039806365967
(624) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '156') 0.0002288818359375
(625) DESCRIBE `cruises` 0.0022120475769043
(626) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '52341') 0.00033688545227051
(627) DESCRIBE `ships` 0.001554012298584
(628) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 672))) 0.00033283233642578
(629) DESCRIBE `ships` 0.0020430088043213
(630) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '672') 0.00037288665771484
(631) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034308433532715
(632) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00030899047851562
(633) DESCRIBE `itineraries` 0.0012550354003906
(634) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '52341') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0014629364013672
(635) DESCRIBE `ports` 0.0007171630859375
(636) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 217))) 0.00022101402282715
(637) DESCRIBE `ports` 0.0006859302520752
(638) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 217))) 0.00020194053649902
(639) DESCRIBE `ports` 0.00071406364440918
(640) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '217') 0.00018501281738281
(641) DESCRIBE `sailingdates` 0.00060391426086426
(642) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '52341') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00040197372436523
(643) DESCRIBE `ports` 0.00070714950561523
(644) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 217))) 0.00021910667419434
(645) DESCRIBE `ports` 0.00067901611328125
(646) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '217') 0.00018620491027832
(647) DESCRIBE `ports` 0.0006709098815918
(648) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 217))) 0.00022792816162109
(649) DESCRIBE `ports` 0.0007479190826416
(650) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '217') 0.00041604042053223
(651) DESCRIBE `ports` 0.0011501312255859
(652) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00022315979003906
(653) DESCRIBE `ports` 0.00068283081054688
(654) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00018787384033203
(655) DESCRIBE `ports` 0.00069594383239746
(656) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00020289421081543
(657) DESCRIBE `ports` 0.00068497657775879
(658) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00018811225891113
(659) DESCRIBE `ports` 0.00070309638977051
(660) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00020384788513184
(661) DESCRIBE `ports` 0.00069904327392578
(662) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00018596649169922
(663) DESCRIBE `ports` 0.00071096420288086
(664) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2966))) 0.00020313262939453
(665) DESCRIBE `ports` 0.00068306922912598
(666) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2966') 0.00018692016601562
(667) DESCRIBE `ports` 0.00067591667175293
(668) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1555))) 0.00022602081298828
(669) DESCRIBE `ports` 0.00066685676574707
(670) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1555') 0.00018501281738281
(671) DESCRIBE `ports` 0.0006721019744873
(672) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) 0.00020813941955566
(673) DESCRIBE `ports` 0.00069904327392578
(674) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') 0.00018692016601562
(675) DESCRIBE `ports` 0.00066995620727539
(676) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 714))) 0.00020098686218262
(677) DESCRIBE `ports` 0.00067687034606934
(678) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '714') 0.00018501281738281
(679) DESCRIBE `ports` 0.00069308280944824
(680) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 248))) 0.00020194053649902
(681) DESCRIBE `ports` 0.00067996978759766
(682) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '248') 0.00018310546875
(683) DESCRIBE `ports` 0.00066494941711426
(684) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1558))) 0.0002131462097168
(685) DESCRIBE `ports` 0.00072693824768066
(686) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1558') 0.00018501281738281
(687) DESCRIBE `ports` 0.0006711483001709
(688) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1556))) 0.00020003318786621
(689) DESCRIBE `ports` 0.0006709098815918
(690) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1556') 0.00018501281738281
(691) DESCRIBE `ports` 0.00066685676574707
(692) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00020790100097656
(693) DESCRIBE `ports` 0.00067305564880371
(694) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00018692016601562
(695) DESCRIBE `ports` 0.00075292587280273
(696) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00020217895507812
(697) DESCRIBE `ports` 0.0006711483001709
(698) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00018501281738281
(699) DESCRIBE `ports` 0.00067019462585449
(700) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00022411346435547
(701) DESCRIBE `ports` 0.00069808959960938
(702) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00021100044250488
(703) DESCRIBE `avid_specials` 0.00063014030456543
(704) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 52341 and class = 'Cruise') OR (item_id = 672 AND class = 'Ship') OR (item_id = 153 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.0010659694671631
(705) DESCRIBE `cruiselines` 0.0011100769042969
(706) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 153))) 0.00026082992553711
(707) DESCRIBE `orchid_image` 0.0008540153503418
(708) DESCRIBE `cruiselines` 0.0010280609130859
(709) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '153') 0.00023293495178223
(710) DESCRIBE `cruises` 0.0023438930511475
(711) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69921') 0.00026988983154297
(712) DESCRIBE `ships` 0.0013530254364014
(713) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 883))) 0.00027990341186523
(714) DESCRIBE `ships` 0.0013489723205566
(715) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '883') 0.00019311904907227
(716) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00019693374633789
(717) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017619132995605
(718) DESCRIBE `itineraries` 0.00071001052856445
(719) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69921') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00062990188598633
(720) DESCRIBE `ports` 0.0007178783416748
(721) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00025486946105957
(722) DESCRIBE `ports` 0.00070595741271973
(723) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.0002131462097168
(724) DESCRIBE `ports` 0.00070714950561523
(725) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00018906593322754
(726) DESCRIBE `sailingdates` 0.00061416625976562
(727) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69921') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00060391426086426
(728) DESCRIBE `ports` 0.00086593627929688
(729) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.0002291202545166
(730) DESCRIBE `ports` 0.00069189071655273
(731) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00019001960754395
(732) DESCRIBE `ports` 0.00068116188049316
(733) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00020480155944824
(734) DESCRIBE `ports` 0.00069093704223633
(735) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.0001828670501709
(736) DESCRIBE `ports` 0.00068497657775879
(737) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2028))) 0.0001990795135498
(738) DESCRIBE `ports` 0.00072789192199707
(739) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2028') 0.00018095970153809
(740) DESCRIBE `ports` 0.00067806243896484
(741) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2028))) 0.00019598007202148
(742) DESCRIBE `ports` 0.00069999694824219
(743) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2028') 0.00018000602722168
(744) DESCRIBE `ports` 0.00068092346191406
(745) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3315))) 0.00020194053649902
(746) DESCRIBE `ports` 0.00075006484985352
(747) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3315') 0.00018715858459473
(748) DESCRIBE `ports` 0.00068402290344238
(749) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2203))) 0.0002140998840332
(750) DESCRIBE `ports` 0.0006871223449707
(751) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2203') 0.00019192695617676
(752) DESCRIBE `ports` 0.00068402290344238
(753) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2201))) 0.00020098686218262
(754) DESCRIBE `ports` 0.00072598457336426
(755) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2201') 0.00018596649169922
(756) DESCRIBE `ports` 0.00068187713623047
(757) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2831))) 0.00021696090698242
(758) DESCRIBE `ports` 0.00071382522583008
(759) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2831') 0.00018095970153809
(760) DESCRIBE `ports` 0.00067901611328125
(761) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2832))) 0.00020313262939453
(762) DESCRIBE `ports` 0.00067400932312012
(763) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2832') 0.0001978874206543
(764) DESCRIBE `ports` 0.00067710876464844
(765) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2204))) 0.00019598007202148
(766) DESCRIBE `ports` 0.00067687034606934
(767) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2204') 0.00018000602722168
(768) DESCRIBE `ports` 0.00067901611328125
(769) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1204))) 0.00021100044250488
(770) DESCRIBE `ports` 0.00067400932312012
(771) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1204') 0.00018787384033203
(772) DESCRIBE `ports` 0.00067400932312012
(773) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 563))) 0.00021100044250488
(774) DESCRIBE `ports` 0.00069499015808105
(775) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '563') 0.0001838207244873
(776) DESCRIBE `ports` 0.00067591667175293
(777) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 563))) 0.00020098686218262
(778) DESCRIBE `ports` 0.00067400932312012
(779) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '563') 0.00018405914306641
(780) DESCRIBE `ports` 0.00067710876464844
(781) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4384))) 0.00020503997802734
(782) DESCRIBE `ports` 0.00067496299743652
(783) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4384') 0.0001838207244873
(784) DESCRIBE `ports` 0.0006709098815918
(785) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4384))) 0.00020003318786621
(786) DESCRIBE `ports` 0.00068283081054688
(787) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4384') 0.0001838207244873
(788) DESCRIBE `ports` 0.00069999694824219
(789) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4384))) 0.00020098686218262
(790) DESCRIBE `ports` 0.00071096420288086
(791) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4384') 0.00018501281738281
(792) DESCRIBE `ports` 0.00070595741271973
(793) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4384))) 0.00020813941955566
(794) DESCRIBE `ports` 0.00073504447937012
(795) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4384') 0.00024294853210449
(796) DESCRIBE `avid_specials` 0.00081086158752441
(797) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69921 and class = 'Cruise') OR (item_id = 883 AND class = 'Ship') OR (item_id = 77 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.00096487998962402
(798) DESCRIBE `cruiselines` 0.0010061264038086
(799) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.00025606155395508
(800) DESCRIBE `orchid_image` 0.00076603889465332
(801) DESCRIBE `cruiselines` 0.00095105171203613
(802) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.00019121170043945
(803) DESCRIBE `cruises` 0.0013129711151123
(804) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '61260') 0.00024294853210449
(805) DESCRIBE `ships` 0.0012798309326172
(806) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1451))) 0.00026798248291016
(807) DESCRIBE `ships` 0.0013201236724854
(808) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1451') 0.00020813941955566
(809) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00021195411682129
(810) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00019598007202148
(811) DESCRIBE `itineraries` 0.00078797340393066
(812) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '61260') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00063800811767578
(813) DESCRIBE `ports` 0.00079011917114258
(814) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00021815299987793
(815) DESCRIBE `ports` 0.00068902969360352
(816) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00024509429931641
(817) DESCRIBE `ports` 0.00080204010009766
(818) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00019717216491699
(819) DESCRIBE `sailingdates` 0.00061607360839844
(820) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '61260') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0005180835723877
(821) DESCRIBE `ports` 0.00072407722473145
(822) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00023913383483887
(823) DESCRIBE `ports` 0.00071811676025391
(824) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00021815299987793
(825) DESCRIBE `ports` 0.0007939338684082
(826) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00036096572875977
(827) DESCRIBE `ports` 0.00087904930114746
(828) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00020194053649902
(829) DESCRIBE `ports` 0.00077700614929199
(830) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00020790100097656
(831) DESCRIBE `ports` 0.00068283081054688
(832) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00018596649169922
(833) DESCRIBE `ports` 0.00072908401489258
(834) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00020980834960938
(835) DESCRIBE `ports` 0.0007929801940918
(836) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00019311904907227
(837) DESCRIBE `ports` 0.00074195861816406
(838) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2106))) 0.0002129077911377
(839) DESCRIBE `ports` 0.00070881843566895
(840) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2106') 0.00018596649169922
(841) DESCRIBE `ports` 0.0006718635559082
(842) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1586))) 0.00020313262939453
(843) DESCRIBE `ports` 0.00077199935913086
(844) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1586') 0.00035810470581055
(845) DESCRIBE `ports` 0.00086808204650879
(846) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2105))) 0.00021910667419434
(847) DESCRIBE `ports` 0.00068402290344238
(848) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2105') 0.0002131462097168
(849) DESCRIBE `ports` 0.00069093704223633
(850) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4351))) 0.00021600723266602
(851) DESCRIBE `ports` 0.00067996978759766
(852) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4351') 0.00018906593322754
(853) DESCRIBE `ports` 0.00072097778320312
(854) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1584))) 0.0002589225769043
(855) DESCRIBE `ports` 0.00097513198852539
(856) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1584') 0.00024795532226562
(857) DESCRIBE `ports` 0.00099492073059082
(858) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1583))) 0.00021004676818848
(859) DESCRIBE `ports` 0.00069808959960938
(860) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1583') 0.00018811225891113
(861) DESCRIBE `ports` 0.00075817108154297
(862) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1582))) 0.00023198127746582
(863) DESCRIBE `ports` 0.00071811676025391
(864) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1582') 0.00018811225891113
(865) DESCRIBE `ports` 0.00078296661376953
(866) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1582))) 0.00022602081298828
(867) DESCRIBE `ports` 0.00077486038208008
(868) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1582') 0.0001990795135498
(869) DESCRIBE `ports` 0.00069379806518555
(870) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1582))) 0.00020599365234375
(871) DESCRIBE `ports` 0.00071215629577637
(872) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1582') 0.00018596649169922
(873) DESCRIBE `ports` 0.00071287155151367
(874) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1582))) 0.00020503997802734
(875) DESCRIBE `ports` 0.00098299980163574
(876) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1582') 0.00020480155944824
(877) DESCRIBE `avid_specials` 0.0006248950958252
(878) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 61260 and class = 'Cruise') OR (item_id = 1451 AND class = 'Ship') OR (item_id = 77 AND class = 'CruiseLine') OR (item_id = 50 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00096011161804199
(879) DESCRIBE `cruiselines` 0.0010228157043457
(880) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.00022006034851074
(881) DESCRIBE `orchid_image` 0.00075483322143555
(882) DESCRIBE `cruiselines` 0.00097513198852539
(883) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.00021815299987793
(884) DESCRIBE `cruiselines` 0.0013968944549561
(885) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '19', '26', '23', '171', '31', '18', '101', '183', '20', '7', '8', '96', '144', '12', '120', '221', '103', '50', '268', '15', '29', '37', '91', '110', '232', '208', '28', '206', '33', '131', '156', '49', '118', '24', '220', '114', '262', '204', '181', '187', '258', '256', '47', '36', '212', '30', '16', '151', '191', '14', '249', '153', '211', '195', '238', '141', '174', '216', '35', '239', '4', '213', '113', '159', '168', '196', '188', '146', '136', '90', '237', '209', '73', '170', '180', '59', '115', '225', '229', '140', '95', '219', '57', '108', '231', '269', '184', '52', '132', '248', '276', '88', '275', '38', '182', '261', '264', '244', '82', '230', '105', '116', '266', '39', '64', '48', '119', '240', '224', '245', '210', '134', '251')) ORDER BY FIND_IN_SET(id, '218,77,19,26,23,171,31,18,101,183,20,7,8,96,144,12,120,221,103,50,268,15,29,37,91,110,232,208,28,206,33,131,156,49,118,24,220,114,262,204,181,187,258,256,47,36,212,30,16,151,191,14,249,153,211,195,238,141,174,216,35,239,4,213,113,159,168,196,188,146,136,90,237,209,73,170,180,59,115,225,229,140,95,219,57,108,231,269,184,52,132,248,276,88,275,38,182,261,264,244,82,230,105,116,266,39,64,48,119,240,224,245,210,134,251') 0.0041210651397705
(886) DESCRIBE `ships` 0.0026230812072754
(887) SELECT `ships`.* FROM `ships` WHERE (id IN ('1127', '1247', '1554', '1555', '977', '1199', '1291', '1588', '407', '517', '726', '258', '1237', '27', '22', '1424', '461', '1599', '28', '21', '817', '1422', '1594', '393', '1419', '1420', '1423', '1418', '1421', '1135', '349', '1359', '452', '780', '113', '766', '265', '24', '11', '439', '1574', '9', '10', '207', '542', '1067', '1245', '585', '674', '770', '330', '404', '1272', '455', '974', '124', '1455', '1460', '792', '1215', '553', '797', '5', '739', '871', '116', '573', '1572', '25', '3', '520', '855', '1607', '14', '78', '711', '1193', '340', '434', '1021', '1302', '1402', '253', '1586', '390', '1284', '748', '1172', '43', '559', '580', '1581', '462', '765', '285', '791', '1320', '1323', '874', '658', '405', '1139', '590', '678', '286', '582', '883', '119', '327', '526', '731', '859', '970', '454', '854', '406', '81', '823', '610', '722', '850', '1236', '1027', '1569', '114', '993', '1348', '1319', '1415', '1614', '30', '31', '34', '35', '36', '37', '38', '82', '378', '403', '1008', '1012', '1326', '1327', '1678', '39', '160', '333', '547', '1330', '451', '1205', '1325', '163', '348', '351', '784', '966', '1454', '338', '657', '84', '262', '701', '1575', '325', '521', '683', '1143', '732', '287', '352', '1318', '4', '111', '508', '1088', '1108', '1151', '1157', '1471', '1579', '389', '1032', '1075', '1134', '1367', '290', '314', '751', '1214', '1233', '1308', '335', '1145', '1223', '1345', '93', '1013', '1321', '1405', '162', '1137', '1344', '1376', '291', '394', '483', '651', '673', '1144', '1343', '1587', '45', '852', '1604', '545', '988', '1149', '1452', '1453', '1615', '152', '401', '1025', '1090', '1095', '1136', '1283', '1724', '98', '441', '882', '968', '1168', '1243', '1373', '1413', '626', '716', '768', '1163', '1301', '1398', '59', '148', '149', '150', '769', '986', '1382', '1417', '1492', '1526', '75', '151', '639', '669', '905', '1150', '1176', '1226', '1292', '1448', '201', '1449', '324', '776', '973', '1647', '223', '417', '601', '616', '837', '996', '1241', '1458', '1552', '1602', '108', '313', '467', '1026', '1411', '266', '341', '857', '1231', '1489', '954', '1029', '1034', '1285', '1366', '1496', '1609', '1711', '74', '421', '666', '704', '851', '1055', '1152', '1362', '1368', '1372', '480', '885', '1230', '1260', '1384', '1516', '105', '147', '574', '888', '1383', '1408', '1470', '1628', '1717', '503', '790', '1054', '1154', '1208', '1224', '1518', '749', '1505', '1571', '208', '1672', '205', '332', '494', '652', '796', '884', '1253', '1501', '1521', '1611', '422', '618', '811', '818', '836', '985', '1148', '123', '493', '1068', '1486', '1517', '1522', '1632', '204', '212', '423', '937', '938', '1409', '1612', '1682', '448', '485', '1138', '1593', '1639', '994', '995', '1410', '66', '972', '1141', '375', '1017', '1303', '1461', '1539', '1627', '1064', '1601', '420', '1073', '1437', '1514', '1028', '1229', '1254', '1481', '1515', '1613', '1716', '453', '487', '665', '1259', '1412', '1684', '1175', '1189', '1262', '1619', '70', '717', '795', '958', '1159', '1713', '1715', '775', '1053', '1266', '1439', '1714', '715', '738', '1011', '1240', '1704', '1274', '1606', '69', '419', '1106', '1110', '1192', '1360', '1361', '1385', '1459', '944', '1183', '1184', '1347', '808', '1058', '1089', '1338', '1339', '1342', '1474', '1543', '1545', '1160', '1195', '1322', '1708', '62', '488', '798', '886', '1071', '1298', '1311', '1404', '1723', '225', '1158', '1310', '1645', '1649', '1697', '1729', '17', '299', '300', '997', '1043', '1087', '1132', '1355', '1358', '1451', '1629', '479', '672', '821', '1023', '1063', '1217', '1257', '1312', '1540', '288', '555', '692', '707', '1047', '1109', '1140', '1282', '1329', '1350', '1426', '1546')) ORDER BY FIND_IN_SET(id, '1127,1247,1554,1555,977,1199,1291,1588,407,517,726,258,1237,27,22,1424,461,1599,28,21,817,1422,1594,393,1419,1420,1423,1418,1421,1135,349,1359,452,780,113,766,265,24,11,439,1574,9,10,207,542,1067,1245,585,674,770,330,404,1272,455,974,124,1455,1460,792,1215,553,797,5,739,871,116,573,1572,25,3,520,855,1607,14,78,711,1193,340,434,1021,1302,1402,253,1586,390,1284,748,1172,43,559,580,1581,462,765,285,791,1320,1323,874,658,405,1139,590,678,286,582,883,119,327,526,731,859,970,454,854,406,81,823,610,722,850,1236,1027,1569,114,993,1348,1319,1415,1614,30,31,34,35,36,37,38,82,378,403,1008,1012,1326,1327,1678,39,160,333,547,1330,451,1205,1325,163,348,351,784,966,1454,338,657,84,262,701,1575,325,521,683,1143,732,287,352,1318,4,111,508,1088,1108,1151,1157,1471,1579,389,1032,1075,1134,1367,290,314,751,1214,1233,1308,335,1145,1223,1345,93,1013,1321,1405,162,1137,1344,1376,291,394,483,651,673,1144,1343,1587,45,852,1604,545,988,1149,1452,1453,1615,152,401,1025,1090,1095,1136,1283,1724,98,441,882,968,1168,1243,1373,1413,626,716,768,1163,1301,1398,59,148,149,150,769,986,1382,1417,1492,1526,75,151,639,669,905,1150,1176,1226,1292,1448,201,1449,324,776,973,1647,223,417,601,616,837,996,1241,1458,1552,1602,108,313,467,1026,1411,266,341,857,1231,1489,954,1029,1034,1285,1366,1496,1609,1711,74,421,666,704,851,1055,1152,1362,1368,1372,480,885,1230,1260,1384,1516,105,147,574,888,1383,1408,1470,1628,1717,503,790,1054,1154,1208,1224,1518,749,1505,1571,208,1672,205,332,494,652,796,884,1253,1501,1521,1611,422,618,811,818,836,985,1148,123,493,1068,1486,1517,1522,1632,204,212,423,937,938,1409,1612,1682,448,485,1138,1593,1639,994,995,1410,66,972,1141,375,1017,1303,1461,1539,1627,1064,1601,420,1073,1437,1514,1028,1229,1254,1481,1515,1613,1716,453,487,665,1259,1412,1684,1175,1189,1262,1619,70,717,795,958,1159,1713,1715,775,1053,1266,1439,1714,715,738,1011,1240,1704,1274,1606,69,419,1106,1110,1192,1360,1361,1385,1459,944,1183,1184,1347,808,1058,1089,1338,1339,1342,1474,1543,1545,1160,1195,1322,1708,62,488,798,886,1071,1298,1311,1404,1723,225,1158,1310,1645,1649,1697,1729,17,299,300,997,1043,1087,1132,1355,1358,1451,1629,479,672,821,1023,1063,1217,1257,1312,1540,288,555,692,707,1047,1109,1140,1282,1329,1350,1426,1546') 0.025712013244629
(888) DESCRIBE `cruisetypes` 0.0010612010955811
(889) DESCRIBE `destinations` 0.00092101097106934
(890) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '22', '54', '35', '37', '2', '25', '9', '43', '8', '39', '53', '28', '26', '55', '11', '21', '38', '40', '49', '7', '44', '48', '30', '29', '10', '56', '45', '34', '52', '46', '32')) ORDER BY FIND_IN_SET(id, '50,12,22,54,35,37,2,25,9,43,8,39,53,28,26,55,11,21,38,40,49,7,44,48,30,29,10,56,45,34,52,46,32') 0.0012528896331787