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

Total elapsed time: 0.27102422714233

# Query Time
(1) connect 0.00055813789367676
(2) DESCRIBE `cruises` 0.0017900466918945
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (66955, 66996, 66997, 60589, 66998, 66999, 66001, 38689, 25176, 38690)) ORDER BY FIND_IN_SET(id, '66955,66996,66997,60589,66998,66999,66001,38689,25176,38690') 0.00089693069458008
(4) DESCRIBE `cruises` 0.0012462139129639
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66955') 0.0001978874206543
(6) DESCRIBE `ships` 0.001230001449585
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00031113624572754
(8) DESCRIBE `ships` 0.0012109279632568
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00018501281738281
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017619132995605
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019192695617676
(12) DESCRIBE `itineraries` 0.00068283081054688
(13) DESCRIBE `ports` 0.00068211555480957
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00022196769714355
(15) DESCRIBE `ports` 0.00084400177001953
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00023221969604492
(17) DESCRIBE `ports` 0.00067591667175293
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0001828670501709
(19) DESCRIBE `sailingdates` 0.000640869140625
(20) DESCRIBE `ports` 0.00068020820617676
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0002129077911377
(22) DESCRIBE `ports` 0.00072002410888672
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00021600723266602
(24) DESCRIBE `ports` 0.00064802169799805
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00020503997802734
(26) DESCRIBE `ports` 0.00065398216247559
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.0001838207244873
(28) DESCRIBE `ports` 0.00064492225646973
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00020599365234375
(30) DESCRIBE `ports` 0.00065112113952637
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00017619132995605
(32) DESCRIBE `ports` 0.00066304206848145
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 370))) 0.0002281665802002
(34) DESCRIBE `ports` 0.00064396858215332
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '370') 0.00017499923706055
(36) DESCRIBE `ports` 0.00063896179199219
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00019598007202148
(38) DESCRIBE `ports` 0.000640869140625
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00018310546875
(40) DESCRIBE `ports` 0.00066089630126953
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00019693374633789
(42) DESCRIBE `ports` 0.00064277648925781
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00025582313537598
(44) DESCRIBE `ports` 0.00064897537231445
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00020408630371094
(46) DESCRIBE `ports` 0.00067806243896484
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018405914306641
(48) DESCRIBE `avid_specials` 0.00059080123901367
(49) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66955 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 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.00096893310546875
(50) DESCRIBE `cruiselines` 0.00098299980163574
(51) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00021815299987793
(52) DESCRIBE `orchid_image` 0.00075101852416992
(53) DESCRIBE `cruiselines` 0.00099396705627441
(54) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00020289421081543
(55) DESCRIBE `cruises` 0.0012490749359131
(56) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66996') 0.00020480155944824
(57) DESCRIBE `ships` 0.0012240409851074
(58) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.0002439022064209
(59) DESCRIBE `ships` 0.0012249946594238
(60) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00018119812011719
(61) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001838207244873
(62) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016498565673828
(63) DESCRIBE `itineraries` 0.00063800811767578
(64) DESCRIBE `ports` 0.00068092346191406
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00020408630371094
(66) DESCRIBE `ports` 0.00065517425537109
(67) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00019216537475586
(68) DESCRIBE `ports` 0.00065207481384277
(69) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018596649169922
(70) DESCRIBE `sailingdates` 0.00061488151550293
(71) DESCRIBE `ports` 0.00068497657775879
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00022602081298828
(73) DESCRIBE `ports` 0.0006709098815918
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00020408630371094
(75) DESCRIBE `ports` 0.00068116188049316
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00021505355834961
(77) DESCRIBE `ports` 0.00067710876464844
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00018215179443359
(79) DESCRIBE `ports` 0.0006711483001709
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00020813941955566
(81) DESCRIBE `ports` 0.00065708160400391
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00018215179443359
(83) DESCRIBE `ports` 0.00068306922912598
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00020599365234375
(85) DESCRIBE `ports` 0.00068807601928711
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00018191337585449
(87) DESCRIBE `ports` 0.00066280364990234
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00021004676818848
(89) DESCRIBE `ports` 0.00068902969360352
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00018215179443359
(91) DESCRIBE `ports` 0.0006561279296875
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00022506713867188
(93) DESCRIBE `ports` 0.0006568431854248
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00017905235290527
(95) DESCRIBE `ports` 0.0006709098815918
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00019717216491699
(97) DESCRIBE `ports` 0.00074887275695801
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018000602722168
(99) DESCRIBE `avid_specials` 0.00059700012207031
(100) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66996 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 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.0011208057403564
(101) DESCRIBE `cruiselines` 0.0010299682617188
(102) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00020694732666016
(103) DESCRIBE `orchid_image` 0.00074505805969238
(104) DESCRIBE `cruiselines` 0.00089383125305176
(105) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00017213821411133
(106) DESCRIBE `cruises` 0.0012240409851074
(107) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66997') 0.00018596649169922
(108) DESCRIBE `ships` 0.0012340545654297
(109) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00023698806762695
(110) DESCRIBE `ships` 0.0013000965118408
(111) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00017905235290527
(112) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017499923706055
(113) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017809867858887
(114) DESCRIBE `itineraries` 0.00063896179199219
(115) DESCRIBE `ports` 0.00065803527832031
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00021910667419434
(117) DESCRIBE `ports` 0.00064492225646973
(118) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00018000602722168
(119) DESCRIBE `ports` 0.00072789192199707
(120) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018095970153809
(121) DESCRIBE `sailingdates` 0.00058412551879883
(122) DESCRIBE `ports` 0.00066184997558594
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00020813941955566
(124) DESCRIBE `ports` 0.0006561279296875
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00017595291137695
(126) DESCRIBE `ports` 0.00065493583679199
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00020599365234375
(128) DESCRIBE `ports` 0.00067400932312012
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00018906593322754
(130) DESCRIBE `ports` 0.00066494941711426
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00021195411682129
(132) DESCRIBE `ports` 0.00064611434936523
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00017595291137695
(134) DESCRIBE `ports` 0.00070285797119141
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1122))) 0.00020694732666016
(136) DESCRIBE `ports` 0.00069689750671387
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1122') 0.00018906593322754
(138) DESCRIBE `ports` 0.00065302848815918
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.0002129077911377
(140) DESCRIBE `ports` 0.0007469654083252
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00017499923706055
(142) DESCRIBE `ports` 0.0009000301361084
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00025105476379395
(144) DESCRIBE `ports` 0.00071001052856445
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00018787384033203
(146) DESCRIBE `ports` 0.00065994262695312
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00020194053649902
(148) DESCRIBE `ports` 0.000701904296875
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00017404556274414
(150) DESCRIBE `ports` 0.0006711483001709
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00020003318786621
(152) DESCRIBE `ports` 0.00065302848815918
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018310546875
(154) DESCRIBE `avid_specials` 0.00059390068054199
(155) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66997 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 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.0010030269622803
(156) DESCRIBE `cruiselines` 0.00094509124755859
(157) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00020980834960938
(158) DESCRIBE `orchid_image` 0.00076794624328613
(159) DESCRIBE `cruiselines` 0.00099706649780273
(160) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00018501281738281
(161) DESCRIBE `cruises` 0.001209020614624
(162) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '60589') 0.00018692016601562
(163) DESCRIBE `ships` 0.0013148784637451
(164) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00024700164794922
(165) DESCRIBE `ships` 0.0012199878692627
(166) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00018715858459473
(167) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017905235290527
(168) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016212463378906
(169) DESCRIBE `itineraries` 0.00063419342041016
(170) DESCRIBE `ports` 0.0006709098815918
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00020217895507812
(172) DESCRIBE `ports` 0.00064492225646973
(173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00018787384033203
(174) DESCRIBE `ports` 0.00064802169799805
(175) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018405914306641
(176) DESCRIBE `sailingdates` 0.00057411193847656
(177) DESCRIBE `ports` 0.00070095062255859
(178) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00021219253540039
(179) DESCRIBE `ports` 0.00067687034606934
(180) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00017404556274414
(181) DESCRIBE `ports` 0.00064802169799805
(182) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00019192695617676
(183) DESCRIBE `ports` 0.00063896179199219
(184) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.0001828670501709
(185) DESCRIBE `ports` 0.00065302848815918
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00019717216491699
(187) DESCRIBE `ports` 0.00064802169799805
(188) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00017285346984863
(189) DESCRIBE `ports` 0.00064206123352051
(190) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00018906593322754
(191) DESCRIBE `ports` 0.00070309638977051
(192) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00017189979553223
(193) DESCRIBE `ports` 0.00064492225646973
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1106))) 0.00019693374633789
(195) DESCRIBE `ports` 0.00064611434936523
(196) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1106') 0.00017595291137695
(197) DESCRIBE `ports` 0.00066208839416504
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00019717216491699
(199) DESCRIBE `ports` 0.00064301490783691
(200) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00017404556274414
(201) DESCRIBE `avid_specials` 0.000579833984375
(202) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 60589 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 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.00095677375793457
(203) DESCRIBE `cruiselines` 0.0009009838104248
(204) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00020503997802734
(205) DESCRIBE `orchid_image` 0.00072002410888672
(206) DESCRIBE `cruiselines` 0.00089406967163086
(207) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00017213821411133
(208) DESCRIBE `cruises` 0.0011699199676514
(209) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66998') 0.00017905235290527
(210) DESCRIBE `ships` 0.0013370513916016
(211) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00023913383483887
(212) DESCRIBE `ships` 0.0012149810791016
(213) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00021195411682129
(214) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002129077911377
(215) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001981258392334
(216) DESCRIBE `itineraries` 0.00081205368041992
(217) DESCRIBE `ports` 0.00069093704223633
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0001988410949707
(219) DESCRIBE `ports` 0.00064587593078613
(220) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00019598007202148
(221) DESCRIBE `ports` 0.00064396858215332
(222) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018692016601562
(223) DESCRIBE `sailingdates` 0.00058603286743164
(224) DESCRIBE `ports` 0.00065493583679199
(225) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00020694732666016
(226) DESCRIBE `ports` 0.00069594383239746
(227) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00017595291137695
(228) DESCRIBE `ports` 0.00064897537231445
(229) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00019693374633789
(230) DESCRIBE `ports` 0.000640869140625
(231) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00017404556274414
(232) DESCRIBE `ports` 0.00068902969360352
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00019288063049316
(234) DESCRIBE `ports` 0.00064206123352051
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00017404556274414
(236) DESCRIBE `ports` 0.00064802169799805
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00019097328186035
(238) DESCRIBE `ports` 0.00070810317993164
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00017309188842773
(240) DESCRIBE `ports` 0.00067400932312012
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.0002598762512207
(242) DESCRIBE `ports` 0.0007939338684082
(243) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00022506713867188
(244) DESCRIBE `ports` 0.00081205368041992
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00022006034851074
(246) DESCRIBE `ports` 0.00078105926513672
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00020098686218262
(248) DESCRIBE `ports` 0.00083589553833008
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00022506713867188
(250) DESCRIBE `ports` 0.00085997581481934
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00022101402282715
(252) DESCRIBE `avid_specials` 0.00081396102905273
(253) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66998 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 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.0010161399841309
(254) DESCRIBE `cruiselines` 0.00093984603881836
(255) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00022101402282715
(256) DESCRIBE `orchid_image` 0.00075793266296387
(257) DESCRIBE `cruiselines` 0.00088691711425781
(258) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00017690658569336
(259) DESCRIBE `cruises` 0.0012860298156738
(260) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66999') 0.00020503997802734
(261) DESCRIBE `ships` 0.0013988018035889
(262) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00026917457580566
(263) DESCRIBE `ships` 0.0012199878692627
(264) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00018095970153809
(265) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017285346984863
(266) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016307830810547
(267) DESCRIBE `itineraries` 0.00072002410888672
(268) DESCRIBE `ports` 0.00065803527832031
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00020098686218262
(270) DESCRIBE `ports` 0.00065779685974121
(271) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00021195411682129
(272) DESCRIBE `ports` 0.00065088272094727
(273) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00017499923706055
(274) DESCRIBE `sailingdates` 0.00058293342590332
(275) DESCRIBE `ports` 0.00065302848815918
(276) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00019407272338867
(277) DESCRIBE `ports` 0.00064682960510254
(278) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00018095970153809
(279) DESCRIBE `ports` 0.00064897537231445
(280) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00019192695617676
(281) DESCRIBE `ports` 0.00067019462585449
(282) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00017309188842773
(283) DESCRIBE `ports` 0.00065493583679199
(284) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00020217895507812
(285) DESCRIBE `ports` 0.00064897537231445
(286) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00018405914306641
(287) DESCRIBE `ports` 0.00066685676574707
(288) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 628))) 0.00021004676818848
(289) DESCRIBE `ports` 0.00068092346191406
(290) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '628') 0.00017189979553223
(291) DESCRIBE `ports` 0.00065302848815918
(292) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00020503997802734
(293) DESCRIBE `ports` 0.00067305564880371
(294) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00016903877258301
(295) DESCRIBE `ports` 0.00065088272094727
(296) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0001990795135498
(297) DESCRIBE `ports` 0.00065708160400391
(298) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00018811225891113
(299) DESCRIBE `avid_specials` 0.00058579444885254
(300) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66999 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 38 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.0019590854644775
(301) DESCRIBE `cruiselines` 0.0017030239105225
(302) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00030303001403809
(303) DESCRIBE `orchid_image` 0.0011448860168457
(304) DESCRIBE `cruiselines` 0.0010509490966797
(305) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.0001828670501709
(306) DESCRIBE `cruises` 0.0012710094451904
(307) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66001') 0.0001990795135498
(308) DESCRIBE `ships` 0.0012450218200684
(309) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00023984909057617
(310) DESCRIBE `ships` 0.0012619495391846
(311) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00018596649169922
(312) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017786026000977
(313) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016593933105469
(314) DESCRIBE `itineraries` 0.0006718635559082
(315) DESCRIBE `ports` 0.00067496299743652
(316) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00020480155944824
(317) DESCRIBE `ports` 0.00065398216247559
(318) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00019598007202148
(319) DESCRIBE `ports` 0.00067710876464844
(320) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00017905235290527
(321) DESCRIBE `sailingdates` 0.00058317184448242
(322) DESCRIBE `ports` 0.0006558895111084
(323) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00019693374633789
(324) DESCRIBE `ports` 0.00068497657775879
(325) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00017905235290527
(326) DESCRIBE `ports` 0.00065302848815918
(327) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 414))) 0.00020813941955566
(328) DESCRIBE `ports` 0.00065112113952637
(329) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '414') 0.00017595291137695
(330) DESCRIBE `ports` 0.00066900253295898
(331) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 170))) 0.00019383430480957
(332) DESCRIBE `ports` 0.00064897537231445
(333) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '170') 0.00017905235290527
(334) DESCRIBE `ports` 0.00065112113952637
(335) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 346))) 0.00019192695617676
(336) DESCRIBE `ports` 0.00076389312744141
(337) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '346') 0.00017714500427246
(338) DESCRIBE `ports` 0.00065398216247559
(339) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.0001978874206543
(340) DESCRIBE `ports` 0.0006868839263916
(341) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00017499923706055
(342) DESCRIBE `ports` 0.0006568431854248
(343) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.0001990795135498
(344) DESCRIBE `ports` 0.00066113471984863
(345) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.00017809867858887
(346) DESCRIBE `ports` 0.00067615509033203
(347) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00023388862609863
(348) DESCRIBE `ports` 0.00066018104553223
(349) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00018215179443359
(350) DESCRIBE `avid_specials` 0.00060391426086426
(351) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66001 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 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.00097393989562988
(352) DESCRIBE `cruiselines` 0.0010311603546143
(353) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00024294853210449
(354) DESCRIBE `orchid_image` 0.00077104568481445
(355) DESCRIBE `cruiselines` 0.00095105171203613
(356) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00018906593322754
(357) DESCRIBE `cruises` 0.0012569427490234
(358) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '38689') 0.00024604797363281
(359) DESCRIBE `ships` 0.0012609958648682
(360) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00025486946105957
(361) DESCRIBE `ships` 0.0012738704681396
(362) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00018692016601562
(363) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018000602722168
(364) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001678466796875
(365) DESCRIBE `itineraries` 0.00066184997558594
(366) DESCRIBE `ports` 0.00075006484985352
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00021815299987793
(368) DESCRIBE `ports` 0.00069499015808105
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00020003318786621
(370) DESCRIBE `ports` 0.00069713592529297
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00018596649169922
(372) DESCRIBE `sailingdates` 0.0006108283996582
(373) DESCRIBE `ports` 0.00066399574279785
(374) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00020790100097656
(375) DESCRIBE `ports` 0.00068306922912598
(376) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00018405914306641
(377) DESCRIBE `ports` 0.00066018104553223
(378) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 96))) 0.0001988410949707
(379) DESCRIBE `ports` 0.00066304206848145
(380) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '96') 0.00017809867858887
(381) DESCRIBE `ports` 0.0006871223449707
(382) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 165))) 0.00020003318786621
(383) DESCRIBE `ports` 0.00066304206848145
(384) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '165') 0.00017404556274414
(385) DESCRIBE `ports` 0.00067305564880371
(386) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 169))) 0.00019693374633789
(387) DESCRIBE `ports` 0.00067901611328125
(388) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '169') 0.00017809867858887
(389) DESCRIBE `ports` 0.00066208839416504
(390) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2863))) 0.00020599365234375
(391) DESCRIBE `ports` 0.00073504447937012
(392) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2863') 0.00023508071899414
(393) DESCRIBE `ports` 0.00067901611328125
(394) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 357))) 0.00019693374633789
(395) DESCRIBE `ports` 0.00066399574279785
(396) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '357') 0.00017881393432617
(397) DESCRIBE `ports` 0.00065994262695312
(398) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2131))) 0.00020503997802734
(399) DESCRIBE `ports` 0.00067281723022461
(400) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2131') 0.00017809867858887
(401) DESCRIBE `ports` 0.00066614151000977
(402) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.00019311904907227
(403) DESCRIBE `ports` 0.00068497657775879
(404) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.00017404556274414
(405) DESCRIBE `ports` 0.00066089630126953
(406) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00020813941955566
(407) DESCRIBE `ports` 0.00066184997558594
(408) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00018405914306641
(409) DESCRIBE `avid_specials` 0.00061607360839844
(410) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 38689 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 48 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.0009760856628418
(411) DESCRIBE `cruiselines` 0.00095295906066895
(412) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00021791458129883
(413) DESCRIBE `orchid_image` 0.00078892707824707
(414) DESCRIBE `cruiselines` 0.00090384483337402
(415) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00017690658569336
(416) DESCRIBE `cruises` 0.0014028549194336
(417) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '25176') 0.00018811225891113
(418) DESCRIBE `ships` 0.0012869834899902
(419) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00029182434082031
(420) DESCRIBE `ships` 0.0012569427490234
(421) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00018811225891113
(422) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018095970153809
(423) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016903877258301
(424) DESCRIBE `itineraries` 0.0006709098815918
(425) DESCRIBE `ports` 0.00068902969360352
(426) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00020790100097656
(427) DESCRIBE `ports` 0.00067520141601562
(428) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00024318695068359
(429) DESCRIBE `ports` 0.0006709098815918
(430) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00018000602722168
(431) DESCRIBE `sailingdates` 0.00060009956359863
(432) DESCRIBE `ports` 0.00070810317993164
(433) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00020384788513184
(434) DESCRIBE `ports` 0.00066995620727539
(435) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00018000602722168
(436) DESCRIBE `ports` 0.00066900253295898
(437) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 166))) 0.0001981258392334
(438) DESCRIBE `ports` 0.00069093704223633
(439) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '166') 0.00018000602722168
(440) DESCRIBE `ports` 0.00066304206848145
(441) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2148))) 0.00020003318786621
(442) DESCRIBE `ports` 0.00066399574279785
(443) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2148') 0.00017905235290527
(444) DESCRIBE `ports` 0.00072193145751953
(445) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.00019311904907227
(446) DESCRIBE `ports` 0.00066113471984863
(447) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.00017499923706055
(448) DESCRIBE `ports` 0.00066399574279785
(449) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00027203559875488
(450) DESCRIBE `ports` 0.00066614151000977
(451) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00018000602722168
(452) DESCRIBE `avid_specials` 0.00059914588928223
(453) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 25176 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 53 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.000946044921875
(454) DESCRIBE `cruiselines` 0.00096702575683594
(455) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00021886825561523
(456) DESCRIBE `orchid_image` 0.00075602531433105
(457) DESCRIBE `cruiselines` 0.00094103813171387
(458) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00018000602722168
(459) DESCRIBE `cruises` 0.0012369155883789
(460) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '38690') 0.00020003318786621
(461) DESCRIBE `ships` 0.0012631416320801
(462) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00024795532226562
(463) DESCRIBE `ships` 0.0012338161468506
(464) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00018620491027832
(465) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017905235290527
(466) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016880035400391
(467) DESCRIBE `itineraries` 0.0006561279296875
(468) DESCRIBE `ports` 0.00072312355041504
(469) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00020885467529297
(470) DESCRIBE `ports` 0.00067281723022461
(471) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00019598007202148
(472) DESCRIBE `ports` 0.00066304206848145
(473) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00019192695617676
(474) DESCRIBE `sailingdates` 0.00064301490783691
(475) DESCRIBE `ports` 0.00067996978759766
(476) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00020909309387207
(477) DESCRIBE `ports` 0.00067400932312012
(478) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.0001978874206543
(479) DESCRIBE `ports` 0.00066900253295898
(480) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.00019502639770508
(481) DESCRIBE `ports` 0.00066590309143066
(482) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.00018119812011719
(483) DESCRIBE `ports` 0.0006709098815918
(484) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2131))) 0.00020408630371094
(485) DESCRIBE `ports` 0.00067496299743652
(486) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2131') 0.00018310546875
(487) DESCRIBE `ports` 0.00068187713623047
(488) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 357))) 0.00020194053649902
(489) DESCRIBE `ports` 0.00068092346191406
(490) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '357') 0.00018215179443359
(491) DESCRIBE `ports` 0.0006721019744873
(492) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 615))) 0.00021696090698242
(493) DESCRIBE `ports` 0.0007479190826416
(494) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '615') 0.00019097328186035
(495) DESCRIBE `ports` 0.00072002410888672
(496) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 169))) 0.00020408630371094
(497) DESCRIBE `ports` 0.0006709098815918
(498) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '169') 0.00018000602722168
(499) DESCRIBE `ports` 0.00067996978759766
(500) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 165))) 0.0001988410949707
(501) DESCRIBE `ports` 0.00067996978759766
(502) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '165') 0.00017619132995605
(503) DESCRIBE `ports` 0.00066590309143066
(504) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 96))) 0.00020003318786621
(505) DESCRIBE `ports` 0.00072908401489258
(506) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '96') 0.00018095970153809
(507) DESCRIBE `ports` 0.00066995620727539
(508) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00020217895507812
(509) DESCRIBE `ports` 0.00069403648376465
(510) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00018310546875
(511) DESCRIBE `avid_specials` 0.00060582160949707
(512) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 38690 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 48 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.00095295906066895
(513) DESCRIBE `cruiselines` 0.00096511840820312
(514) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00022006034851074
(515) DESCRIBE `orchid_image` 0.00079703330993652
(516) DESCRIBE `cruiselines` 0.00091695785522461
(517) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00019001960754395
(518) DESCRIBE `cruisetypes` 0.00064992904663086
(519) DESCRIBE `destinations` 0.000885009765625
(520) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '53', '37', '48', '12', '38')) ORDER BY FIND_IN_SET(id, '22,53,37,48,12,38') 0.00049710273742676
(521) DESCRIBE `cruiselines` 0.00095391273498535
(522) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00022602081298828
(523) DESCRIBE `ships` 0.0012857913970947
(524) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00024199485778809
(525) DESCRIBE `cruiselines` 0.0012209415435791
(526) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.0002448558807373
(527) DESCRIBE `ships` 0.0014970302581787
(528) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00022983551025391