or, enquire about your chosen options

  1. Catch Up on Cruising: Latest News in bite size!
  2. Drinks Package Comparison
  3. Regal Princess heads down under!
  4. Catch Up on Cruising: Latest News in bite size!
  5. What happens when you cruise back to back?

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

Total elapsed time: 1.1451547145844

# Query Time
(1) connect 0.0010051727294922
(2) DESCRIBE `cruises` 0.0032329559326172
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (75314, 75299, 75301, 75300, 75316, 75317, 75318, 75328, 75319, 75326)) ORDER BY FIND_IN_SET(id, '75314,75299,75301,75300,75316,75317,75318,75328,75319,75326') 0.0021800994873047
(4) DESCRIBE `cruises` 0.0033259391784668
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75314') 0.0004420280456543
(6) DESCRIBE `ships` 0.0029709339141846
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 780))) 0.0003969669342041
(8) DESCRIBE `ships` 0.0029609203338623
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '780') 0.00039410591125488
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0002589225769043
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00024700164794922
(12) DESCRIBE `itineraries` 0.0016858577728271
(13) DESCRIBE `ports` 0.0016000270843506
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0004420280456543
(15) DESCRIBE `ports` 0.0014619827270508
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00031208992004395
(17) DESCRIBE `ports` 0.001460075378418
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.0003349781036377
(19) DESCRIBE `sailingdates` 0.0011940002441406
(20) DESCRIBE `ports` 0.0015759468078613
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00041007995605469
(22) DESCRIBE `ports` 0.0015580654144287
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00035190582275391
(24) DESCRIBE `ports` 0.0017361640930176
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.00041580200195312
(26) DESCRIBE `ports` 0.001474142074585
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00033998489379883
(28) DESCRIBE `ports` 0.0015890598297119
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00032401084899902
(30) DESCRIBE `ports` 0.0017719268798828
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00037980079650879
(32) DESCRIBE `ports` 0.0015270709991455
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3978))) 0.00044989585876465
(34) DESCRIBE `ports` 0.0018589496612549
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3978') 0.00045204162597656
(36) DESCRIBE `ports` 0.0019159317016602
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00046992301940918
(38) DESCRIBE `ports` 0.0018739700317383
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00037789344787598
(40) DESCRIBE `ports` 0.0015439987182617
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00041818618774414
(42) DESCRIBE `ports` 0.0018019676208496
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00039410591125488
(44) DESCRIBE `ports` 0.0018680095672607
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.0004570484161377
(46) DESCRIBE `ports` 0.0018320083618164
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00041389465332031
(48) DESCRIBE `ports` 0.0018999576568604
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.00039911270141602
(50) DESCRIBE `ports` 0.0016229152679443
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00035190582275391
(52) DESCRIBE `ports` 0.0015771389007568
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00042080879211426
(54) DESCRIBE `ports` 0.0016069412231445
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00036191940307617
(56) DESCRIBE `ports` 0.0015671253204346
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00036787986755371
(58) DESCRIBE `ports` 0.0016310214996338
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00035285949707031
(60) DESCRIBE `ports` 0.0016310214996338
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00044894218444824
(62) DESCRIBE `ports` 0.0016429424285889
(63) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00037693977355957
(64) DESCRIBE `ports` 0.0016179084777832
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00040292739868164
(66) DESCRIBE `ports` 0.0017058849334717
(67) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00036501884460449
(68) DESCRIBE `ports` 0.0016322135925293
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00037693977355957
(70) DESCRIBE `ports` 0.0015881061553955
(71) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00034999847412109
(72) DESCRIBE `ports` 0.001633882522583
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00037193298339844
(74) DESCRIBE `ports` 0.0016000270843506
(75) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00033712387084961
(76) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '75314') AND (sailingdate >= '2019-12-06') AND (sailingdate <= '2020-03-02') 0.012368202209473
(77) DESCRIBE `avid_specials` 0.0017349720001221
(78) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75314 and class = 'Cruise') OR (item_id = 780 AND class = 'Ship') OR (item_id = 15 AND class = 'CruiseLine') OR (item_id = 43 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.0018079280853271
(79) DESCRIBE `cruiselines` 0.002626895904541
(80) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.00055599212646484
(81) DESCRIBE `orchid_image` 0.0020291805267334
(82) DESCRIBE `cruiselines` 0.0025539398193359
(83) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.00047206878662109
(84) DESCRIBE `cruises` 0.0032730102539062
(85) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75299') 0.00051403045654297
(86) DESCRIBE `ships` 0.0047690868377686
(87) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 780))) 0.00069808959960938
(88) DESCRIBE `ships` 0.0034217834472656
(89) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '780') 9.4175338745117E-5
(90) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00047492980957031
(91) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0
(92) DESCRIBE `itineraries` 0.002363920211792
(93) DESCRIBE `ports` 0.003558874130249
(94) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00073409080505371
(95) DESCRIBE `ports` 0.0045349597930908
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.0013530254364014
(97) DESCRIBE `ports` 0.0023250579833984
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00048208236694336
(99) DESCRIBE `sailingdates` 0.0022289752960205
(100) DESCRIBE `ports` 0.0022780895233154
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00051403045654297
(102) DESCRIBE `ports` 0.0020918846130371
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00042486190795898
(104) DESCRIBE `ports` 0.0025789737701416
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00061392784118652
(106) DESCRIBE `ports` 0.0020899772644043
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00041103363037109
(108) DESCRIBE `ports` 0.00211501121521
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.00037503242492676
(110) DESCRIBE `ports` 0.0020370483398438
(111) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00047707557678223
(112) DESCRIBE `ports` 0.0016329288482666
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.00059700012207031
(114) DESCRIBE `ports` 0.0024220943450928
(115) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00052094459533691
(116) DESCRIBE `ports` 0.0021800994873047
(117) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00064611434936523
(118) DESCRIBE `ports` 0.0020608901977539
(119) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00042605400085449
(120) DESCRIBE `ports` 0.001986026763916
(121) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00052499771118164
(122) DESCRIBE `ports` 0.0019919872283936
(123) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00049805641174316
(124) DESCRIBE `ports` 0.0020108222961426
(125) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00086688995361328
(126) DESCRIBE `ports` 0.0021638870239258
(127) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00036096572875977
(128) DESCRIBE `ports` 0.0024161338806152
(129) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00045418739318848
(130) DESCRIBE `ports` 0.0017979145050049
(131) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.0013799667358398
(132) DESCRIBE `ports` 0.0023279190063477
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00063490867614746
(134) DESCRIBE `ports` 0.0030529499053955
(135) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00034999847412109
(136) DESCRIBE `ports` 0.001845121383667
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0
(138) DESCRIBE `ports` 0.0022420883178711
(139) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00068902969360352
(140) DESCRIBE `ports` 0.0017259120941162
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00047802925109863
(142) DESCRIBE `ports` 0.0017299652099609
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00050997734069824
(144) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '75299') AND (sailingdate >= '2019-12-06') AND (sailingdate <= '2020-03-02') 0.010117769241333
(145) DESCRIBE `avid_specials` 0.0013999938964844
(146) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75299 and class = 'Cruise') OR (item_id = 780 AND class = 'Ship') OR (item_id = 15 AND class = 'CruiseLine') OR (item_id = 43 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.0016360282897949
(147) DESCRIBE `cruiselines` 0.0027930736541748
(148) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.00059294700622559
(149) DESCRIBE `orchid_image` 0.0021438598632812
(150) DESCRIBE `cruiselines` 0.0027279853820801
(151) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.00047087669372559
(152) DESCRIBE `cruises` 0.0043251514434814
(153) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75301') 0.00055885314941406
(154) DESCRIBE `ships` 0.0041129589080811
(155) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 780))) 0.013658046722412
(156) DESCRIBE `ships` 0.0036089420318604
(157) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '780') 0.00046801567077637
(158) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00031614303588867
(159) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00031113624572754
(160) DESCRIBE `itineraries` 0.0017158985137939
(161) DESCRIBE `ports` 0.0018999576568604
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0012929439544678
(163) DESCRIBE `ports` 0.0016460418701172
(164) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00039386749267578
(165) DESCRIBE `ports` 0.001615047454834
(166) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.0037939548492432
(167) DESCRIBE `sailingdates` 0.0015518665313721
(168) DESCRIBE `ports` 0.0059669017791748
(169) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.009918212890625
(170) DESCRIBE `ports` 0.0019629001617432
(171) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00056791305541992
(172) DESCRIBE `ports` 0.0018348693847656
(173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.00051403045654297
(174) DESCRIBE `ports` 0.0091178417205811
(175) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00042200088500977
(176) DESCRIBE `ports` 0.0018250942230225
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.00037288665771484
(178) DESCRIBE `ports` 0.0017991065979004
(179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00038909912109375
(180) DESCRIBE `ports` 0.001708984375
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.0077788829803467
(182) DESCRIBE `ports` 0.0022389888763428
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.0010750293731689
(184) DESCRIBE `ports` 0.0066461563110352
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00055313110351562
(186) DESCRIBE `ports` 0.0049271583557129
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00054097175598145
(188) DESCRIBE `ports` 0.001967191696167
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00062179565429688
(190) DESCRIBE `ports` 0.0020029544830322
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00042915344238281
(192) DESCRIBE `ports` 0.001823902130127
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0010080337524414
(194) DESCRIBE `ports` 0.0019130706787109
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00043606758117676
(196) DESCRIBE `ports` 0.0019140243530273
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00043201446533203
(198) DESCRIBE `ports` 0.0018138885498047
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00041699409484863
(200) DESCRIBE `ports` 0.0018398761749268
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00044107437133789
(202) DESCRIBE `ports` 0.0018808841705322
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00041508674621582
(204) DESCRIBE `ports` 0.0017838478088379
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00045204162597656
(206) DESCRIBE `ports` 0.0018670558929443
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00051784515380859
(208) DESCRIBE `ports` 0.0017862319946289
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3978))) 0.00043582916259766
(210) DESCRIBE `ports` 0.0017819404602051
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3978') 0.00040411949157715
(212) DESCRIBE `ports` 0.0018141269683838
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00042295455932617
(214) DESCRIBE `ports` 0.0018668174743652
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00039100646972656
(216) DESCRIBE `ports` 0.001884937286377
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00048398971557617
(218) DESCRIBE `ports` 0.0018839836120605
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.0003969669342041
(220) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '75301') AND (sailingdate >= '2019-12-06') AND (sailingdate <= '2020-03-02') 0.0095789432525635
(221) DESCRIBE `avid_specials` 0.0019350051879883
(222) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75301 and class = 'Cruise') OR (item_id = 780 AND class = 'Ship') OR (item_id = 15 AND class = 'CruiseLine') OR (item_id = 43 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.0018889904022217
(223) DESCRIBE `cruiselines` 0.002763032913208
(224) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.00053596496582031
(225) DESCRIBE `orchid_image` 0.005558967590332
(226) DESCRIBE `cruiselines` 0.0028350353240967
(227) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.00044894218444824
(228) DESCRIBE `cruises` 0.0059990882873535
(229) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75300') 0.00053310394287109
(230) DESCRIBE `ships` 0.0042939186096191
(231) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 780))) 0.00067400932312012
(232) DESCRIBE `ships` 0.0041739940643311
(233) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '780') 0.00061893463134766
(234) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00036501884460449
(235) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034308433532715
(236) DESCRIBE `itineraries` 0.00211501121521
(237) DESCRIBE `ports` 0.002316951751709
(238) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00021600723266602
(239) DESCRIBE `ports` 0.0015790462493896
(240) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00035810470581055
(241) DESCRIBE `ports` 0.001600980758667
(242) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00039100646972656
(243) DESCRIBE `sailingdates` 0.001162052154541
(244) DESCRIBE `ports` 0.0017218589782715
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00049114227294922
(246) DESCRIBE `ports` 0.0019850730895996
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00038790702819824
(248) DESCRIBE `ports` 0.0018310546875
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.0005640983581543
(250) DESCRIBE `ports` 0.0019149780273438
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00049304962158203
(252) DESCRIBE `ports` 0.0033998489379883
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.0005190372467041
(254) DESCRIBE `ports` 0.0018539428710938
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00042200088500977
(256) DESCRIBE `ports` 0.0018258094787598
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00046682357788086
(258) DESCRIBE `ports` 0.0017929077148438
(259) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.0004270076751709
(260) DESCRIBE `ports` 0.0010998249053955
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.0006711483001709
(262) DESCRIBE `ports` 0.0023188591003418
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00037693977355957
(264) DESCRIBE `ports` 0.001701831817627
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00062799453735352
(266) DESCRIBE `ports` 0.001755952835083
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00025701522827148
(268) DESCRIBE `ports` 0.001539945602417
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00033688545227051
(270) DESCRIBE `ports` 0.0020101070404053
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00045895576477051
(272) DESCRIBE `ports` 0.0017669200897217
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00064992904663086
(274) DESCRIBE `ports` 0.002108097076416
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00043988227844238
(276) DESCRIBE `ports` 0.001845121383667
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00036191940307617
(278) DESCRIBE `ports` 0.0014798641204834
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00031113624572754
(280) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '75300') AND (sailingdate >= '2019-12-06') AND (sailingdate <= '2020-03-02') 0.0081560611724854
(281) DESCRIBE `avid_specials` 0.0018870830535889
(282) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75300 and class = 'Cruise') OR (item_id = 780 AND class = 'Ship') OR (item_id = 15 AND class = 'CruiseLine') OR (item_id = 43 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.0019321441650391
(283) DESCRIBE `cruiselines` 0.0028419494628906
(284) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.00052213668823242
(285) DESCRIBE `orchid_image` 0.0020198822021484
(286) DESCRIBE `cruiselines` 0.0027351379394531
(287) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.00044894218444824
(288) DESCRIBE `cruises` 0.0033960342407227
(289) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75316') 0.00052595138549805
(290) DESCRIBE `ships` 0.003521203994751
(291) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 780))) 0.00074481964111328
(292) DESCRIBE `ships` 0.0041449069976807
(293) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '780') 0.00050902366638184
(294) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00031590461730957
(295) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00023293495178223
(296) DESCRIBE `itineraries` 0.0018579959869385
(297) DESCRIBE `ports` 0.0072228908538818
(298) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00041604042053223
(299) DESCRIBE `ports` 0.0016000270843506
(300) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0005028247833252
(301) DESCRIBE `ports` 0.0014421939849854
(302) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.0005340576171875
(303) DESCRIBE `sailingdates` 0.0024199485778809
(304) DESCRIBE `ports` 0.0034401416778564
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00050210952758789
(306) DESCRIBE `ports` 0.0015509128570557
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00041484832763672
(308) DESCRIBE `ports` 0.0018610954284668
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00040006637573242
(310) DESCRIBE `ports` 0.0016210079193115
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00030708312988281
(312) DESCRIBE `ports` 0.0016169548034668
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3978))) 0.00036311149597168
(314) DESCRIBE `ports` 0.0016660690307617
(315) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3978') 0.00041699409484863
(316) DESCRIBE `ports` 0.0018050670623779
(317) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00044703483581543
(318) DESCRIBE `ports` 0.0018188953399658
(319) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00047111511230469
(320) DESCRIBE `ports` 0.0018401145935059
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00043797492980957
(322) DESCRIBE `ports` 0.0016701221466064
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00039815902709961
(324) DESCRIBE `ports` 0.0093660354614258
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.00061798095703125
(326) DESCRIBE `ports` 0.0020668506622314
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00033903121948242
(328) DESCRIBE `ports` 0.0014519691467285
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00038504600524902
(330) DESCRIBE `ports` 0.0017480850219727
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.009591817855835
(332) DESCRIBE `ports` 0.0017380714416504
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00042009353637695
(334) DESCRIBE `ports` 0.0015339851379395
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00037002563476562
(336) DESCRIBE `ports` 0.0016288757324219
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00036096572875977
(338) DESCRIBE `ports` 0.0016169548034668
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00039005279541016
(340) DESCRIBE `ports` 0.0016660690307617
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.0090110301971436
(342) DESCRIBE `ports` 0.0016160011291504
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00040102005004883
(344) DESCRIBE `ports` 0.0015878677368164
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00038790702819824
(346) DESCRIBE `ports` 0.0014638900756836
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00035786628723145
(348) DESCRIBE `ports` 0.0015029907226562
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00039887428283691
(350) DESCRIBE `ports` 0.0092239379882812
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00050020217895508
(352) DESCRIBE `ports` 0.0018110275268555
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00045490264892578
(354) DESCRIBE `ports` 0.0019440650939941
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00038385391235352
(356) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '75316') AND (sailingdate >= '2019-12-06') AND (sailingdate <= '2020-03-02') 0.025491952896118
(357) DESCRIBE `avid_specials` 0.0018248558044434
(358) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75316 and class = 'Cruise') OR (item_id = 780 AND class = 'Ship') OR (item_id = 15 AND class = 'CruiseLine') OR (item_id = 43 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.0021898746490479
(359) DESCRIBE `cruiselines` 0.0029489994049072
(360) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.0056090354919434
(361) DESCRIBE `orchid_image` 0.001924991607666
(362) DESCRIBE `cruiselines` 0.0027220249176025
(363) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.00052595138549805
(364) DESCRIBE `cruises` 0.0039079189300537
(365) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75317') 0.0080201625823975
(366) DESCRIBE `ships` 0.0078361034393311
(367) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 780))) 0.00066494941711426
(368) DESCRIBE `ships` 0.0086891651153564
(369) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '780') 0.00050902366638184
(370) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00038290023803711
(371) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034689903259277
(372) DESCRIBE `itineraries` 0.0018131732940674
(373) DESCRIBE `ports` 0.0018370151519775
(374) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00044393539428711
(375) DESCRIBE `ports` 0.0013291835784912
(376) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00032711029052734
(377) DESCRIBE `ports` 0.0012819766998291
(378) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00028395652770996
(379) DESCRIBE `sailingdates` 0.0013930797576904
(380) DESCRIBE `ports` 0.00071597099304199
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00036311149597168
(382) DESCRIBE `ports` 0.0018789768218994
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00036478042602539
(384) DESCRIBE `ports` 0.0016071796417236
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3978))) 0.0070769786834717
(386) DESCRIBE `ports` 0.0018179416656494
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3978') 0.00046396255493164
(388) DESCRIBE `ports` 0.0017299652099609
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00035190582275391
(390) DESCRIBE `ports` 0.0014221668243408
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00031685829162598
(392) DESCRIBE `ports` 0.0018110275268555
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00042200088500977
(394) DESCRIBE `ports` 0.0072379112243652
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00042581558227539
(396) DESCRIBE `ports` 0.0014939308166504
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.00033783912658691
(398) DESCRIBE `ports` 0.001356840133667
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00034594535827637
(400) DESCRIBE `ports` 0.0017919540405273
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00044393539428711
(402) DESCRIBE `ports` 0.0071101188659668
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.0015478134155273
(404) DESCRIBE `ports` 0.0022101402282715
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00054097175598145
(406) DESCRIBE `ports` 0.0018830299377441
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00040793418884277
(408) DESCRIBE `ports` 0.001986026763916
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00045394897460938
(410) DESCRIBE `ports` 0.0018959045410156
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.0005040168762207
(412) DESCRIBE `ports` 0.001406192779541
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00046682357788086
(414) DESCRIBE `ports` 0.0018150806427002
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00038385391235352
(416) DESCRIBE `ports` 0.0015749931335449
(417) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00043296813964844
(418) DESCRIBE `ports` 0.0020442008972168
(419) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00040292739868164
(420) DESCRIBE `ports` 0.002000093460083
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00048398971557617
(422) DESCRIBE `ports` 0.0017800331115723
(423) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00047516822814941
(424) DESCRIBE `ports` 0.0017848014831543
(425) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00036001205444336
(426) DESCRIBE `ports` 0.0024120807647705
(427) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00039792060852051
(428) DESCRIBE `ports` 0.0018110275268555
(429) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00034093856811523
(430) DESCRIBE `ports` 0.0015439987182617
(431) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00039100646972656
(432) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '75317') AND (sailingdate >= '2019-12-06') AND (sailingdate <= '2020-03-02') 0.0061070919036865
(433) DESCRIBE `avid_specials` 0.0015439987182617
(434) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75317 and class = 'Cruise') OR (item_id = 780 AND class = 'Ship') OR (item_id = 15 AND class = 'CruiseLine') OR (item_id = 43 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.011008024215698
(435) DESCRIBE `cruiselines` 0.0025060176849365
(436) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.00023412704467773
(437) DESCRIBE `orchid_image` 0.001248836517334
(438) DESCRIBE `cruiselines` 0.0050480365753174
(439) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.007174015045166
(440) DESCRIBE `cruises` 0.0030848979949951
(441) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75318') 0.00040388107299805
(442) DESCRIBE `ships` 0.0032639503479004
(443) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 780))) 0.00067901611328125
(444) DESCRIBE `ships` 0.0038409233093262
(445) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '780') 0.00053620338439941
(446) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035786628723145
(447) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034785270690918
(448) DESCRIBE `itineraries` 0.0019910335540771
(449) DESCRIBE `ports` 0.0020608901977539
(450) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0
(451) DESCRIBE `ports` 0.0017220973968506
(452) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0
(453) DESCRIBE `ports` 0.0018880367279053
(454) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.001121997833252
(455) DESCRIBE `sailingdates` 0.00130295753479
(456) DESCRIBE `ports` 0.0018310546875
(457) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00054097175598145
(458) DESCRIBE `ports` 0.0015110969543457
(459) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00036096572875977
(460) DESCRIBE `ports` 0.0015008449554443
(461) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3978))) 0.00039815902709961
(462) DESCRIBE `ports` 0.0018391609191895
(463) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3978') 0.00044798851013184
(464) DESCRIBE `ports` 0.0019538402557373
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00049400329589844
(466) DESCRIBE `ports` 0.0020298957824707
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.0004889965057373
(468) DESCRIBE `ports` 0.002032995223999
(469) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00052905082702637
(470) DESCRIBE `ports` 0.0017070770263672
(471) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00034093856811523
(472) DESCRIBE `ports` 0.0015189647674561
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.00037312507629395
(474) DESCRIBE `ports` 0.0016520023345947
(475) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.0003809928894043
(476) DESCRIBE `ports` 0.0016958713531494
(477) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00044608116149902
(478) DESCRIBE `ports` 0.0017158985137939
(479) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00048208236694336
(480) DESCRIBE `ports` 0.0019819736480713
(481) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00059604644775391
(482) DESCRIBE `ports` 0.0020730495452881
(483) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00047397613525391
(484) DESCRIBE `ports` 0.0019011497497559
(485) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00052118301391602
(486) DESCRIBE `ports` 0.0018861293792725
(487) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00045299530029297
(488) DESCRIBE `ports` 0.001417875289917
(489) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00039196014404297
(490) DESCRIBE `ports` 0.0016188621520996
(491) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00039410591125488
(492) DESCRIBE `ports` 0.0015871524810791
(493) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00046205520629883
(494) DESCRIBE `ports` 0.0015861988067627
(495) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00034022331237793
(496) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '75318') AND (sailingdate >= '2019-12-06') AND (sailingdate <= '2020-03-02') 0.0065219402313232
(497) DESCRIBE `avid_specials` 0.0019960403442383
(498) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75318 and class = 'Cruise') OR (item_id = 780 AND class = 'Ship') OR (item_id = 15 AND class = 'CruiseLine') OR (item_id = 43 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.002007007598877
(499) DESCRIBE `cruiselines` 0.003101110458374
(500) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.00021696090698242
(501) DESCRIBE `orchid_image` 0.0032808780670166
(502) DESCRIBE `cruiselines` 0.0024509429931641
(503) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.0010678768157959
(504) DESCRIBE `cruises` 0.0057559013366699
(505) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75328') 0.00081586837768555
(506) DESCRIBE `ships` 0.0057389736175537
(507) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 780))) 0.00072216987609863
(508) DESCRIBE `ships` 0.0030860900878906
(509) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '780') 0.00095415115356445
(510) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00060892105102539
(511) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0
(512) DESCRIBE `itineraries` 0.0019690990447998
(513) DESCRIBE `ports` 0.0017681121826172
(514) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00037193298339844
(515) DESCRIBE `ports` 0.0014410018920898
(516) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00040006637573242
(517) DESCRIBE `ports` 0.001345157623291
(518) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00031805038452148
(519) DESCRIBE `sailingdates` 0.0011999607086182
(520) DESCRIBE `ports` 0.0017099380493164
(521) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00040006637573242
(522) DESCRIBE `ports` 0.0014400482177734
(523) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00030803680419922
(524) DESCRIBE `ports` 0.0015919208526611
(525) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.0003359317779541
(526) DESCRIBE `ports` 0.0014591217041016
(527) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00034904479980469
(528) DESCRIBE `ports` 0.0014200210571289
(529) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00033998489379883
(530) DESCRIBE `ports` 0.0013630390167236
(531) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00038599967956543
(532) DESCRIBE `ports` 0.0014159679412842
(533) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00033998489379883
(534) DESCRIBE `ports` 0.001262903213501
(535) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00027894973754883
(536) DESCRIBE `ports` 0.001291036605835
(537) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00030708312988281
(538) DESCRIBE `ports` 0.0013329982757568
(539) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00028395652770996
(540) DESCRIBE `ports` 0.0013289451599121
(541) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00029587745666504
(542) DESCRIBE `ports` 0.0012550354003906
(543) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00026893615722656
(544) DESCRIBE `ports` 0.0014488697052002
(545) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00036096572875977
(546) DESCRIBE `ports` 0.001291036605835
(547) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00032591819763184
(548) DESCRIBE `ports` 0.0023279190063477
(549) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00041794776916504
(550) DESCRIBE `ports` 0.0016131401062012
(551) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00037121772766113
(552) DESCRIBE `ports` 0.0014848709106445
(553) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00037693977355957
(554) DESCRIBE `ports` 0.0018229484558105
(555) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00040698051452637
(556) DESCRIBE `ports` 0.0017189979553223
(557) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00045204162597656
(558) DESCRIBE `ports` 0.0018548965454102
(559) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00041818618774414
(560) DESCRIBE `ports` 0.001662015914917
(561) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00048613548278809
(562) DESCRIBE `ports` 0.0017740726470947
(563) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00043582916259766
(564) DESCRIBE `ports` 0.0016710758209229
(565) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.00044107437133789
(566) DESCRIBE `ports` 0.0021378993988037
(567) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00034189224243164
(568) DESCRIBE `ports` 0.001884937286377
(569) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00037002563476562
(570) DESCRIBE `ports` 0.0013689994812012
(571) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0
(572) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '75328') AND (sailingdate >= '2019-12-06') AND (sailingdate <= '2020-03-02') 0.007544994354248
(573) DESCRIBE `avid_specials` 0.0038621425628662
(574) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75328 and class = 'Cruise') OR (item_id = 780 AND class = 'Ship') OR (item_id = 15 AND class = 'CruiseLine') OR (item_id = 43 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.00053000450134277
(575) DESCRIBE `cruiselines` 0.0020968914031982
(576) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.00039792060852051
(577) DESCRIBE `orchid_image` 0.0020592212677002
(578) DESCRIBE `cruiselines` 0.0026259422302246
(579) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.00042295455932617
(580) DESCRIBE `cruises` 0.0027561187744141
(581) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75319') 0.00043892860412598
(582) DESCRIBE `ships` 0.0039629936218262
(583) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 780))) 0.00057792663574219
(584) DESCRIBE `ships` 0.0039920806884766
(585) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '780') 0.00042986869812012
(586) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00033998489379883
(587) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00032186508178711
(588) DESCRIBE `itineraries` 0.0017950534820557
(589) DESCRIBE `ports` 0.0017571449279785
(590) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0
(591) DESCRIBE `ports` 0.0015819072723389
(592) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00033807754516602
(593) DESCRIBE `ports` 0.0015869140625
(594) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.0012290477752686
(595) DESCRIBE `sailingdates` 0.0015459060668945
(596) DESCRIBE `ports` 0.001507043838501
(597) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.001237154006958
(598) DESCRIBE `ports` 0.0011918544769287
(599) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.0004420280456543
(600) DESCRIBE `ports` 0.0018470287322998
(601) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.00041103363037109
(602) DESCRIBE `ports` 0.0019211769104004
(603) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00033211708068848
(604) DESCRIBE `ports` 0.0015289783477783
(605) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 1.2874603271484E-5
(606) DESCRIBE `ports` 0.0012390613555908
(607) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.0003819465637207
(608) DESCRIBE `ports` 0.0015261173248291
(609) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00033116340637207
(610) DESCRIBE `ports` 0.0013370513916016
(611) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0
(612) DESCRIBE `ports` 0.0014779567718506
(613) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00044703483581543
(614) DESCRIBE `ports` 0.0010061264038086
(615) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00041818618774414
(616) DESCRIBE `ports` 0.0018911361694336
(617) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00040388107299805
(618) DESCRIBE `ports` 0.0018870830535889
(619) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00038290023803711
(620) DESCRIBE `ports` 0.0025548934936523
(621) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0004432201385498
(622) DESCRIBE `ports` 0.0017778873443604
(623) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0
(624) DESCRIBE `ports` 0.0011098384857178
(625) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00031495094299316
(626) DESCRIBE `ports` 0.0017991065979004
(627) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00040006637573242
(628) DESCRIBE `ports` 0.0018100738525391
(629) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 2.5033950805664E-5
(630) DESCRIBE `ports` 0.0026419162750244
(631) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00048398971557617
(632) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '75319') AND (sailingdate >= '2019-12-06') AND (sailingdate <= '2020-03-02') 0.0060811042785645
(633) DESCRIBE `avid_specials` 0.00177001953125
(634) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75319 and class = 'Cruise') OR (item_id = 780 AND class = 'Ship') OR (item_id = 15 AND class = 'CruiseLine') OR (item_id = 43 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.0018820762634277
(635) DESCRIBE `cruiselines` 0.0020430088043213
(636) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.00042200088500977
(637) DESCRIBE `orchid_image` 0.001741886138916
(638) DESCRIBE `cruiselines` 0.0020639896392822
(639) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.0003349781036377
(640) DESCRIBE `cruises` 0.0030851364135742
(641) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75326') 0.00051379203796387
(642) DESCRIBE `ships` 0.0032310485839844
(643) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 780))) 0.0005948543548584
(644) DESCRIBE `ships` 0.0038759708404541
(645) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '780') 0.00045394897460938
(646) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00027608871459961
(647) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 3.0994415283203E-5
(648) DESCRIBE `itineraries` 0.0018770694732666
(649) DESCRIBE `ports` 0.0020589828491211
(650) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00045609474182129
(651) DESCRIBE `ports` 0.0019400119781494
(652) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00058794021606445
(653) DESCRIBE `ports` 0.002406120300293
(654) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00041604042053223
(655) DESCRIBE `sailingdates` 0.0029029846191406
(656) DESCRIBE `ports` 0.0014190673828125
(657) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00049400329589844
(658) DESCRIBE `ports` 0.0017049312591553
(659) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.0003511905670166
(660) DESCRIBE `ports` 0.001446008682251
(661) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.00037097930908203
(662) DESCRIBE `ports` 0.001849889755249
(663) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00047397613525391
(664) DESCRIBE `ports` 0.0018990039825439
(665) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00051593780517578
(666) DESCRIBE `ports` 0.0018620491027832
(667) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00042414665222168
(668) DESCRIBE `ports` 0.0018248558044434
(669) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00043392181396484
(670) DESCRIBE `ports` 0.0018448829650879
(671) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00041103363037109
(672) DESCRIBE `ports` 0.0034310817718506
(673) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00049805641174316
(674) DESCRIBE `ports` 0.0018100738525391
(675) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00031781196594238
(676) DESCRIBE `ports` 0.0019299983978271
(677) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.0010368824005127
(678) DESCRIBE `ports` 0.0015230178833008
(679) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00039505958557129
(680) DESCRIBE `ports` 0.0015928745269775
(681) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0013980865478516
(682) DESCRIBE `ports` 0.0016050338745117
(683) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0
(684) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '75326') AND (sailingdate >= '2019-12-06') AND (sailingdate <= '2020-03-02') 0.0073800086975098
(685) DESCRIBE `avid_specials` 0.0019710063934326
(686) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75326 and class = 'Cruise') OR (item_id = 780 AND class = 'Ship') OR (item_id = 15 AND class = 'CruiseLine') OR (item_id = 43 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.002007007598877
(687) DESCRIBE `cruiselines` 0.0030210018157959
(688) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.00054788589477539
(689) DESCRIBE `orchid_image` 0.0022449493408203
(690) DESCRIBE `cruiselines` 0.0028340816497803
(691) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.00046896934509277
(692) DESCRIBE `cruisetypes` 0.001823902130127
(693) DESCRIBE `destinations` 0.0030791759490967
(694) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '8')) ORDER BY FIND_IN_SET(id, '43,8') 0.00022196769714355
(695) DESCRIBE `cruiselines` 0.0030999183654785
(696) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.0005650520324707
(697) DESCRIBE `ships` 0.0040090084075928
(698) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 780))) 0.0010879039764404
(699) DESCRIBE `cruiselines` 0.0030901432037354
(700) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.00055718421936035
(701) DESCRIBE `ships` 0.003950834274292
(702) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 780))) 0.00062894821166992
(703) DESCRIBE `ports` 0.0020570755004883
(704) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00046205520629883