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

Total elapsed time: 0.8424186706543

# Query Time
(1) connect 0.00098180770874023
(2) DESCRIBE `cruises` 0.0031061172485352
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (46637, 66955, 53605, 34056, 66996, 66993, 66998, 65173, 66995)) ORDER BY FIND_IN_SET(id, '46637,66955,53605,34056,66996,66993,66998,65173,66995') 0.0011768341064453
(4) DESCRIBE `cruises` 0.0028760433197021
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '46637') 0.00037002563476562
(6) DESCRIBE `ships` 0.0027401447296143
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 770))) 0.00038504600524902
(8) DESCRIBE `ships` 0.0030159950256348
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '770') 0.00044989585876465
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032997131347656
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028610229492188
(12) DESCRIBE `itineraries` 0.0013949871063232
(13) DESCRIBE `ports` 0.0019111633300781
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00047588348388672
(15) DESCRIBE `ports` 0.0018351078033447
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00038480758666992
(17) DESCRIBE `ports` 0.0013539791107178
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00028896331787109
(19) DESCRIBE `sailingdates` 0.0011520385742188
(20) DESCRIBE `ports` 0.0016670227050781
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00037503242492676
(22) DESCRIBE `ports` 0.0014081001281738
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00030183792114258
(24) DESCRIBE `ports` 0.0013959407806396
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.0003058910369873
(26) DESCRIBE `ports` 0.00073885917663574
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00030303001403809
(28) DESCRIBE `ports` 0.0018877983093262
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00040793418884277
(30) DESCRIBE `ports` 0.0013079643249512
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00028395652770996
(32) DESCRIBE `ports` 0.0013039112091064
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.0003211498260498
(34) DESCRIBE `ports` 0.001331090927124
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00027203559875488
(36) DESCRIBE `ports` 0.0018949508666992
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.00034093856811523
(38) DESCRIBE `ports` 0.001662015914917
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.00040793418884277
(40) DESCRIBE `ports` 0.0015180110931396
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.0003511905670166
(42) DESCRIBE `ports` 0.0019569396972656
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00030708312988281
(44) DESCRIBE `ports` 0.0014028549194336
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00030422210693359
(46) DESCRIBE `ports` 0.0012588500976562
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00033903121948242
(48) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '46637') AND (sailingdate >= '2018-04-01') AND (sailingdate <= '2018-12-31') 0.0082249641418457
(49) DESCRIBE `avid_specials` 0.0013670921325684
(50) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 46637 and class = 'Cruise') OR (item_id = 770 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0013349056243896
(51) DESCRIBE `cruiselines` 0.0022070407867432
(52) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00046110153198242
(53) DESCRIBE `orchid_image` 0.001471996307373
(54) DESCRIBE `cruiselines` 0.0019841194152832
(55) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.0003049373626709
(56) DESCRIBE `cruises` 0.0026049613952637
(57) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66955') 0.00044798851013184
(58) DESCRIBE `ships` 0.0027480125427246
(59) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00039005279541016
(60) DESCRIBE `ships` 0.0025999546051025
(61) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00035905838012695
(62) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028300285339355
(63) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027298927307129
(64) DESCRIBE `itineraries` 0.0012609958648682
(65) DESCRIBE `ports` 0.0012760162353516
(66) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0003349781036377
(67) DESCRIBE `ports` 0.0012838840484619
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00029492378234863
(69) DESCRIBE `ports` 0.0012562274932861
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00028300285339355
(71) DESCRIBE `sailingdates` 0.0011510848999023
(72) DESCRIBE `ports` 0.0012900829315186
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00031805038452148
(74) DESCRIBE `ports` 0.0013010501861572
(75) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0002739429473877
(76) DESCRIBE `ports` 0.0012638568878174
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00034713745117188
(78) DESCRIBE `ports` 0.0012450218200684
(79) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00027680397033691
(80) DESCRIBE `ports` 0.001255989074707
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00029087066650391
(82) DESCRIBE `ports` 0.0012509822845459
(83) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00027894973754883
(84) DESCRIBE `ports` 0.0013670921325684
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 370))) 0.00031018257141113
(86) DESCRIBE `ports` 0.0014209747314453
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '370') 0.00027704238891602
(88) DESCRIBE `ports` 0.001399040222168
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.0003199577331543
(90) DESCRIBE `ports` 0.0012719631195068
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00027608871459961
(92) DESCRIBE `ports` 0.0013611316680908
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00031185150146484
(94) DESCRIBE `ports` 0.0013670921325684
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00027203559875488
(96) DESCRIBE `ports` 0.0012729167938232
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0003058910369873
(98) DESCRIBE `ports` 0.0013039112091064
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00027084350585938
(100) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66955') AND (sailingdate >= '2018-04-01') AND (sailingdate <= '2018-12-31') 0.0048220157623291
(101) DESCRIBE `avid_specials` 0.0011677742004395
(102) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66955 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010480880737305
(103) DESCRIBE `cruiselines` 0.0018861293792725
(104) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00030398368835449
(105) DESCRIBE `orchid_image` 0.0014538764953613
(106) DESCRIBE `cruiselines` 0.0020430088043213
(107) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00035285949707031
(108) DESCRIBE `cruises` 0.0026800632476807
(109) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '53605') 0.00039911270141602
(110) DESCRIBE `ships` 0.0026578903198242
(111) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 770))) 0.00037097930908203
(112) DESCRIBE `ships` 0.0027129650115967
(113) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '770') 0.00031709671020508
(114) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034499168395996
(115) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031399726867676
(116) DESCRIBE `itineraries` 0.0014948844909668
(117) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '53605') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0007479190826416
(118) DESCRIBE `ports` 0.0015130043029785
(119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00038385391235352
(120) DESCRIBE `ports` 0.0014669895172119
(121) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00035810470581055
(122) DESCRIBE `ports` 0.0015859603881836
(123) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00032401084899902
(124) DESCRIBE `sailingdates` 0.0013821125030518
(125) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '53605') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0010521411895752
(126) DESCRIBE `ports` 0.0021638870239258
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00043010711669922
(128) DESCRIBE `ports` 0.0019388198852539
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00037312507629395
(130) DESCRIBE `ports` 0.0017380714416504
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00036811828613281
(132) DESCRIBE `ports` 0.0013148784637451
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00028419494628906
(134) DESCRIBE `ports` 0.0014610290527344
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.00029706954956055
(136) DESCRIBE `ports` 0.0014979839324951
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.00034403800964355
(138) DESCRIBE `ports` 0.0017008781433105
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00037693977355957
(140) DESCRIBE `ports` 0.0015511512756348
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00027704238891602
(142) DESCRIBE `ports` 0.0016710758209229
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00030899047851562
(144) DESCRIBE `ports` 0.001500129699707
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00028419494628906
(146) DESCRIBE `ports` 0.0014128684997559
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00036811828613281
(148) DESCRIBE `ports` 0.0018429756164551
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00039005279541016
(150) DESCRIBE `ports` 0.0014379024505615
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0003209114074707
(152) DESCRIBE `ports` 0.00164794921875
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00037002563476562
(154) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '53605') AND (sailingdate >= '2018-04-01') AND (sailingdate <= '2018-12-31') 0.0063498020172119
(155) DESCRIBE `avid_specials` 0.0015890598297119
(156) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 53605 and class = 'Cruise') OR (item_id = 770 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0015180110931396
(157) DESCRIBE `cruiselines` 0.0021979808807373
(158) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.0003809928894043
(159) DESCRIBE `orchid_image` 0.0015451908111572
(160) DESCRIBE `cruiselines` 0.0021970272064209
(161) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00034904479980469
(162) DESCRIBE `cruises` 0.0038180351257324
(163) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '34056') 0.00046801567077637
(164) DESCRIBE `ships` 0.003925085067749
(165) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 448))) 0.00065708160400391
(166) DESCRIBE `ships` 0.0038409233093262
(167) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '448') 0.00044393539428711
(168) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034785270690918
(169) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031900405883789
(170) DESCRIBE `itineraries` 0.0018398761749268
(171) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '34056') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00090408325195312
(172) DESCRIBE `ports` 0.0021748542785645
(173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00043702125549316
(174) DESCRIBE `ports` 0.0018970966339111
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00039100646972656
(176) DESCRIBE `ports` 0.0018918514251709
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.0003809928894043
(178) DESCRIBE `sailingdates` 0.0016319751739502
(179) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '34056') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00090503692626953
(180) DESCRIBE `ports` 0.011792898178101
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0030341148376465
(182) DESCRIBE `ports` 0.011115074157715
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.0032789707183838
(184) DESCRIBE `ports` 0.0016899108886719
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.0091278553009033
(186) DESCRIBE `ports` 0.0016710758209229
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.0062639713287354
(188) DESCRIBE `ports` 0.0016858577728271
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0018680095672607
(190) DESCRIBE `ports` 0.0017538070678711
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0079891681671143
(192) DESCRIBE `ports` 0.0016500949859619
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00030994415283203
(194) DESCRIBE `ports` 0.0012481212615967
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00028014183044434
(196) DESCRIBE `ports` 0.0024869441986084
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2565))) 0.00038790702819824
(198) DESCRIBE `ports` 0.002763032913208
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2565') 0.0009620189666748
(200) DESCRIBE `ports` 0.0017719268798828
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00053310394287109
(202) DESCRIBE `ports` 0.0087099075317383
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00033688545227051
(204) DESCRIBE `ports` 0.0013010501861572
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00032711029052734
(206) DESCRIBE `ports` 0.0012669563293457
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00028181076049805
(208) DESCRIBE `ports` 0.0021510124206543
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 370))) 0.0080821514129639
(210) DESCRIBE `ports` 0.0024049282073975
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '370') 0.0005340576171875
(212) DESCRIBE `ports` 0.0025138854980469
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00071191787719727
(214) DESCRIBE `ports` 0.0016570091247559
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00053882598876953
(216) DESCRIBE `ports` 0.0014438629150391
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0091948509216309
(218) DESCRIBE `ports` 0.0015599727630615
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00030708312988281
(220) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '34056') AND (sailingdate >= '2018-04-01') AND (sailingdate <= '2018-12-31') 0.011714935302734
(221) DESCRIBE `avid_specials` 0.0090351104736328
(222) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 34056 and class = 'Cruise') OR (item_id = 448 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0022239685058594
(223) DESCRIBE `cruiselines` 0.0021131038665771
(224) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00047111511230469
(225) DESCRIBE `orchid_image` 0.0015528202056885
(226) DESCRIBE `cruiselines` 0.0030879974365234
(227) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00034308433532715
(228) DESCRIBE `cruises` 0.007951021194458
(229) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66996') 0.0005490779876709
(230) DESCRIBE `ships` 0.0027608871459961
(231) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00060009956359863
(232) DESCRIBE `ships` 0.0029220581054688
(233) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00038504600524902
(234) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028085708618164
(235) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027298927307129
(236) DESCRIBE `itineraries` 0.003709077835083
(237) DESCRIBE `ports` 0.001990795135498
(238) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00048995018005371
(239) DESCRIBE `ports` 0.0012660026550293
(240) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00029683113098145
(241) DESCRIBE `ports` 0.0013821125030518
(242) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00028610229492188
(243) DESCRIBE `sailingdates` 0.0033831596374512
(244) DESCRIBE `ports` 0.0014300346374512
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00035285949707031
(246) DESCRIBE `ports` 0.0012490749359131
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00028109550476074
(248) DESCRIBE `ports` 0.0014841556549072
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00034618377685547
(250) DESCRIBE `ports` 0.00142502784729
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00024080276489258
(252) DESCRIBE `ports` 0.0010921955108643
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0
(254) DESCRIBE `ports` 0.0012991428375244
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0
(256) DESCRIBE `ports` 0.0013630390167236
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00012707710266113
(258) DESCRIBE `ports` 0.0019271373748779
(259) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00081110000610352
(260) DESCRIBE `ports` 0.0020220279693604
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00047993659973145
(262) DESCRIBE `ports` 0.001910924911499
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00039291381835938
(264) DESCRIBE `ports` 0.0017969608306885
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00034809112548828
(266) DESCRIBE `ports` 0.0013208389282227
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.0003349781036377
(268) DESCRIBE `ports` 0.0013630390167236
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00040197372436523
(270) DESCRIBE `ports` 0.0012719631195068
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00032687187194824
(272) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66996') AND (sailingdate >= '2018-04-01') AND (sailingdate <= '2018-12-31') 0.0055580139160156
(273) DESCRIBE `avid_specials` 0.001600980758667
(274) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66996 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.001323938369751
(275) DESCRIBE `cruiselines` 0.0022509098052979
(276) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00044703483581543
(277) DESCRIBE `orchid_image` 0.0021500587463379
(278) DESCRIBE `cruiselines` 0.0031428337097168
(279) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00035691261291504
(280) DESCRIBE `cruises` 0.0029408931732178
(281) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66993') 0.00039505958557129
(282) DESCRIBE `ships` 0.0032320022583008
(283) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 448))) 0.00047588348388672
(284) DESCRIBE `ships` 0.002892017364502
(285) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '448') 0.00032210350036621
(286) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002899169921875
(287) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025582313537598
(288) DESCRIBE `itineraries` 0.0013489723205566
(289) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66993') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00074410438537598
(290) DESCRIBE `ports` 0.0014128684997559
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00032997131347656
(292) DESCRIBE `ports` 0.001514196395874
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00029706954956055
(294) DESCRIBE `ports` 0.0020918846130371
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0
(296) DESCRIBE `sailingdates` 0.00124192237854
(297) DESCRIBE `ports` 0.0022730827331543
(298) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0004270076751709
(299) DESCRIBE `ports` 0.0014989376068115
(300) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00036406517028809
(301) DESCRIBE `ports` 0.0016689300537109
(302) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.0011308193206787
(303) DESCRIBE `ports` 0.0015051364898682
(304) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00014710426330566
(305) DESCRIBE `ports` 0.0016729831695557
(306) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00039792060852051
(307) DESCRIBE `ports` 0.001643180847168
(308) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00035595893859863
(309) DESCRIBE `ports` 0.0016789436340332
(310) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 198))) 0.00040817260742188
(311) DESCRIBE `ports` 0.0018129348754883
(312) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '198') 0.00044703483581543
(313) DESCRIBE `ports` 0.0017950534820557
(314) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00041604042053223
(315) DESCRIBE `ports` 0.0017988681793213
(316) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00039196014404297
(317) DESCRIBE `ports` 0.0017869472503662
(318) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3963))) 0.00043606758117676
(319) DESCRIBE `ports` 0.0018799304962158
(320) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3963') 0.00025105476379395
(321) DESCRIBE `ports` 0.0025599002838135
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00040817260742188
(323) DESCRIBE `ports` 0.0018351078033447
(324) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0
(325) DESCRIBE `ports` 0.0026321411132812
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00073385238647461
(327) DESCRIBE `ports` 0.0013809204101562
(328) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00038886070251465
(329) DESCRIBE `ports` 0.00097799301147461
(330) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.0025238990783691
(331) DESCRIBE `ports` 0.012317895889282
(332) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00045394897460938
(333) DESCRIBE `ports` 0.001446008682251
(334) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0056819915771484
(335) DESCRIBE `ports` 0.013593912124634
(336) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00041890144348145
(337) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66993') AND (sailingdate >= '2018-04-01') AND (sailingdate <= '2018-12-31') 0.0049169063568115
(338) DESCRIBE `avid_specials` 0.0013308525085449
(339) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66993 and class = 'Cruise') OR (item_id = 448 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010180473327637
(340) DESCRIBE `cruiselines` 0.0020139217376709
(341) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00032806396484375
(342) DESCRIBE `orchid_image` 0.0016019344329834
(343) DESCRIBE `cruiselines` 0.0019350051879883
(344) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00033998489379883
(345) DESCRIBE `cruises` 0.00502610206604
(346) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66998') 0.00047612190246582
(347) DESCRIBE `ships` 0.023259878158569
(348) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00025510787963867
(349) DESCRIBE `ships` 0.0040030479431152
(350) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 4.1961669921875E-5
(351) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 5.1975250244141E-5
(352) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 1.4066696166992E-5
(353) DESCRIBE `itineraries` 0.0011489391326904
(354) DESCRIBE `ports` 0.00093698501586914
(355) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00034809112548828
(356) DESCRIBE `ports` 0.0017931461334229
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0038180351257324
(358) DESCRIBE `ports` 0.0013079643249512
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00029802322387695
(360) DESCRIBE `sailingdates` 0.0016729831695557
(361) DESCRIBE `ports` 0.0012788772583008
(362) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00030803680419922
(363) DESCRIBE `ports` 0.0014488697052002
(364) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 1.4066696166992E-5
(365) DESCRIBE `ports` 0.0015439987182617
(366) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0
(367) DESCRIBE `ports` 0.001957893371582
(368) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00037288665771484
(369) DESCRIBE `ports` 0.0016269683837891
(370) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00027298927307129
(371) DESCRIBE `ports` 0.0019330978393555
(372) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00030088424682617
(373) DESCRIBE `ports` 0.0018360614776611
(374) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.002830982208252
(375) DESCRIBE `ports` 0.00060200691223145
(376) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0
(377) DESCRIBE `ports` 0.0014481544494629
(378) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.001107931137085
(379) DESCRIBE `ports` 0.0017189979553223
(380) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00041985511779785
(381) DESCRIBE `ports` 0.0021491050720215
(382) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00043892860412598
(383) DESCRIBE `ports` 0.00095605850219727
(384) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0
(385) DESCRIBE `ports` 0.0017030239105225
(386) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00048398971557617
(387) DESCRIBE `ports` 0.0022351741790771
(388) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.0012650489807129
(389) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66998') AND (sailingdate >= '2018-04-01') AND (sailingdate <= '2018-12-31') 0.0048980712890625
(390) DESCRIBE `avid_specials` 0.0013270378112793
(391) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66998 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0022079944610596
(392) DESCRIBE `cruiselines` 0.0054020881652832
(393) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00076508522033691
(394) DESCRIBE `orchid_image` 0.0024361610412598
(395) DESCRIBE `cruiselines` 0.0029149055480957
(396) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00040698051452637
(397) DESCRIBE `cruises` 0.0028619766235352
(398) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65173') 0.0075011253356934
(399) DESCRIBE `ships` 0.0032699108123779
(400) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 770))) 0.00055789947509766
(401) DESCRIBE `ships` 0.0025348663330078
(402) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '770') 0.0068330764770508
(403) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027799606323242
(404) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025391578674316
(405) DESCRIBE `itineraries` 0.00142502784729
(406) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '65173') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00057291984558105
(407) DESCRIBE `ports` 0.0015900135040283
(408) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00031208992004395
(409) DESCRIBE `ports` 0.0013539791107178
(410) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00035810470581055
(411) DESCRIBE `ports` 0.0095579624176025
(412) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.0003349781036377
(413) DESCRIBE `sailingdates` 0.001209020614624
(414) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '65173') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0008690357208252
(415) DESCRIBE `ports` 0.0018141269683838
(416) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00041007995605469
(417) DESCRIBE `ports` 0.0017569065093994
(418) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00043606758117676
(419) DESCRIBE `ports` 0.0015480518341064
(420) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00042891502380371
(421) DESCRIBE `ports` 0.0015690326690674
(422) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00039887428283691
(423) DESCRIBE `ports` 0.0016181468963623
(424) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.00033307075500488
(425) DESCRIBE `ports` 0.0013818740844727
(426) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.00043296813964844
(427) DESCRIBE `ports` 0.0013699531555176
(428) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00033402442932129
(429) DESCRIBE `ports` 0.0015208721160889
(430) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00032687187194824
(431) DESCRIBE `ports` 0.0016140937805176
(432) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00040102005004883
(433) DESCRIBE `ports` 0.0014960765838623
(434) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00028300285339355
(435) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '65173') AND (sailingdate >= '2018-04-01') AND (sailingdate <= '2018-12-31') 0.0058660507202148
(436) DESCRIBE `avid_specials` 0.0017600059509277
(437) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65173 and class = 'Cruise') OR (item_id = 770 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0017430782318115
(438) DESCRIBE `cruiselines` 0.002324104309082
(439) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00038003921508789
(440) DESCRIBE `orchid_image` 0.0014832019805908
(441) DESCRIBE `cruiselines` 0.0018880367279053
(442) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00035190582275391
(443) DESCRIBE `cruises` 0.0025060176849365
(444) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66995') 0.00033998489379883
(445) DESCRIBE `ships` 0.0026359558105469
(446) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 448))) 0.00034809112548828
(447) DESCRIBE `ships` 0.0032119750976562
(448) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '448') 0.00049209594726562
(449) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034284591674805
(450) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030994415283203
(451) DESCRIBE `itineraries` 0.0019621849060059
(452) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66995') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00070691108703613
(453) DESCRIBE `ports` 0.001521110534668
(454) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00034713745117188
(455) DESCRIBE `ports` 0.0014760494232178
(456) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00033402442932129
(457) DESCRIBE `ports` 0.0013198852539062
(458) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00032591819763184
(459) DESCRIBE `sailingdates` 0.0011379718780518
(460) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66995') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00055503845214844
(461) DESCRIBE `ports` 0.0015878677368164
(462) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00032210350036621
(463) DESCRIBE `ports` 0.0013890266418457
(464) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00029301643371582
(465) DESCRIBE `ports` 0.0013201236724854
(466) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00037813186645508
(467) DESCRIBE `ports` 0.0013730525970459
(468) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00028800964355469
(469) DESCRIBE `ports` 0.0016829967498779
(470) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00042390823364258
(471) DESCRIBE `ports` 0.0016648769378662
(472) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00031685829162598
(473) DESCRIBE `ports` 0.0016560554504395
(474) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00034499168395996
(475) DESCRIBE `ports` 0.0015459060668945
(476) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00028896331787109
(477) DESCRIBE `ports` 0.0012879371643066
(478) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 587))) 0.00030612945556641
(479) DESCRIBE `ports` 0.0012738704681396
(480) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '587') 0.00027108192443848
(481) DESCRIBE `ports` 0.0013539791107178
(482) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.00037097930908203
(483) DESCRIBE `ports` 0.0015778541564941
(484) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.00030803680419922
(485) DESCRIBE `ports` 0.0013699531555176
(486) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 696))) 0.00036501884460449
(487) DESCRIBE `ports` 0.0013229846954346
(488) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '696') 0.00031495094299316
(489) DESCRIBE `ports` 0.0012731552124023
(490) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00031185150146484
(491) DESCRIBE `ports` 0.0018308162689209
(492) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.0003049373626709
(493) DESCRIBE `ports` 0.0014770030975342
(494) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00035881996154785
(495) DESCRIBE `ports` 0.0014898777008057
(496) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00040888786315918
(497) DESCRIBE `ports` 0.00087499618530273
(498) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.0003809928894043
(499) DESCRIBE `ports` 0.0018529891967773
(500) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00037217140197754
(501) DESCRIBE `ports` 0.001370906829834
(502) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00032210350036621
(503) DESCRIBE `ports` 0.0012588500976562
(504) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00029587745666504
(505) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66995') AND (sailingdate >= '2018-04-01') AND (sailingdate <= '2018-12-31') 0.0045311450958252
(506) DESCRIBE `avid_specials` 0.0020129680633545
(507) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66995 and class = 'Cruise') OR (item_id = 448 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010101795196533
(508) DESCRIBE `cruiselines` 0.0019500255584717
(509) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00047588348388672
(510) DESCRIBE `orchid_image` 0.0021641254425049
(511) DESCRIBE `cruiselines` 0.0024800300598145
(512) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00040888786315918
(513) DESCRIBE `ships` 0.0042228698730469
(514) SELECT `ships`.* FROM `ships` WHERE (id IN ('770', '93', '448')) ORDER BY FIND_IN_SET(id, '770,93,448') 0.00087499618530273
(515) DESCRIBE `cruisetypes` 0.0016829967498779
(516) SELECT DISTINCT `cruisetypes`.* FROM `cruisetypes` LEFT JOIN `cruises_and_specials` ON cruisetypes.id = cruises_and_specials.cruisetype_id WHERE (cruises_and_specials.destination_id = '22') AND (cruises_and_specials.cruiseline_id = '20') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC 0.041783094406128
(517) DESCRIBE `cruiselines` 0.0030109882354736
(518) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00049209594726562
(519) DESCRIBE `destinations` 0.0025901794433594
(520) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 22))) 0.00045490264892578
(521) DESCRIBE `destinations` 0.002626895904541
(522) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 22))) 0.00051712989807129
(523) DESCRIBE `cruiselines` 0.0026829242706299
(524) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00045299530029297