or, enquire about your chosen options

  1. Catch Up on Cruising: Latest News in bite size!
  2. Solo Cruisers
  3. Catch Up on Cruising: Latest News in bite size!
  4. Should I buy a beverage package?
  5. SPOTLIGHT ON: Viking Ocean and River Cruises

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

Total elapsed time: 0.85819458961487

# Query Time
(1) connect 0.00094914436340332
(2) DESCRIBE `cruises` 0.0029220581054688
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (57159, 59146, 59438, 61442, 64946, 65761, 66750, 67408, 67970, 67998)) ORDER BY FIND_IN_SET(id, '57159,59146,59438,61442,64946,65761,66750,67408,67970,67998') 0.0015759468078613
(4) DESCRIBE `cruises` 0.0026769638061523
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '57159') 0.00033211708068848
(6) DESCRIBE `ships` 0.0023818016052246
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 352))) 0.00065994262695312
(8) DESCRIBE `ships` 0.001896858215332
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '352') 0.00037193298339844
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030303001403809
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003509521484375
(12) DESCRIBE `itineraries` 0.0019409656524658
(13) DESCRIBE `ports` 0.0017578601837158
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00044083595275879
(15) DESCRIBE `ports` 0.0017189979553223
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00037503242492676
(17) DESCRIBE `ports` 0.0017740726470947
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00035500526428223
(19) DESCRIBE `sailingdates` 0.0012490749359131
(20) DESCRIBE `ports` 0.0086860656738281
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00040411949157715
(22) DESCRIBE `ports` 0.0014629364013672
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00030994415283203
(24) DESCRIBE `ports` 0.0013079643249512
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 764))) 0.00032591819763184
(26) DESCRIBE `ports` 0.0013031959533691
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '764') 0.0012309551239014
(28) DESCRIBE `ports` 0.0016438961029053
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00030016899108887
(30) DESCRIBE `ports` 0.0013220310211182
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00027203559875488
(32) DESCRIBE `ports` 0.0012900829315186
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 534))) 0.00029087066650391
(34) DESCRIBE `ports` 0.001276969909668
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '534') 0.00027704238891602
(36) DESCRIBE `ports` 0.0024621486663818
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00035786628723145
(38) DESCRIBE `ports` 0.0012381076812744
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00029182434082031
(40) DESCRIBE `ports` 0.001255989074707
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00030994415283203
(42) DESCRIBE `ports` 0.0013248920440674
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00030803680419922
(44) DESCRIBE `ports` 0.0012869834899902
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00029301643371582
(46) DESCRIBE `ports` 0.0013120174407959
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00029492378234863
(48) DESCRIBE `avid_specials` 0.00130295753479
(49) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 57159 and class = 'Cruise') OR (item_id = 352 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.0012249946594238
(50) DESCRIBE `cruiselines` 0.0021250247955322
(51) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00046014785766602
(52) DESCRIBE `orchid_image` 0.0042481422424316
(53) DESCRIBE `cruiselines` 0.0019631385803223
(54) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00031208992004395
(55) DESCRIBE `cruises` 0.0026111602783203
(56) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59146') 0.0003209114074707
(57) DESCRIBE `ships` 0.002626895904541
(58) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 859))) 0.00039911270141602
(59) DESCRIBE `ships` 0.0029041767120361
(60) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '859') 0.00043296813964844
(61) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00030279159545898
(62) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025200843811035
(63) DESCRIBE `itineraries` 0.0013179779052734
(64) DESCRIBE `ports` 0.0013899803161621
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5177))) 0.00034117698669434
(66) DESCRIBE `ports` 0.0017268657684326
(67) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5177))) 0.00040602684020996
(68) DESCRIBE `ports` 0.001366138458252
(69) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5177') 0
(70) DESCRIBE `sailingdates` 0.0013940334320068
(71) DESCRIBE `ports` 0.00093412399291992
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5177))) 0.00033092498779297
(73) DESCRIBE `ports` 0.00088715553283691
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5177') 0.00031089782714844
(75) DESCRIBE `ports` 0.0015990734100342
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5178))) 0
(77) DESCRIBE `ports` 0.0014379024505615
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5178') 0.00028586387634277
(79) DESCRIBE `ports` 0.0015509128570557
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5178))) 0.00030994415283203
(81) DESCRIBE `ports` 0.0013821125030518
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5178') 0.00028896331787109
(83) DESCRIBE `ports` 0.0013411045074463
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00037002563476562
(85) DESCRIBE `ports` 0.0012350082397461
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00091910362243652
(87) DESCRIBE `ports` 0.0010218620300293
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00029397010803223
(89) DESCRIBE `ports` 0.001924991607666
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00028586387634277
(91) DESCRIBE `ports` 0.0011839866638184
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00028204917907715
(93) DESCRIBE `ports` 0.0013868808746338
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00030899047851562
(95) DESCRIBE `ports` 0.0013890266418457
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00053906440734863
(97) DESCRIBE `ports` 0.0014731884002686
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00032901763916016
(99) DESCRIBE `ports` 0.0017168521881104
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5178))) 0
(101) DESCRIBE `ports` 0.0013501644134521
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5178') 0.00024199485778809
(103) DESCRIBE `ports` 0.0016629695892334
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5177))) 0.00046896934509277
(105) DESCRIBE `ports` 0.0016770362854004
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5177') 0.00021910667419434
(107) DESCRIBE `avid_specials` 0.0012321472167969
(108) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59146 and class = 'Cruise') OR (item_id = 859 AND class = 'Ship') OR (item_id = 196 AND class = 'CruiseLine') OR (item_id = 55 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.0012438297271729
(109) DESCRIBE `cruiselines` 0.0020060539245605
(110) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 196))) 0.0010428428649902
(111) DESCRIBE `orchid_image` 0.0020701885223389
(112) DESCRIBE `cruiselines` 0.0016720294952393
(113) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '196') 0
(114) DESCRIBE `cruises` 0.0036201477050781
(115) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59438') 6.8902969360352E-5
(116) DESCRIBE `ships` 0.0035240650177002
(117) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1419))) 0.00044488906860352
(118) DESCRIBE `ships` 0.0030040740966797
(119) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1419') 0.00057888031005859
(120) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034093856811523
(121) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00032401084899902
(122) DESCRIBE `itineraries` 0.00095891952514648
(123) DESCRIBE `ports` 0.001338005065918
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1204))) 0.00040483474731445
(125) DESCRIBE `ports` 0.0014879703521729
(126) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1204))) 0.00047206878662109
(127) DESCRIBE `ports` 0.0014481544494629
(128) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1204') 0.00033187866210938
(129) DESCRIBE `sailingdates` 0.0013339519500732
(130) DESCRIBE `ports` 0.0019469261169434
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1204))) 0.00045609474182129
(132) DESCRIBE `ports` 0.0020420551300049
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1204') 0.00037503242492676
(134) DESCRIBE `ports` 0.0017659664154053
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2204))) 0
(136) DESCRIBE `ports` 0.0027241706848145
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2204') 0.001025915145874
(138) DESCRIBE `ports` 0.0016460418701172
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2832))) 0.00065398216247559
(140) DESCRIBE `ports` 0.0019011497497559
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2832') 0.00039291381835938
(142) DESCRIBE `ports` 0.0017979145050049
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2831))) 0.00059700012207031
(144) DESCRIBE `ports` 0.0093960762023926
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2831') 0.00053191184997559
(146) DESCRIBE `ports` 0.0017020702362061
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2201))) 0.0004429817199707
(148) DESCRIBE `ports` 0.0019638538360596
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2201') 0.00044512748718262
(150) DESCRIBE `ports` 0.0018689632415771
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2203))) 0.0027220249176025
(152) DESCRIBE `ports` 0.0016918182373047
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2203') 0.00029706954956055
(154) DESCRIBE `ports` 0.0016548633575439
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2831))) 0.0072000026702881
(156) DESCRIBE `ports` 0.0020241737365723
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2831') 0.00036096572875977
(158) DESCRIBE `ports` 0.0015380382537842
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2832))) 0.0083620548248291
(160) DESCRIBE `ports` 0.0019128322601318
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2832') 0.00042390823364258
(162) DESCRIBE `ports` 0.0050289630889893
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2832))) 0.00050592422485352
(164) DESCRIBE `ports` 0.0020129680633545
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2832') 0.0044240951538086
(166) DESCRIBE `ports` 0.0017869472503662
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1204))) 0.0034060478210449
(168) DESCRIBE `ports` 0.0074799060821533
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1204') 0.0028479099273682
(170) DESCRIBE `avid_specials` 0.001507043838501
(171) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59438 and class = 'Cruise') OR (item_id = 1419 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.0020370483398438
(172) DESCRIBE `cruiselines` 0.0023729801177979
(173) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 31))) 0.0011827945709229
(174) DESCRIBE `orchid_image` 0.0023360252380371
(175) DESCRIBE `cruiselines` 0.0035419464111328
(176) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '31') 0.00048112869262695
(177) DESCRIBE `cruises` 0.0027580261230469
(178) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '61442') 0.0038049221038818
(179) DESCRIBE `ships` 0.0032820701599121
(180) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1366))) 0.00097298622131348
(181) DESCRIBE `ships` 0.0033819675445557
(182) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1366') 0.00071811676025391
(183) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00030684471130371
(184) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00027585029602051
(185) DESCRIBE `itineraries` 0.001957893371582
(186) DESCRIBE `ports` 0.012351989746094
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5604))) 0.00044894218444824
(188) DESCRIBE `ports` 0.0065021514892578
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5604))) 0.00017905235290527
(190) DESCRIBE `ports` 0.0015900135040283
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5604') 0.0026400089263916
(192) DESCRIBE `sailingdates` 0.0016269683837891
(193) DESCRIBE `ports` 0.0060579776763916
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5604))) 0.00038790702819824
(195) DESCRIBE `ports` 0.0015361309051514
(196) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5604') 0.00031208992004395
(197) DESCRIBE `ports` 0.0015759468078613
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00032520294189453
(199) DESCRIBE `ports` 0.0013880729675293
(200) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00031614303588867
(201) DESCRIBE `ports` 0.0013570785522461
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1554))) 0.00028705596923828
(203) DESCRIBE `ports` 0.0014297962188721
(204) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1554') 0.00032305717468262
(205) DESCRIBE `ports` 0.001349925994873
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) 0.00030708312988281
(207) DESCRIBE `ports` 0.001474142074585
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') 0.00026106834411621
(209) DESCRIBE `ports` 0.0013048648834229
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4236))) 0.00032305717468262
(211) DESCRIBE `ports` 0.0012650489807129
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4236') 0.00030612945556641
(213) DESCRIBE `ports` 0.0029628276824951
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1556))) 0.00031089782714844
(215) DESCRIBE `ports` 0.0012850761413574
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1556') 0.00027108192443848
(217) DESCRIBE `ports` 0.0016641616821289
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5604))) 0.00028181076049805
(219) DESCRIBE `ports` 0.0013821125030518
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5604') 0.00029182434082031
(221) DESCRIBE `ports` 0.0012979507446289
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5604))) 0.00028896331787109
(223) DESCRIBE `ports` 0.0012929439544678
(224) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5604') 0.0002601146697998
(225) DESCRIBE `avid_specials` 0.0011019706726074
(226) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 61442 and class = 'Cruise') OR (item_id = 1366 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.00111985206604
(227) DESCRIBE `cruiselines` 0.0018088817596436
(228) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.00031089782714844
(229) DESCRIBE `orchid_image` 0.0014119148254395
(230) DESCRIBE `cruiselines` 0.0024030208587646
(231) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.00027585029602051
(232) DESCRIBE `cruises` 0.0024998188018799
(233) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64946') 0.00037097930908203
(234) DESCRIBE `ships` 0.0035641193389893
(235) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1516))) 0.00081110000610352
(236) DESCRIBE `ships` 0.0060141086578369
(237) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1516') 0.00036478042602539
(238) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026512145996094
(239) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00025200843811035
(240) DESCRIBE `itineraries` 0.0012409687042236
(241) DESCRIBE `ports` 0.0012660026550293
(242) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00030994415283203
(243) DESCRIBE `ports` 0.0012772083282471
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00029397010803223
(245) DESCRIBE `ports` 0.0012381076812744
(246) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00027203559875488
(247) DESCRIBE `sailingdates` 0.0011727809906006
(248) DESCRIBE `ports` 0.0013580322265625
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.0003669261932373
(250) DESCRIBE `ports` 0.0013599395751953
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.0025351047515869
(252) DESCRIBE `ports` 0.0012650489807129
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2691))) 0.0023150444030762
(254) DESCRIBE `ports` 0.0014441013336182
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2691') 0.0003819465637207
(256) DESCRIBE `ports` 0.0017068386077881
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.0067729949951172
(258) DESCRIBE `ports` 0.0012669563293457
(259) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.0047330856323242
(260) DESCRIBE `ports` 0.0012509822845459
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.0014510154724121
(262) DESCRIBE `ports` 0.0012459754943848
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.0060951709747314
(264) DESCRIBE `ports` 0.0012800693511963
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2691))) 0.00034093856811523
(266) DESCRIBE `ports` 0.0017201900482178
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2691') 0.001572847366333
(268) DESCRIBE `ports` 0.0014688968658447
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4685))) 0.0070679187774658
(270) DESCRIBE `ports` 0.0015192031860352
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4685') 0.00032806396484375
(272) DESCRIBE `ports` 0.0013768672943115
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00032496452331543
(274) DESCRIBE `ports` 0.0012900829315186
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00031900405883789
(276) DESCRIBE `ports` 0.001317024230957
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.0025720596313477
(278) DESCRIBE `ports` 0.0012919902801514
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.0025808811187744
(280) DESCRIBE `avid_specials` 0.0012588500976562
(281) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 64946 and class = 'Cruise') OR (item_id = 1516 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.0011160373687744
(282) DESCRIBE `cruiselines` 0.006458044052124
(283) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 268))) 0.00044417381286621
(284) DESCRIBE `orchid_image` 0.0019378662109375
(285) DESCRIBE `cruiselines` 0.0026149749755859
(286) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '268') 0.00046610832214355
(287) DESCRIBE `cruises` 0.0025238990783691
(288) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65761') 0.00032615661621094
(289) DESCRIBE `ships` 0.0025770664215088
(290) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1542))) 0.0003819465637207
(291) DESCRIBE `ships` 0.0026149749755859
(292) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1542') 0.0004420280456543
(293) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026416778564453
(294) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00028896331787109
(295) DESCRIBE `itineraries` 0.001331090927124
(296) DESCRIBE `ports` 0.0012881755828857
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.001370906829834
(298) DESCRIBE `ports` 0.0016179084777832
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.0003511905670166
(300) DESCRIBE `ports` 0.0013401508331299
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00036311149597168
(302) DESCRIBE `sailingdates` 0.001248836517334
(303) DESCRIBE `ports` 0.0013329982757568
(304) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00033998489379883
(305) DESCRIBE `ports` 0.0012989044189453
(306) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00027585029602051
(307) DESCRIBE `ports` 0.001255989074707
(308) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1556))) 0.00029778480529785
(309) DESCRIBE `ports` 0.0012550354003906
(310) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1556') 0.00027012825012207
(311) DESCRIBE `ports` 0.0013108253479004
(312) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1558))) 0.00033307075500488
(313) DESCRIBE `ports` 0.0012919902801514
(314) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1558') 0.00026917457580566
(315) DESCRIBE `ports` 0.0013420581817627
(316) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1558))) 0.00029516220092773
(317) DESCRIBE `ports` 0.0013148784637451
(318) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1558') 0.00032210350036621
(319) DESCRIBE `ports` 0.0012819766998291
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) 0.00035500526428223
(321) DESCRIBE `ports` 0.0012669563293457
(322) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') 0.00027894973754883
(323) DESCRIBE `ports` 0.0012400150299072
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) 0.00030112266540527
(325) DESCRIBE `ports` 0.0012807846069336
(326) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') 0.00027894973754883
(327) DESCRIBE `ports` 0.0012400150299072
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1554))) 0.00030708312988281
(329) DESCRIBE `ports` 0.00060415267944336
(330) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1554') 0.00031685829162598
(331) DESCRIBE `ports` 0.0013270378112793
(332) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00030088424682617
(333) DESCRIBE `ports` 0.0013909339904785
(334) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00027203559875488
(335) DESCRIBE `ports` 0.0012590885162354
(336) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00029802322387695
(337) DESCRIBE `ports` 0.0013160705566406
(338) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.0011508464813232
(339) DESCRIBE `avid_specials` 0.0015389919281006
(340) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65761 and class = 'Cruise') OR (item_id = 1542 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.001878023147583
(341) DESCRIBE `cruiselines` 0.0026590824127197
(342) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 204))) 0.00044989585876465
(343) DESCRIBE `orchid_image` 0.0019769668579102
(344) DESCRIBE `cruiselines` 0.0024139881134033
(345) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '204') 0.0004119873046875
(346) DESCRIBE `cruises` 0.0034160614013672
(347) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66750') 0.00037598609924316
(348) DESCRIBE `ships` 0.0037031173706055
(349) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 314))) 0.00058317184448242
(350) DESCRIBE `ships` 0.0028629302978516
(351) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '314') 0.0003199577331543
(352) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026702880859375
(353) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025391578674316
(354) DESCRIBE `itineraries` 0.0013599395751953
(355) DESCRIBE `ports` 0.00097894668579102
(356) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.00033807754516602
(357) DESCRIBE `ports` 0.0016272068023682
(358) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.00031089782714844
(359) DESCRIBE `ports` 0.0013179779052734
(360) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.0002899169921875
(361) DESCRIBE `sailingdates` 0.0012071132659912
(362) DESCRIBE `ports` 0.0013449192047119
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.00052309036254883
(364) DESCRIBE `ports` 0.0018649101257324
(365) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.00041103363037109
(366) DESCRIBE `ports` 0.0013799667358398
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.00023102760314941
(368) DESCRIBE `ports` 0.0013129711151123
(369) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.00018000602722168
(370) DESCRIBE `ports` 0.0015769004821777
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 117))) 0.00024294853210449
(372) DESCRIBE `ports` 0.0014760494232178
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '117') 0.00016593933105469
(374) DESCRIBE `ports` 0.0015218257904053
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) 0.00022006034851074
(376) DESCRIBE `ports` 0.0014898777008057
(377) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') 0.00014805793762207
(378) DESCRIBE `ports` 0.0014419555664062
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 333))) 0.00017595291137695
(380) DESCRIBE `ports` 0.0013720989227295
(381) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '333') 0.00020694732666016
(382) DESCRIBE `ports` 0.001384973526001
(383) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 119))) 0.00018191337585449
(384) DESCRIBE `ports` 0.0015840530395508
(385) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '119') 0.00019288063049316
(386) DESCRIBE `ports` 0.0015490055084229
(387) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00020289421081543
(388) DESCRIBE `ports` 0.001629114151001
(389) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00016903877258301
(390) DESCRIBE `avid_specials` 0.0012660026550293
(391) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66750 and class = 'Cruise') OR (item_id = 314 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 11 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.001101016998291
(392) DESCRIBE `cruiselines` 0.0018727779388428
(393) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00043606758117676
(394) DESCRIBE `orchid_image` 0.0018332004547119
(395) DESCRIBE `cruiselines` 0.0021700859069824
(396) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00028395652770996
(397) DESCRIBE `cruises` 0.0025858879089355
(398) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67408') 0.00028610229492188
(399) DESCRIBE `ships` 0.0037188529968262
(400) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1322))) 0.00040197372436523
(401) DESCRIBE `ships` 0.0041158199310303
(402) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1322') 0.00032997131347656
(403) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00027298927307129
(404) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025606155395508
(405) DESCRIBE `itineraries` 0.001413106918335
(406) DESCRIBE `ports` 0.0016651153564453
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00031590461730957
(408) DESCRIBE `ports` 0.0013251304626465
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00036001205444336
(410) DESCRIBE `ports` 0.0015408992767334
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00032615661621094
(412) DESCRIBE `sailingdates` 0.0014169216156006
(413) DESCRIBE `ports` 0.0018270015716553
(414) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00035595893859863
(415) DESCRIBE `ports` 0.0015339851379395
(416) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00028800964355469
(417) DESCRIBE `ports` 0.0016069412231445
(418) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00030708312988281
(419) DESCRIBE `ports` 0.0016729831695557
(420) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00029301643371582
(421) DESCRIBE `ports` 0.0017268657684326
(422) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 936))) 0.00034809112548828
(423) DESCRIBE `ports` 0.0016500949859619
(424) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '936') 0.00029301643371582
(425) DESCRIBE `ports` 0.0015010833740234
(426) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00031113624572754
(427) DESCRIBE `ports` 0.0014009475708008
(428) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.0002899169921875
(429) DESCRIBE `ports` 0.0020120143890381
(430) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00035381317138672
(431) DESCRIBE `ports` 0.001410961151123
(432) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00029206275939941
(433) DESCRIBE `ports` 0.0012660026550293
(434) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3643))) 0.00031304359436035
(435) DESCRIBE `ports` 0.001582145690918
(436) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3643') 0.00028800964355469
(437) DESCRIBE `ports` 0.0013182163238525
(438) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 938))) 0.00031113624572754
(439) DESCRIBE `ports` 0.0012848377227783
(440) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '938') 0.00028610229492188
(441) DESCRIBE `ports` 0.0012640953063965
(442) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1581))) 0.00030303001403809
(443) DESCRIBE `ports` 0.0012609958648682
(444) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1581') 0.00032782554626465
(445) DESCRIBE `ports` 0.0013318061828613
(446) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00031399726867676
(447) DESCRIBE `ports` 0.0012922286987305
(448) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00030899047851562
(449) DESCRIBE `ports` 0.0012471675872803
(450) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2916))) 0.00030207633972168
(451) DESCRIBE `ports` 0.0013971328735352
(452) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2916') 0.00029516220092773
(453) DESCRIBE `ports` 0.012516975402832
(454) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2916))) 0.00050616264343262
(455) DESCRIBE `ports` 0.0019800662994385
(456) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2916') 0.00042200088500977
(457) DESCRIBE `avid_specials` 0.0016391277313232
(458) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67408 and class = 'Cruise') OR (item_id = 1322 AND class = 'Ship') OR (item_id = 131 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.005061149597168
(459) DESCRIBE `cruiselines` 0.0022799968719482
(460) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 131))) 0.0012640953063965
(461) DESCRIBE `orchid_image` 0.0011448860168457
(462) DESCRIBE `cruiselines` 0.0030078887939453
(463) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '131') 0.013453006744385
(464) DESCRIBE `cruises` 0.0029468536376953
(465) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67970') 0.00050210952758789
(466) DESCRIBE `ships` 0.0028481483459473
(467) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 977))) 0.00043892860412598
(468) DESCRIBE `ships` 0.005803108215332
(469) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '977') 0.0005180835723877
(470) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003509521484375
(471) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00041317939758301
(472) DESCRIBE `itineraries` 0.0026340484619141
(473) DESCRIBE `ports` 0.0022280216217041
(474) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00046110153198242
(475) DESCRIBE `ports` 0.0018088817596436
(476) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00029993057250977
(477) DESCRIBE `ports` 0.0024831295013428
(478) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00016188621520996
(479) DESCRIBE `sailingdates` 0.0013880729675293
(480) DESCRIBE `ports` 0.0018749237060547
(481) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00045585632324219
(482) DESCRIBE `ports` 0.0013339519500732
(483) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00027084350585938
(484) DESCRIBE `ports` 0.0012359619140625
(485) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00031900405883789
(486) DESCRIBE `ports` 0.0014939308166504
(487) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00028300285339355
(488) DESCRIBE `ports` 0.001331090927124
(489) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0003209114074707
(490) DESCRIBE `ports` 0.0013768672943115
(491) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00080990791320801
(492) DESCRIBE `ports` 0.0018680095672607
(493) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00058603286743164
(494) DESCRIBE `ports` 0.0018291473388672
(495) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00043892860412598
(496) DESCRIBE `ports` 0.001823902130127
(497) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 587))) 0.00041913986206055
(498) DESCRIBE `ports` 0.0018379688262939
(499) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '587') 0.00041913986206055
(500) DESCRIBE `ports` 0.0018858909606934
(501) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00043797492980957
(502) DESCRIBE `ports` 0.0018820762634277
(503) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00040197372436523
(504) DESCRIBE `ports` 0.0018410682678223
(505) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00044679641723633
(506) DESCRIBE `ports` 0.0017919540405273
(507) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00039291381835938
(508) DESCRIBE `ports` 0.0017929077148438
(509) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00042414665222168
(510) DESCRIBE `ports` 0.001777172088623
(511) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00037407875061035
(512) DESCRIBE `avid_specials` 0.0017049312591553
(513) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67970 and class = 'Cruise') OR (item_id = 977 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.0017969608306885
(514) DESCRIBE `cruiselines` 0.0024998188018799
(515) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00041794776916504
(516) DESCRIBE `orchid_image` 0.0019750595092773
(517) DESCRIBE `cruiselines` 0.0032169818878174
(518) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00039315223693848
(519) DESCRIBE `cruises` 0.003493070602417
(520) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67998') 0
(521) DESCRIBE `ships` 0.004403829574585
(522) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 726))) 0.00052905082702637
(523) DESCRIBE `ships` 0.0032360553741455
(524) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '726') 0.0004270076751709
(525) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00043201446533203
(526) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003359317779541
(527) DESCRIBE `itineraries` 0.0017910003662109
(528) DESCRIBE `ports` 0.0018339157104492
(529) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00052714347839355
(530) DESCRIBE `ports` 0.0017590522766113
(531) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00038290023803711
(532) DESCRIBE `ports` 0.0017969608306885
(533) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.0003960132598877
(534) DESCRIBE `sailingdates` 0.0016298294067383
(535) DESCRIBE `ports` 0.0018649101257324
(536) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00045084953308105
(537) DESCRIBE `ports` 0.0018298625946045
(538) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00037407875061035
(539) DESCRIBE `ports` 0.0017590522766113
(540) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2264))) 0.00040888786315918
(541) DESCRIBE `ports` 0.0017569065093994
(542) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2264') 0.0004119873046875
(543) DESCRIBE `ports` 0.0018529891967773
(544) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00039887428283691
(545) DESCRIBE `ports` 0.0017800331115723
(546) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00036311149597168
(547) DESCRIBE `ports` 0.0018417835235596
(548) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.00041913986206055
(549) DESCRIBE `ports` 0.001762866973877
(550) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.0003659725189209
(551) DESCRIBE `ports` 0.0017709732055664
(552) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.00055098533630371
(553) DESCRIBE `ports` 0.0017669200897217
(554) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00036787986755371
(555) DESCRIBE `ports` 0.0018079280853271
(556) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.00041294097900391
(557) DESCRIBE `ports` 0.0018348693847656
(558) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00039386749267578
(559) DESCRIBE `ports` 0.0017440319061279
(560) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00040388107299805
(561) DESCRIBE `ports` 0.0017709732055664
(562) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00040793418884277
(563) DESCRIBE `ports` 0.0017268657684326
(564) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 210))) 0.00043916702270508
(565) DESCRIBE `ports` 0.0018658638000488
(566) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '210') 0.00038504600524902
(567) DESCRIBE `ports` 0.0018351078033447
(568) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00041103363037109
(569) DESCRIBE `ports` 0.0017569065093994
(570) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00036287307739258
(571) DESCRIBE `avid_specials` 0.0015699863433838
(572) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67998 and class = 'Cruise') OR (item_id = 726 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.0017058849334717
(573) DESCRIBE `cruiselines` 0.0026769638061523
(574) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00043106079101562
(575) DESCRIBE `orchid_image` 0.0020489692687988
(576) DESCRIBE `cruiselines` 0.0025241374969482
(577) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00040388107299805
(578) DESCRIBE `cruiselines` 0.0027720928192139
(579) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '19', '26', '7', '12', '23', '171', '144', '18', '20', '101', '31', '8', '96', '131', '183', '239', '120', '191', '206', '29', '50', '103', '15', '221', '33', '28', '262', '24', '91', '268', '114', '110', '156', '37', '208', '141', '14', '187', '153', '118', '49', '211', '151', '30', '232', '258', '216', '181', '212', '36', '4', '140', '225', '238', '249', '256', '204', '47', '113', '16', '174', '90', '88', '261', '35', '182', '188', '230', '136', '237', '264', '159', '195', '146', '115', '213', '220', '180', '57', '64', '73', '248', '196', '209', '95', '168', '52', '184', '219', '59', '231', '170', '229', '116', '82', '119', '244', '105', '134', '108', '276', '48', '275', '240', '269', '132', '266', '224', '210')) ORDER BY FIND_IN_SET(id, '218,77,19,26,7,12,23,171,144,18,20,101,31,8,96,131,183,239,120,191,206,29,50,103,15,221,33,28,262,24,91,268,114,110,156,37,208,141,14,187,153,118,49,211,151,30,232,258,216,181,212,36,4,140,225,238,249,256,204,47,113,16,174,90,88,261,35,182,188,230,136,237,264,159,195,146,115,213,220,180,57,64,73,248,196,209,95,168,52,184,219,59,231,170,229,116,82,119,244,105,134,108,276,48,275,240,269,132,266,224,210') 0.0083599090576172
(580) DESCRIBE `ships` 0.0035748481750488
(581) SELECT `ships`.* FROM `ships` WHERE (id IN ('1127', '1032', '1292', '1205', '1199', '1359', '977', '1291', '454', '1272', '1247', '1554', '1555', '1599', '855', '986', '1237', '1594', '1588', '1067', '258', '407', '1677', '34', '22', '27', '37', '38', '378', '461', '21', '28', '31', '393', '817', '1135', '780', '30', '36', '349', '726', '1012', '1424', '39', '1422', '35', '1419', '1423', '1420', '1415', '1418', '1421', '404', '882', '1176', '462', '113', '1215', '1245', '1405', '766', '24', '330', '711', '11', '1574', '439', '452', '9', '265', '10', '455', '1607', '1744', '1141', '585', '542', '739', '1572', '124', '635', '674', '770', '573', '3', '5', '874', '792', '1454', '340', '1372', '116', '580', '351', '716', '1193', '338', '553', '1168', '1302', '520', '797', '1284', '1460', '25', '66', '1402', '1471', '160', '285', '974', '1021', '332', '1095', '1455', '207', '253', '4', '43', '390', '748', '111', '148', '658', '993', '1172', '1325', '791', '1260', '1320', '1678', '81', '517', '1259', '1323', '1562', '406', '1195', '582', '590', '678', '286', '434', '1068', '1575', '119', '327', '526', '559', '970', '616', '63', '108', '421', '854', '78', '375', '401', '657', '883', '1266', '547', '1139', '1571', '1586', '84', '722', '1208', '1569', '775', '1492', '150', '335', '850', '1008', '1236', '1398', '1587', '114', '1308', '1437', '14', '784', '152', '403', '958', '1268', '1672', '151', '1064', '823', '1108', '1289', '1319', '1724', '405', '451', '652', '704', '715', '966', '1088', '325', '348', '683', '1282', '1321', '123', '162', '790', '1243', '262', '389', '1013', '1143', '1159', '1269', '1330', '1348', '1389', '732', '75', '163', '441', '483', '1270', '1326', '1327', '1526', '1579', '508', '1151', '1214', '1557', '1561', '314', '333', '768', '1367', '385', '394', '626', '1318', '1376', '93', '287', '290', '545', '1711', '1075', '1602', '82', '98', '521', '651', '796', '968', '1344', '1539', '1722', '149', '673', '751', '818', '884', '1027', '1040', '1137', '1144', '1163', '1216', '1343', '1717', '201', '291', '743', '852', '1160', '1223', '1373', '1409', '769', '1063', '1157', '1452', '1453', '1604', '1738', '776', '1025', '1090', '1136', '1283', '1301', '1303', '1540', '1552', '45', '223', '341', '1217', '1241', '1413', '105', '485', '516', '669', '811', '1043', '1073', '1233', '1345', '1426', '1449', '1704', '266', '324', '467', '1019', '1152', '1358', '1632', '448', '503', '639', '701', '885', '888', '905', '1029', '1145', '1218', '1226', '1253', '1411', '1448', '1566', '1682', '795', '859', '988', '1150', '1742', '352', '601', '1322', '1647', '1676', '1740', '74', '417', '610', '731', '738', '1149', '1458', '1026', '1188', '493', '494', '973', '1055', '1231', '1351', '1408', '1489', '1496', '1505', '1580', '666', '954', '1034', '1047', '1049', '1366', '1474', '147', '205', '618', '851', '1229', '1230', '1516', '1609', '1716', '208', '836', '1154', '1362', '1368', '1444', '1470', '423', '663', '709', '920', '927', '1262', '1463', '1619', '204', '921', '931', '996', '1004', '1020', '1222', '1285', '1354', '1407', '1410', '1508', '1627', '1713', '1715', '703', '914', '923', '1196', '1518', '1714', '643', '717', '915', '916', '926', '930', '1003', '1037', '1072', '1106', '1224', '1240', '1521', '1581', '1673', '1743', '422', '924', '1017', '1042', '1138', '1352', '1404', '1486', '1567', '1593', '1596', '1606', '499', '972', '1175', '1187', '1360', '1361', '1459', '1522', '479', '671', '672', '781', '1001', '1051', '1148', '1254', '1412', '1445', '1517', '17', '656', '837', '1054', '1382', '1417', '665', '938', '994', '1002', '1514', '1601', '1708', '1751', '504', '985', '1005', '1045', '1053', '1684', '1723', '420', '453', '574', '761', '821', '982', '995', '1028', '1729', '857', '937')) ORDER BY FIND_IN_SET(id, '1127,1032,1292,1205,1199,1359,977,1291,454,1272,1247,1554,1555,1599,855,986,1237,1594,1588,1067,258,407,1677,34,22,27,37,38,378,461,21,28,31,393,817,1135,780,30,36,349,726,1012,1424,39,1422,35,1419,1423,1420,1415,1418,1421,404,882,1176,462,113,1215,1245,1405,766,24,330,711,11,1574,439,452,9,265,10,455,1607,1744,1141,585,542,739,1572,124,635,674,770,573,3,5,874,792,1454,340,1372,116,580,351,716,1193,338,553,1168,1302,520,797,1284,1460,25,66,1402,1471,160,285,974,1021,332,1095,1455,207,253,4,43,390,748,111,148,658,993,1172,1325,791,1260,1320,1678,81,517,1259,1323,1562,406,1195,582,590,678,286,434,1068,1575,119,327,526,559,970,616,63,108,421,854,78,375,401,657,883,1266,547,1139,1571,1586,84,722,1208,1569,775,1492,150,335,850,1008,1236,1398,1587,114,1308,1437,14,784,152,403,958,1268,1672,151,1064,823,1108,1289,1319,1724,405,451,652,704,715,966,1088,325,348,683,1282,1321,123,162,790,1243,262,389,1013,1143,1159,1269,1330,1348,1389,732,75,163,441,483,1270,1326,1327,1526,1579,508,1151,1214,1557,1561,314,333,768,1367,385,394,626,1318,1376,93,287,290,545,1711,1075,1602,82,98,521,651,796,968,1344,1539,1722,149,673,751,818,884,1027,1040,1137,1144,1163,1216,1343,1717,201,291,743,852,1160,1223,1373,1409,769,1063,1157,1452,1453,1604,1738,776,1025,1090,1136,1283,1301,1303,1540,1552,45,223,341,1217,1241,1413,105,485,516,669,811,1043,1073,1233,1345,1426,1449,1704,266,324,467,1019,1152,1358,1632,448,503,639,701,885,888,905,1029,1145,1218,1226,1253,1411,1448,1566,1682,795,859,988,1150,1742,352,601,1322,1647,1676,1740,74,417,610,731,738,1149,1458,1026,1188,493,494,973,1055,1231,1351,1408,1489,1496,1505,1580,666,954,1034,1047,1049,1366,1474,147,205,618,851,1229,1230,1516,1609,1716,208,836,1154,1362,1368,1444,1470,423,663,709,920,927,1262,1463,1619,204,921,931,996,1004,1020,1222,1285,1354,1407,1410,1508,1627,1713,1715,703,914,923,1196,1518,1714,643,717,915,916,926,930,1003,1037,1072,1106,1224,1240,1521,1581,1673,1743,422,924,1017,1042,1138,1352,1404,1486,1567,1593,1596,1606,499,972,1175,1187,1360,1361,1459,1522,479,671,672,781,1001,1051,1148,1254,1412,1445,1517,17,656,837,1054,1382,1417,665,938,994,1002,1514,1601,1708,1751,504,985,1005,1045,1053,1684,1723,420,453,574,761,821,982,995,1028,1729,857,937') 0.05156397819519
(582) DESCRIBE `cruisetypes` 0.0015799999237061
(583) DESCRIBE `destinations` 0.0018079280853271
(584) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '22', '54', '35', '25', '37', '43', '9', '2', '8', '53', '55', '39', '28', '38', '40', '7', '26', '30', '48', '11', '21', '45', '29', '49', '56', '44', '34', '10', '52', '46', '32')) ORDER BY FIND_IN_SET(id, '50,12,22,54,35,25,37,43,9,2,8,53,55,39,28,38,40,7,26,30,48,11,21,45,29,49,56,44,34,10,52,46,32') 0.0024700164794922