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

Total elapsed time: 0.37651634216309

# Query Time
(1) connect 0.0006859302520752
(2) DESCRIBE `cruises` 0.0018429756164551
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (21382, 28851, 41313, 41693, 59439, 62667, 64091, 64966, 65672, 65744)) ORDER BY FIND_IN_SET(id, '21382,28851,41313,41693,59439,62667,64091,64966,65672,65744') 0.00130295753479
(4) DESCRIBE `cruises` 0.0015518665313721
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '21382') 0.00028109550476074
(6) DESCRIBE `ships` 0.0016229152679443
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 14))) 0.00030899047851562
(8) DESCRIBE `ships` 0.0017490386962891
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '14') 0.00022411346435547
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0002140998840332
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00020003318786621
(12) DESCRIBE `itineraries` 0.00085687637329102
(13) DESCRIBE `ports` 0.00073909759521484
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 268))) 0.00022292137145996
(15) DESCRIBE `ports` 0.00068116188049316
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 268))) 0.00020194053649902
(17) DESCRIBE `ports` 0.00072193145751953
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '268') 0.00018692016601562
(19) DESCRIBE `sailingdates` 0.00060796737670898
(20) DESCRIBE `ports` 0.00076889991760254
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 268))) 0.00020503997802734
(22) DESCRIBE `ports` 0.0007779598236084
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '268') 0.00018501281738281
(24) DESCRIBE `ports` 0.0006709098815918
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 268))) 0.00020408630371094
(26) DESCRIBE `ports` 0.00066494941711426
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '268') 0.00018811225891113
(28) DESCRIBE `ports` 0.00069594383239746
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 259))) 0.00020098686218262
(30) DESCRIBE `ports` 0.00076603889465332
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '259') 0.00018310546875
(32) DESCRIBE `ports` 0.00067019462585449
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 259))) 0.00021195411682129
(34) DESCRIBE `ports` 0.00066399574279785
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '259') 0.00018191337585449
(36) DESCRIBE `ports` 0.000762939453125
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 259))) 0.0001988410949707
(38) DESCRIBE `ports` 0.00066113471984863
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '259') 0.0001838207244873
(40) DESCRIBE `ports` 0.00066304206848145
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 259))) 0.00020384788513184
(42) DESCRIBE `ports` 0.00070905685424805
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '259') 0.00018095970153809
(44) DESCRIBE `ports` 0.00065898895263672
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1161))) 0.00023603439331055
(46) DESCRIBE `ports` 0.00065898895263672
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1161') 0.00018191337585449
(48) DESCRIBE `ports` 0.00076603889465332
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 259))) 0.00021982192993164
(50) DESCRIBE `ports` 0.00069403648376465
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '259') 0.00018191337585449
(52) DESCRIBE `ports` 0.00065898895263672
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 268))) 0.0001978874206543
(54) DESCRIBE `ports` 0.00065994262695312
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '268') 0.00018095970153809
(56) DESCRIBE `ports` 0.000762939453125
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 268))) 0.00020194053649902
(58) DESCRIBE `ports` 0.00066184997558594
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '268') 0.00018191337585449
(60) DESCRIBE `ports` 0.00071215629577637
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 259))) 0.0001981258392334
(62) DESCRIBE `ports` 0.00065994262695312
(63) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '259') 0.00018000602722168
(64) DESCRIBE `ports` 0.00066113471984863
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 259))) 0.00020313262939453
(66) DESCRIBE `ports` 0.00066709518432617
(67) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '259') 0.00019383430480957
(68) DESCRIBE `ports` 0.00068211555480957
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1160))) 0.00020098686218262
(70) DESCRIBE `ports` 0.00067400932312012
(71) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1160') 0.00018191337585449
(72) DESCRIBE `ports` 0.00065302848815918
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1160))) 0.00021004676818848
(74) DESCRIBE `ports` 0.00065398216247559
(75) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1160') 0.00024294853210449
(76) DESCRIBE `ports` 0.00075101852416992
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 268))) 0.00022792816162109
(78) DESCRIBE `ports` 0.00072789192199707
(79) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '268') 0.00034189224243164
(80) DESCRIBE `ports` 0.0007929801940918
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 268))) 0.00030183792114258
(82) DESCRIBE `ports` 0.0010859966278076
(83) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '268') 0.00033187866210938
(84) DESCRIBE `avid_specials` 0.0010859966278076
(85) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 21382 and class = 'Cruise') OR (item_id = 14 AND class = 'Ship') OR (item_id = 35 AND class = 'CruiseLine') OR (item_id = 46 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.0010149478912354
(86) DESCRIBE `cruiselines` 0.0010750293731689
(87) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 35))) 0.0002140998840332
(88) DESCRIBE `orchid_image` 0.00080704689025879
(89) DESCRIBE `cruiselines` 0.00095009803771973
(90) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '35') 0.00018310546875
(91) DESCRIBE `cruises` 0.0022709369659424
(92) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '28851') 0.00023603439331055
(93) DESCRIBE `ships` 0.0014069080352783
(94) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 70))) 0.00031495094299316
(95) DESCRIBE `ships` 0.0019059181213379
(96) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '70') 0.00023698806762695
(97) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028014183044434
(98) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016999244689941
(99) DESCRIBE `itineraries` 0.00066399574279785
(100) DESCRIBE `ports` 0.00068497657775879
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00023317337036133
(102) DESCRIBE `ports` 0.00066113471984863
(103) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00020217895507812
(104) DESCRIBE `ports` 0.00065398216247559
(105) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00017809867858887
(106) DESCRIBE `sailingdates` 0.00059890747070312
(107) DESCRIBE `ports` 0.00068497657775879
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00020718574523926
(109) DESCRIBE `ports` 0.00066804885864258
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00018501281738281
(111) DESCRIBE `ports` 0.00066995620727539
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 58))) 0.00020098686218262
(113) DESCRIBE `ports` 0.00066494941711426
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '58') 0.00018215179443359
(115) DESCRIBE `ports` 0.00066280364990234
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00019693374633789
(117) DESCRIBE `ports` 0.00065994262695312
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00018000602722168
(119) DESCRIBE `ports` 0.00065207481384277
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00021004676818848
(121) DESCRIBE `ports` 0.00066614151000977
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00018811225891113
(123) DESCRIBE `ports` 0.00064992904663086
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00020313262939453
(125) DESCRIBE `ports` 0.00064802169799805
(126) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00017404556274414
(127) DESCRIBE `ports` 0.00067996978759766
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.0001990795135498
(129) DESCRIBE `ports` 0.0006561279296875
(130) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00017690658569336
(131) DESCRIBE `avid_specials` 0.00059700012207031
(132) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 28851 and class = 'Cruise') OR (item_id = 70 AND class = 'Ship') OR (item_id = 16 AND class = 'CruiseLine') OR (item_id = 2 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00097298622131348
(133) DESCRIBE `cruiselines` 0.00095009803771973
(134) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 16))) 0.00021481513977051
(135) DESCRIBE `orchid_image` 0.00073599815368652
(136) DESCRIBE `cruiselines` 0.00091409683227539
(137) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '16') 0.00017094612121582
(138) DESCRIBE `cruises` 0.0012500286102295
(139) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '41313') 0.00019407272338867
(140) DESCRIBE `ships` 0.001262903213501
(141) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1064))) 0.00022697448730469
(142) DESCRIBE `ships` 0.001270055770874
(143) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1064') 0.00017499923706055
(144) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017499923706055
(145) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016117095947266
(146) DESCRIBE `itineraries` 0.00065898895263672
(147) DESCRIBE `ports` 0.00067782402038574
(148) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00021910667419434
(149) DESCRIBE `ports` 0.00066399574279785
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00019192695617676
(151) DESCRIBE `ports` 0.00065493583679199
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00017380714416504
(153) DESCRIBE `sailingdates` 0.00059318542480469
(154) DESCRIBE `ports` 0.00069713592529297
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00019001960754395
(156) DESCRIBE `ports` 0.00066399574279785
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00017690658569336
(158) DESCRIBE `ports` 0.00066018104553223
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2673))) 0.00020313262939453
(160) DESCRIBE `ports` 0.00065708160400391
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2673') 0.00017309188842773
(162) DESCRIBE `ports` 0.00065398216247559
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4086))) 0.00021195411682129
(164) DESCRIBE `ports` 0.00065708160400391
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4086') 0.00017189979553223
(166) DESCRIBE `ports` 0.00065994262695312
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4088))) 0.00021600723266602
(168) DESCRIBE `ports` 0.00066494941711426
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4088') 0.00016903877258301
(170) DESCRIBE `ports` 0.00065302848815918
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4087))) 0.00018906593322754
(172) DESCRIBE `ports` 0.0006558895111084
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4087') 0.00018191337585449
(174) DESCRIBE `ports` 0.00081014633178711
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00054597854614258
(176) DESCRIBE `ports` 0.0013830661773682
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00033783912658691
(178) DESCRIBE `ports` 0.0015058517456055
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00045418739318848
(180) DESCRIBE `ports` 0.0017058849334717
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00040483474731445
(182) DESCRIBE `ports` 0.0016908645629883
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00046896934509277
(184) DESCRIBE `ports` 0.0015718936920166
(185) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00031089782714844
(186) DESCRIBE `avid_specials` 0.0010828971862793
(187) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 41313 and class = 'Cruise') OR (item_id = 1064 AND class = 'Ship') OR (item_id = 144 AND class = 'CruiseLine') OR (item_id = 50 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0016169548034668
(188) DESCRIBE `cruiselines` 0.0024049282073975
(189) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00043296813964844
(190) DESCRIBE `orchid_image` 0.001568078994751
(191) DESCRIBE `cruiselines` 0.0016100406646729
(192) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00043582916259766
(193) DESCRIBE `cruises` 0.0025770664215088
(194) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '41693') 0.00041294097900391
(195) DESCRIBE `ships` 0.002310037612915
(196) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 207))) 0.00044989585876465
(197) DESCRIBE `ships` 0.0022399425506592
(198) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '207') 0.00032591819763184
(199) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00030207633972168
(200) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00028395652770996
(201) DESCRIBE `itineraries` 0.001162052154541
(202) DESCRIBE `ports` 0.0012469291687012
(203) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00020599365234375
(204) DESCRIBE `ports` 0.00066208839416504
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00019717216491699
(206) DESCRIBE `ports` 0.00078415870666504
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00017595291137695
(208) DESCRIBE `sailingdates` 0.00060415267944336
(209) DESCRIBE `ports` 0.00071597099304199
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00021004676818848
(211) DESCRIBE `ports` 0.00067901611328125
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00020194053649902
(213) DESCRIBE `ports` 0.00068902969360352
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 263))) 0.00020313262939453
(215) DESCRIBE `ports` 0.00070095062255859
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '263') 0.00018000602722168
(217) DESCRIBE `ports` 0.00069093704223633
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 265))) 0.00020194053649902
(219) DESCRIBE `ports` 0.0006709098815918
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '265') 0.00022411346435547
(221) DESCRIBE `ports` 0.00087380409240723
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 266))) 0.00020408630371094
(223) DESCRIBE `ports` 0.00070714950561523
(224) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '266') 0.00018000602722168
(225) DESCRIBE `ports` 0.00075006484985352
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.0001988410949707
(227) DESCRIBE `ports` 0.00066995620727539
(228) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00018000602722168
(229) DESCRIBE `ports` 0.00067400932312012
(230) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 261))) 0.00023698806762695
(231) DESCRIBE `ports` 0.00076699256896973
(232) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '261') 0.00020098686218262
(233) DESCRIBE `ports` 0.00067901611328125
(234) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 262))) 0.00020098686218262
(235) DESCRIBE `ports` 0.00077414512634277
(236) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '262') 0.00050997734069824
(237) DESCRIBE `ports` 0.0014839172363281
(238) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 260))) 0.00034904479980469
(239) DESCRIBE `ports` 0.0011789798736572
(240) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '260') 0.00031805038452148
(241) DESCRIBE `ports` 0.001147985458374
(242) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00036406517028809
(243) DESCRIBE `ports` 0.0011708736419678
(244) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00032687187194824
(245) DESCRIBE `avid_specials` 0.0010509490966797
(246) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 41693 and class = 'Cruise') OR (item_id = 207 AND class = 'Ship') OR (item_id = 36 AND class = 'CruiseLine') OR (item_id = 8 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.001723051071167
(247) DESCRIBE `cruiselines` 0.0016250610351562
(248) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 36))) 0.0003969669342041
(249) DESCRIBE `orchid_image` 0.0013279914855957
(250) DESCRIBE `cruiselines` 0.0016109943389893
(251) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '36') 0.00032591819763184
(252) DESCRIBE `cruises` 0.0015521049499512
(253) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59439') 0.00028800964355469
(254) DESCRIBE `ships` 0.0014100074768066
(255) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1420))) 0.00034499168395996
(256) DESCRIBE `ships` 0.0021450519561768
(257) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1420') 0.00031399726867676
(258) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00029802322387695
(259) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00028204917907715
(260) DESCRIBE `itineraries` 0.0011260509490967
(261) DESCRIBE `ports` 0.0011770725250244
(262) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1204))) 0.00043606758117676
(263) DESCRIBE `ports` 0.0014908313751221
(264) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1204))) 0.00034499168395996
(265) DESCRIBE `ports` 0.0011651515960693
(266) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1204') 0.00041913986206055
(267) DESCRIBE `sailingdates` 0.0010528564453125
(268) DESCRIBE `ports` 0.00075793266296387
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1204))) 0.00022411346435547
(270) DESCRIBE `ports` 0.00067400932312012
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1204') 0.00019383430480957
(272) DESCRIBE `ports` 0.0006711483001709
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2204))) 0.00019979476928711
(274) DESCRIBE `ports` 0.00069403648376465
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2204') 0.00018000602722168
(276) DESCRIBE `ports` 0.00066208839416504
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2832))) 0.00020098686218262
(278) DESCRIBE `ports` 0.00067496299743652
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2832') 0.0001828670501709
(280) DESCRIBE `ports` 0.00068306922912598
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2831))) 0.00019717216491699
(282) DESCRIBE `ports` 0.00066614151000977
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2831') 0.00020003318786621
(284) DESCRIBE `ports` 0.00070905685424805
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2201))) 0.0002140998840332
(286) DESCRIBE `ports` 0.0007011890411377
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2201') 0.00018215179443359
(288) DESCRIBE `ports` 0.00066304206848145
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2203))) 0.00020098686218262
(290) DESCRIBE `ports` 0.00065898895263672
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2203') 0.00018596649169922
(292) DESCRIBE `ports` 0.0007321834564209
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2831))) 0.00019502639770508
(294) DESCRIBE `ports` 0.00066518783569336
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2831') 0.00017786026000977
(296) DESCRIBE `ports` 0.0006868839263916
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2832))) 0.00020599365234375
(298) DESCRIBE `ports` 0.0006709098815918
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2832') 0.0001838207244873
(300) DESCRIBE `ports` 0.00066590309143066
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2832))) 0.00019502639770508
(302) DESCRIBE `ports` 0.00075101852416992
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2832') 0.00019598007202148
(304) DESCRIBE `ports` 0.0006718635559082
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1204))) 0.00020480155944824
(306) DESCRIBE `ports` 0.00066494941711426
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1204') 0.00018501281738281
(308) DESCRIBE `avid_specials` 0.00060415267944336
(309) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59439 and class = 'Cruise') OR (item_id = 1420 AND class = 'Ship') OR (item_id = 31 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.00096416473388672
(310) DESCRIBE `cruiselines` 0.0009758472442627
(311) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 31))) 0.00025296211242676
(312) DESCRIBE `orchid_image` 0.00095701217651367
(313) DESCRIBE `cruiselines` 0.00094199180603027
(314) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '31') 0.00020408630371094
(315) DESCRIBE `cruises` 0.001255989074707
(316) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62667') 0.00022792816162109
(317) DESCRIBE `ships` 0.0012879371643066
(318) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 553))) 0.00025796890258789
(319) DESCRIBE `ships` 0.001244068145752
(320) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '553') 0.00018811225891113
(321) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019192695617676
(322) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017189979553223
(323) DESCRIBE `itineraries` 0.00066399574279785
(324) DESCRIBE `ports` 0.00077295303344727
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1622))) 0.00021505355834961
(326) DESCRIBE `ports` 0.00071406364440918
(327) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1622))) 0.00020599365234375
(328) DESCRIBE `ports` 0.0006718635559082
(329) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1622') 0.00018692016601562
(330) DESCRIBE `sailingdates` 0.00066900253295898
(331) DESCRIBE `ports` 0.00069499015808105
(332) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1622))) 0.00022196769714355
(333) DESCRIBE `ports` 0.00082898139953613
(334) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1622') 0.00051093101501465
(335) DESCRIBE `ports` 0.0014081001281738
(336) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 370))) 0.0003662109375
(337) DESCRIBE `ports` 0.0012669563293457
(338) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '370') 0.0004270076751709
(339) DESCRIBE `ports` 0.0017828941345215
(340) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00045895576477051
(341) DESCRIBE `ports` 0.0016000270843506
(342) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00040388107299805
(343) DESCRIBE `ports` 0.00071001052856445
(344) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.0002138614654541
(345) DESCRIBE `ports` 0.00068211555480957
(346) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.0001978874206543
(347) DESCRIBE `ports` 0.00066900253295898
(348) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00020909309387207
(349) DESCRIBE `ports` 0.00066494941711426
(350) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00018405914306641
(351) DESCRIBE `ports` 0.00066804885864258
(352) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00020408630371094
(353) DESCRIBE `ports` 0.00068283081054688
(354) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00022220611572266
(355) DESCRIBE `ports` 0.00066900253295898
(356) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00020194053649902
(357) DESCRIBE `ports` 0.0006711483001709
(358) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00020599365234375
(359) DESCRIBE `ports` 0.00076889991760254
(360) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1622))) 0.00021791458129883
(361) DESCRIBE `ports` 0.00076079368591309
(362) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1622') 0.00018978118896484
(363) DESCRIBE `avid_specials` 0.00061678886413574
(364) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62667 and class = 'Cruise') OR (item_id = 553 AND class = 'Ship') OR (item_id = 19 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.0011210441589355
(365) DESCRIBE `cruiselines` 0.001025915145874
(366) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00022101402282715
(367) DESCRIBE `orchid_image` 0.00076198577880859
(368) DESCRIBE `cruiselines` 0.00091004371643066
(369) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00018596649169922
(370) DESCRIBE `cruises` 0.0012538433074951
(371) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64091') 0.00019598007202148
(372) DESCRIBE `ships` 0.0012660026550293
(373) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1496))) 0.00028896331787109
(374) DESCRIBE `ships` 0.001276969909668
(375) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1496') 0.00020408630371094
(376) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00018501281738281
(377) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017118453979492
(378) DESCRIBE `itineraries` 0.00064802169799805
(379) DESCRIBE `ports` 0.00067615509033203
(380) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1592))) 0.00021195411682129
(381) DESCRIBE `ports` 0.00066804885864258
(382) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1592))) 0.00020408630371094
(383) DESCRIBE `ports` 0.00069594383239746
(384) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1592') 0.00022006034851074
(385) DESCRIBE `sailingdates` 0.00060701370239258
(386) DESCRIBE `ports` 0.0006868839263916
(387) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1592))) 0.00020098686218262
(388) DESCRIBE `ports` 0.00069403648376465
(389) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1592') 0.0001838207244873
(390) DESCRIBE `ports` 0.00066709518432617
(391) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1563))) 0.00020408630371094
(392) DESCRIBE `ports` 0.00068807601928711
(393) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1563') 0.00018191337585449
(394) DESCRIBE `ports` 0.00066995620727539
(395) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1591))) 0.0001988410949707
(396) DESCRIBE `ports` 0.00066685676574707
(397) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1591') 0.00018191337585449
(398) DESCRIBE `ports` 0.0008537769317627
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1599))) 0.00020098686218262
(400) DESCRIBE `ports` 0.00067687034606934
(401) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1599') 0.0001828670501709
(402) DESCRIBE `ports` 0.00070095062255859
(403) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2093))) 0.00020098686218262
(404) DESCRIBE `ports` 0.00069499015808105
(405) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2093') 0.00018095970153809
(406) DESCRIBE `ports` 0.00066304206848145
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1590))) 0.0001990795135498
(408) DESCRIBE `ports` 0.00074100494384766
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1590') 0.00018095970153809
(410) DESCRIBE `ports` 0.00068998336791992
(411) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1564))) 0.00020599365234375
(412) DESCRIBE `ports` 0.00066208839416504
(413) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1564') 0.00018191337585449
(414) DESCRIBE `ports` 0.00069689750671387
(415) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1592))) 0.0001990795135498
(416) DESCRIBE `ports` 0.00066494941711426
(417) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1592') 0.00018215179443359
(418) DESCRIBE `ports` 0.00067806243896484
(419) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1592))) 0.00020098686218262
(420) DESCRIBE `ports` 0.00066184997558594
(421) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1592') 0.00018095970153809
(422) DESCRIBE `avid_specials` 0.00060296058654785
(423) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 64091 and class = 'Cruise') OR (item_id = 1496 AND class = 'Ship') OR (item_id = 268 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.00097894668579102
(424) DESCRIBE `cruiselines` 0.00094294548034668
(425) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 268))) 0.000244140625
(426) DESCRIBE `orchid_image` 0.00074505805969238
(427) DESCRIBE `cruiselines` 0.0010371208190918
(428) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '268') 0.00020289421081543
(429) DESCRIBE `cruises` 0.001323938369751
(430) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64966') 0.00021791458129883
(431) DESCRIBE `ships` 0.0013260841369629
(432) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1523))) 0.0002899169921875
(433) DESCRIBE `ships` 0.0012431144714355
(434) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1523') 0.00024008750915527
(435) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017905235290527
(436) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00016403198242188
(437) DESCRIBE `itineraries` 0.00064897537231445
(438) DESCRIBE `ports` 0.00092887878417969
(439) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00025796890258789
(440) DESCRIBE `ports` 0.00067400932312012
(441) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00020408630371094
(442) DESCRIBE `ports` 0.00067019462585449
(443) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00018191337585449
(444) DESCRIBE `sailingdates` 0.00060105323791504
(445) DESCRIBE `ports` 0.00068497657775879
(446) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00021696090698242
(447) DESCRIBE `ports` 0.00072288513183594
(448) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00018596649169922
(449) DESCRIBE `ports` 0.00067710876464844
(450) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00024580955505371
(451) DESCRIBE `ports` 0.0007469654083252
(452) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.0001990795135498
(453) DESCRIBE `ports` 0.00066685676574707
(454) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1547))) 0.00022196769714355
(455) DESCRIBE `ports` 0.00066518783569336
(456) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1547') 0.00018191337585449
(457) DESCRIBE `ports` 0.00068092346191406
(458) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1550))) 0.00020194053649902
(459) DESCRIBE `ports` 0.00066399574279785
(460) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1550') 0.00018477439880371
(461) DESCRIBE `ports` 0.00066995620727539
(462) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1551))) 0.0001978874206543
(463) DESCRIBE `ports` 0.00068902969360352
(464) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1551') 0.00018000602722168
(465) DESCRIBE `ports` 0.00066900253295898
(466) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.0001978874206543
(467) DESCRIBE `ports` 0.00087285041809082
(468) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00018405914306641
(469) DESCRIBE `ports` 0.00066709518432617
(470) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1509))) 0.00020003318786621
(471) DESCRIBE `ports` 0.00068998336791992
(472) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1509') 0.00018095970153809
(473) DESCRIBE `ports` 0.00066900253295898
(474) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1508))) 0.00022387504577637
(475) DESCRIBE `ports` 0.00066804885864258
(476) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1508') 0.00018310546875
(477) DESCRIBE `ports` 0.00072908401489258
(478) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1508))) 0.00020003318786621
(479) DESCRIBE `ports` 0.00066590309143066
(480) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1508') 0.00018000602722168
(481) DESCRIBE `avid_specials` 0.00060510635375977
(482) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 64966 and class = 'Cruise') OR (item_id = 1523 AND class = 'Ship') OR (item_id = 268 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.0010108947753906
(483) DESCRIBE `cruiselines` 0.0010271072387695
(484) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 268))) 0.00022721290588379
(485) DESCRIBE `orchid_image` 0.00074195861816406
(486) DESCRIBE `cruiselines` 0.0011169910430908
(487) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '268') 0.00019192695617676
(488) DESCRIBE `cruises` 0.0012588500976562
(489) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65672') 0.00030994415283203
(490) DESCRIBE `ships` 0.0014557838439941
(491) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1533))) 0.00024294853210449
(492) DESCRIBE `ships` 0.0013320446014404
(493) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1533') 0.00017809867858887
(494) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017499923706055
(495) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016403198242188
(496) DESCRIBE `itineraries` 0.00065779685974121
(497) DESCRIBE `ports` 0.00073814392089844
(498) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00020885467529297
(499) DESCRIBE `ports` 0.00066709518432617
(500) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00019097328186035
(501) DESCRIBE `ports` 0.00072097778320312
(502) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00019288063049316
(503) DESCRIBE `sailingdates` 0.00067496299743652
(504) DESCRIBE `ports` 0.00071310997009277
(505) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00025105476379395
(506) DESCRIBE `ports` 0.00072717666625977
(507) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.0003359317779541
(508) DESCRIBE `ports` 0.00085592269897461
(509) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2914))) 0.00021100044250488
(510) DESCRIBE `ports` 0.00067281723022461
(511) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2914') 0.00018501281738281
(512) DESCRIBE `ports` 0.00066804885864258
(513) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1578))) 0.00020503997802734
(514) DESCRIBE `ports` 0.00066494941711426
(515) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1578') 0.00018191337585449
(516) DESCRIBE `ports` 0.00068092346191406
(517) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00020003318786621
(518) DESCRIBE `ports` 0.00066304206848145
(519) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00018310546875
(520) DESCRIBE `ports` 0.00066685676574707
(521) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00020098686218262
(522) DESCRIBE `ports` 0.00068998336791992
(523) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00018000602722168
(524) DESCRIBE `ports` 0.00065016746520996
(525) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 936))) 0.00021505355834961
(526) DESCRIBE `ports` 0.00066304206848145
(527) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '936') 0.00018501281738281
(528) DESCRIBE `ports` 0.00071883201599121
(529) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00019407272338867
(530) DESCRIBE `ports` 0.0006568431854248
(531) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00017595291137695
(532) DESCRIBE `ports` 0.00073099136352539
(533) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1581))) 0.00019407272338867
(534) DESCRIBE `ports` 0.00070905685424805
(535) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1581') 0.00017309188842773
(536) DESCRIBE `ports` 0.00064992904663086
(537) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00019097328186035
(538) DESCRIBE `ports` 0.00065302848815918
(539) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00017189979553223
(540) DESCRIBE `avid_specials` 0.00059103965759277
(541) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65672 and class = 'Cruise') OR (item_id = 1533 AND class = 'Ship') OR (item_id = 204 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
(542) DESCRIBE `cruiselines` 0.00095319747924805
(543) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 204))) 0.00021100044250488
(544) DESCRIBE `orchid_image` 0.00073409080505371
(545) DESCRIBE `cruiselines` 0.00090789794921875
(546) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '204') 0.00017404556274414
(547) DESCRIBE `cruises` 0.0012149810791016
(548) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65744') 0.00018215179443359
(549) DESCRIBE `ships` 0.0016510486602783
(550) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1537))) 0.00025391578674316
(551) DESCRIBE `ships` 0.0012259483337402
(552) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1537') 0.00018310546875
(553) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017285346984863
(554) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016903877258301
(555) DESCRIBE `itineraries` 0.00063800811767578
(556) DESCRIBE `ports` 0.00066900253295898
(557) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.0002138614654541
(558) DESCRIBE `ports` 0.00069403648376465
(559) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00020003318786621
(560) DESCRIBE `ports` 0.00065422058105469
(561) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00017285346984863
(562) DESCRIBE `sailingdates` 0.00084090232849121
(563) DESCRIBE `ports` 0.0010130405426025
(564) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00020599365234375
(565) DESCRIBE `ports` 0.00067996978759766
(566) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00017714500427246
(567) DESCRIBE `ports` 0.00066018104553223
(568) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00019717216491699
(569) DESCRIBE `ports` 0.00067305564880371
(570) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00021100044250488
(571) DESCRIBE `ports` 0.00065803527832031
(572) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1578))) 0.00019598007202148
(573) DESCRIBE `ports` 0.00068807601928711
(574) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1578') 0.0001978874206543
(575) DESCRIBE `ports` 0.00078701972961426
(576) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 941))) 0.00020694732666016
(577) DESCRIBE `ports` 0.00078010559082031
(578) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '941') 0.00027084350585938
(579) DESCRIBE `ports` 0.0012059211730957
(580) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00034785270690918
(581) DESCRIBE `ports` 0.00082898139953613
(582) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00022196769714355
(583) DESCRIBE `ports` 0.001054048538208
(584) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 936))) 0.00028419494628906
(585) DESCRIBE `ports` 0.0010571479797363
(586) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '936') 0.00021004676818848
(587) DESCRIBE `ports` 0.00081086158752441
(588) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1577))) 0.00025701522827148
(589) DESCRIBE `ports` 0.00066995620727539
(590) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1577') 0.00017786026000977
(591) DESCRIBE `ports` 0.00066208839416504
(592) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00018978118896484
(593) DESCRIBE `ports` 0.00077390670776367
(594) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00017595291137695
(595) DESCRIBE `avid_specials` 0.00069499015808105
(596) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65744 and class = 'Cruise') OR (item_id = 1537 AND class = 'Ship') OR (item_id = 204 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.0018670558929443
(597) DESCRIBE `cruiselines` 0.0016510486602783
(598) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 204))) 0.0003199577331543
(599) DESCRIBE `orchid_image` 0.0011100769042969
(600) DESCRIBE `cruiselines` 0.0014369487762451
(601) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '204') 0.00028896331787109
(602) DESCRIBE `cruiselines` 0.0016598701477051
(603) 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.0038750171661377
(604) DESCRIBE `ships` 0.001737117767334
(605) 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.021453857421875
(606) DESCRIBE `cruisetypes` 0.00095200538635254
(607) DESCRIBE `destinations` 0.00089502334594727
(608) 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.0010530948638916