or, enquire about your chosen options

  1. Catch Up on Cruising: Latest News in bite size!
  2. REVIEW: P & O Australia’s Pacific Aria
  3. Catch Up on Cruising: Latest News in bite size!
  4. Asian Adventures with Zuleika from the Cruise Factor Team
  5. A short cruise is a good cruise!!

Sign up to our newsletter and become the first to know about our latest deals and promotions

 
 

Please note, while cruise details and inclusions are accurate at time of loading they are subject to change due to changes in cruise line practices and policies. Please check details and inclusions at time of booking.

Database Profiling Report

Total queries executed: 584

Total elapsed time: 0.61010980606079

# Query Time
(1) connect 0.0011188983917236
(2) DESCRIBE `cruises` 0.0025808811187744
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (66772, 74667, 66749, 68831, 52324, 68678, 74713, 74697, 74668, 45863)) ORDER BY FIND_IN_SET(id, '66772,74667,66749,68831,52324,68678,74713,74697,74668,45863') 0.0014350414276123
(4) DESCRIBE `cruises` 0.0026540756225586
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66772') 0.00041007995605469
(6) DESCRIBE `ships` 0.0021572113037109
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1526))) 0.00049090385437012
(8) DESCRIBE `ships` 0.0022580623626709
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1526') 0.00033307075500488
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025200843811035
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00022983551025391
(12) DESCRIBE `itineraries` 0.0010519027709961
(13) DESCRIBE `ports` 0.0011579990386963
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.0003359317779541
(15) DESCRIBE `ports` 0.0011811256408691
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00027680397033691
(17) DESCRIBE `ports` 0.00095891952514648
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00026106834411621
(19) DESCRIBE `sailingdates` 0.00096797943115234
(20) DESCRIBE `ports` 0.0014147758483887
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00034189224243164
(22) DESCRIBE `ports` 0.0010690689086914
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00026488304138184
(24) DESCRIBE `ports` 0.0012118816375732
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.0002739429473877
(26) DESCRIBE `ports` 0.00097489356994629
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00028181076049805
(28) DESCRIBE `ports` 0.0009770393371582
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00025486946105957
(30) DESCRIBE `ports` 0.00095510482788086
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00023794174194336
(32) DESCRIBE `ports` 0.00095701217651367
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00027084350585938
(34) DESCRIBE `ports` 0.00095415115356445
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00023603439331055
(36) DESCRIBE `ports` 0.00095105171203613
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00026202201843262
(38) DESCRIBE `ports` 0.0010099411010742
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00023221969604492
(40) DESCRIBE `ports` 0.00095200538635254
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00026392936706543
(42) DESCRIBE `ports` 0.0010750293731689
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00023293495178223
(44) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66772') AND (sailingdate >= '2019-01-01') 0.011101961135864
(45) DESCRIBE `avid_specials` 0.0011470317840576
(46) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66772 and class = 'Cruise') OR (item_id = 1526 AND class = 'Ship') OR (item_id = 212 AND class = 'CruiseLine') OR (item_id = 39 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.0010859966278076
(47) DESCRIBE `cruiselines` 0.0012550354003906
(48) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00031709671020508
(49) DESCRIBE `orchid_image` 0.0010600090026855
(50) DESCRIBE `cruiselines` 0.0014989376068115
(51) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00029301643371582
(52) DESCRIBE `cruises` 0.0016758441925049
(53) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74667') 0.00026202201843262
(54) DESCRIBE `ships` 0.0015449523925781
(55) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1526))) 0.00039505958557129
(56) DESCRIBE `ships` 0.0018579959869385
(57) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1526') 0.00028896331787109
(58) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00023508071899414
(59) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017690658569336
(60) DESCRIBE `itineraries` 0.00088596343994141
(61) DESCRIBE `ports` 0.00083804130554199
(62) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00023102760314941
(63) DESCRIBE `ports` 0.0008080005645752
(64) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00020098686218262
(65) DESCRIBE `ports` 0.00071001052856445
(66) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00019502639770508
(67) DESCRIBE `sailingdates` 0.00066709518432617
(68) DESCRIBE `ports` 0.0047218799591064
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00039482116699219
(70) DESCRIBE `ports` 0.0011210441589355
(71) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.0002591609954834
(72) DESCRIBE `ports` 0.0010440349578857
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00030803680419922
(74) DESCRIBE `ports` 0.0010972023010254
(75) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00025320053100586
(76) DESCRIBE `ports` 0.00099802017211914
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00027203559875488
(78) DESCRIBE `ports` 0.0010008811950684
(79) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00024199485778809
(80) DESCRIBE `ports` 0.0010349750518799
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00029397010803223
(82) DESCRIBE `ports` 0.0013320446014404
(83) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00028514862060547
(84) DESCRIBE `ports` 0.00090408325195312
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00028300285339355
(86) DESCRIBE `ports` 0.00093293190002441
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00028014183044434
(88) DESCRIBE `ports` 0.00092101097106934
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00021100044250488
(90) DESCRIBE `ports` 0.0006718635559082
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00019097328186035
(92) DESCRIBE `ports` 0.00081610679626465
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.0002138614654541
(94) DESCRIBE `ports` 0.00071406364440918
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00018191337585449
(96) DESCRIBE `ports` 0.00066781044006348
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4161))) 0.00019598007202148
(98) DESCRIBE `ports` 0.00068521499633789
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4161') 0.00017786026000977
(100) DESCRIBE `ports` 0.00073504447937012
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00020194053649902
(102) DESCRIBE `ports` 0.00076603889465332
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00018596649169922
(104) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '74667') AND (sailingdate >= '2019-01-01') 0.0070219039916992
(105) DESCRIBE `avid_specials` 0.0010459423065186
(106) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74667 and class = 'Cruise') OR (item_id = 1526 AND class = 'Ship') OR (item_id = 212 AND class = 'CruiseLine') OR (item_id = 39 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.0011000633239746
(107) DESCRIBE `cruiselines` 0.0010480880737305
(108) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00024509429931641
(109) DESCRIBE `orchid_image` 0.00079798698425293
(110) DESCRIBE `cruiselines` 0.00095200538635254
(111) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00035691261291504
(112) DESCRIBE `cruises` 0.0023691654205322
(113) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66749') 0.0003669261932373
(114) DESCRIBE `ships` 0.0020220279693604
(115) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1526))) 0.0003969669342041
(116) DESCRIBE `ships` 0.0020110607147217
(117) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1526') 0.00036311149597168
(118) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0002288818359375
(119) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0023319721221924
(120) DESCRIBE `itineraries` 0.0012428760528564
(121) DESCRIBE `ports` 0.0013258457183838
(122) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00034213066101074
(123) DESCRIBE `ports` 0.00078392028808594
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00020098686218262
(125) DESCRIBE `ports` 0.00068807601928711
(126) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00019097328186035
(127) DESCRIBE `sailingdates` 0.00060296058654785
(128) DESCRIBE `ports` 0.00082182884216309
(129) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00025105476379395
(130) DESCRIBE `ports` 0.00076580047607422
(131) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00024604797363281
(132) DESCRIBE `ports` 0.00070619583129883
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00020289421081543
(134) DESCRIBE `ports` 0.0006859302520752
(135) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.0002288818359375
(136) DESCRIBE `ports` 0.00072288513183594
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2910))) 0.00019598007202148
(138) DESCRIBE `ports` 0.00070810317993164
(139) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2910') 0.00018191337585449
(140) DESCRIBE `ports` 0.00072693824768066
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.0001990795135498
(142) DESCRIBE `ports` 0.00093412399291992
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00023698806762695
(144) DESCRIBE `ports` 0.00072002410888672
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00026798248291016
(146) DESCRIBE `ports` 0.0015799999237061
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00029993057250977
(148) DESCRIBE `ports` 0.0011560916900635
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 156))) 0.00029802322387695
(150) DESCRIBE `ports` 0.0010621547698975
(151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '156') 0.00026106834411621
(152) DESCRIBE `ports` 0.00087404251098633
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00020384788513184
(154) DESCRIBE `ports` 0.00072312355041504
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00019001960754395
(156) DESCRIBE `ports` 0.0006709098815918
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00020599365234375
(158) DESCRIBE `ports` 0.00078797340393066
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00018787384033203
(160) DESCRIBE `ports` 0.00073409080505371
(161) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00020408630371094
(162) DESCRIBE `ports` 0.00089812278747559
(163) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00023198127746582
(164) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66749') AND (sailingdate >= '2019-01-01') 0.0059578418731689
(165) DESCRIBE `avid_specials` 0.00091409683227539
(166) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66749 and class = 'Cruise') OR (item_id = 1526 AND class = 'Ship') OR (item_id = 212 AND class = 'CruiseLine') OR (item_id = 39 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.0011980533599854
(167) DESCRIBE `cruiselines` 0.0013980865478516
(168) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00032997131347656
(169) DESCRIBE `orchid_image` 0.0012080669403076
(170) DESCRIBE `cruiselines` 0.0014431476593018
(171) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.0003199577331543
(172) DESCRIBE `cruises` 0.0022628307342529
(173) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68831') 0.00041389465332031
(174) DESCRIBE `ships` 0.0025110244750977
(175) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1013))) 0.00042414665222168
(176) DESCRIBE `ships` 0.0023090839385986
(177) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1013') 0.0003049373626709
(178) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018501281738281
(179) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018787384033203
(180) DESCRIBE `itineraries` 0.00093698501586914
(181) DESCRIBE `ports` 0.00072503089904785
(182) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00024104118347168
(183) DESCRIBE `ports` 0.00072193145751953
(184) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00023102760314941
(185) DESCRIBE `ports` 0.00071597099304199
(186) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00022196769714355
(187) DESCRIBE `sailingdates` 0.00070691108703613
(188) DESCRIBE `ports` 0.0010228157043457
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00025415420532227
(190) DESCRIBE `ports` 0.00072813034057617
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00020289421081543
(192) DESCRIBE `ports` 0.001539945602417
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.0002739429473877
(194) DESCRIBE `ports` 0.00073099136352539
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00019001960754395
(196) DESCRIBE `ports` 0.00074100494384766
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00025582313537598
(198) DESCRIBE `ports` 0.00083804130554199
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00021505355834961
(200) DESCRIBE `ports` 0.00079989433288574
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00020098686218262
(202) DESCRIBE `ports` 0.00069093704223633
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00018095970153809
(204) DESCRIBE `ports` 0.00077390670776367
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00024509429931641
(206) DESCRIBE `ports` 0.00074911117553711
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00023698806762695
(208) DESCRIBE `ports` 0.00069808959960938
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00020813941955566
(210) DESCRIBE `ports` 0.00068092346191406
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00019192695617676
(212) DESCRIBE `ports` 0.00078105926513672
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4585))) 0.00020217895507812
(214) DESCRIBE `ports` 0.00066399574279785
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4585') 0.00018095970153809
(216) DESCRIBE `ports` 0.00072216987609863
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00020599365234375
(218) DESCRIBE `ports` 0.00068998336791992
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00017714500427246
(220) DESCRIBE `ports` 0.00073385238647461
(221) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00025415420532227
(222) DESCRIBE `ports` 0.00096797943115234
(223) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.0066800117492676
(224) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '68831') AND (sailingdate >= '2019-01-01') 0.0091280937194824
(225) DESCRIBE `avid_specials` 0.0011129379272461
(226) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68831 and class = 'Cruise') OR (item_id = 1013 AND class = 'Ship') OR (item_id = 212 AND class = 'CruiseLine') OR (item_id = 39 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.0065569877624512
(227) DESCRIBE `cruiselines` 0.0057780742645264
(228) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.001101016998291
(229) DESCRIBE `orchid_image` 0.00089406967163086
(230) DESCRIBE `cruiselines` 0.0039310455322266
(231) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.0012049674987793
(232) DESCRIBE `cruises` 0.0014128684997559
(233) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '52324') 0.0036609172821045
(234) DESCRIBE `ships` 0.0016500949859619
(235) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1013))) 0.0033400058746338
(236) DESCRIBE `ships` 0.0014619827270508
(237) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1013') 0.0041539669036865
(238) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018501281738281
(239) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016999244689941
(240) DESCRIBE `itineraries` 0.00068402290344238
(241) DESCRIBE `ports` 0.00075507164001465
(242) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.0016188621520996
(243) DESCRIBE `ports` 0.0012340545654297
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.004749059677124
(245) DESCRIBE `ports` 0.0011749267578125
(246) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.0044338703155518
(247) DESCRIBE `sailingdates` 0.00093913078308105
(248) DESCRIBE `ports` 0.0081489086151123
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00073719024658203
(250) DESCRIBE `ports` 0.0038280487060547
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.0003359317779541
(252) DESCRIBE `ports` 0.0025379657745361
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00028610229492188
(254) DESCRIBE `ports` 0.0027949810028076
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.0031459331512451
(256) DESCRIBE `ports` 0.0010139942169189
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4585))) 0.0015151500701904
(258) DESCRIBE `ports` 0.0010309219360352
(259) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4585') 0.0044901371002197
(260) DESCRIBE `ports` 0.0012581348419189
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00034117698669434
(262) DESCRIBE `ports` 0.0050570964813232
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.0026078224182129
(264) DESCRIBE `ports` 0.0012810230255127
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00033903121948242
(266) DESCRIBE `ports` 0.0035769939422607
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.0020968914031982
(268) DESCRIBE `ports` 0.0011138916015625
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 156))) 0.0027689933776855
(270) DESCRIBE `ports` 0.00097894668579102
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '156') 0.0016469955444336
(272) DESCRIBE `ports` 0.0010359287261963
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.0020298957824707
(274) DESCRIBE `ports` 0.0039000511169434
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00030684471130371
(276) DESCRIBE `ports` 0.00098490715026855
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.0014469623565674
(278) DESCRIBE `ports` 0.0036349296569824
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.0022737979888916
(280) DESCRIBE `ports` 0.0011589527130127
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.0043699741363525
(282) DESCRIBE `ports` 0.0011122226715088
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.0023128986358643
(284) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '52324') AND (sailingdate >= '2019-01-01') 0.011753082275391
(285) DESCRIBE `avid_specials` 0.00092506408691406
(286) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 52324 and class = 'Cruise') OR (item_id = 1013 AND class = 'Ship') OR (item_id = 212 AND class = 'CruiseLine') OR (item_id = 39 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.0043509006500244
(287) DESCRIBE `cruiselines` 0.003593921661377
(288) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.0023210048675537
(289) DESCRIBE `orchid_image` 0.0010077953338623
(290) DESCRIBE `cruiselines` 0.0035300254821777
(291) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.0016238689422607
(292) DESCRIBE `cruises` 0.0016021728515625
(293) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68678') 0.0055840015411377
(294) DESCRIBE `ships` 0.0022261142730713
(295) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1163))) 0.00043106079101562
(296) DESCRIBE `ships` 0.0022048950195312
(297) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1163') 0.00029301643371582
(298) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00023484230041504
(299) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00022292137145996
(300) DESCRIBE `itineraries` 0.0012221336364746
(301) DESCRIBE `ports` 0.0011889934539795
(302) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.00028109550476074
(303) DESCRIBE `ports` 0.00098609924316406
(304) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.00026297569274902
(305) DESCRIBE `ports` 0.0012891292572021
(306) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4804') 0.00024700164794922
(307) DESCRIBE `sailingdates` 0.00085997581481934
(308) DESCRIBE `ports` 0.0010418891906738
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.00030398368835449
(310) DESCRIBE `ports` 0.0011970996856689
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4804') 0.00025200843811035
(312) DESCRIBE `ports` 0.0012209415435791
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1229))) 0.00026798248291016
(314) DESCRIBE `ports` 0.0010747909545898
(315) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1229') 0.0002288818359375
(316) DESCRIBE `ports` 0.0012719631195068
(317) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3829))) 0.00025796890258789
(318) DESCRIBE `ports` 0.0010960102081299
(319) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3829') 0.00023198127746582
(320) DESCRIBE `ports` 0.0010349750518799
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3828))) 0.00028800964355469
(322) DESCRIBE `ports` 0.0010170936584473
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3828') 0.00031709671020508
(324) DESCRIBE `ports` 0.0010640621185303
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.00029587745666504
(326) DESCRIBE `ports` 0.001068115234375
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4804') 0.00026321411132812
(328) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '68678') AND (sailingdate >= '2019-01-01') 0.008246898651123
(329) DESCRIBE `avid_specials` 0.00070881843566895
(330) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68678 and class = 'Cruise') OR (item_id = 1163 AND class = 'Ship') OR (item_id = 212 AND class = 'CruiseLine') OR (item_id = 39 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.0010578632354736
(331) DESCRIBE `cruiselines` 0.0011858940124512
(332) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00026822090148926
(333) DESCRIBE `orchid_image` 0.00080108642578125
(334) DESCRIBE `cruiselines` 0.00099396705627441
(335) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00020194053649902
(336) DESCRIBE `cruises` 0.0013589859008789
(337) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74713') 0.00020408630371094
(338) DESCRIBE `ships` 0.0013928413391113
(339) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1013))) 0.00023889541625977
(340) DESCRIBE `ships` 0.0016529560089111
(341) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1013') 0.00017690658569336
(342) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017809867858887
(343) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016999244689941
(344) DESCRIBE `itineraries` 0.00067687034606934
(345) DESCRIBE `ports` 0.00068902969360352
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00020909309387207
(347) DESCRIBE `ports` 0.00071001052856445
(348) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00021910667419434
(349) DESCRIBE `ports` 0.0006859302520752
(350) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00018191337585449
(351) DESCRIBE `sailingdates` 0.00060296058654785
(352) DESCRIBE `ports` 0.00069594383239746
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00020790100097656
(354) DESCRIBE `ports` 0.00068402290344238
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00018405914306641
(356) DESCRIBE `ports` 0.0006721019744873
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00020098686218262
(358) DESCRIBE `ports` 0.0007331371307373
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00019598007202148
(360) DESCRIBE `ports` 0.00067400932312012
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00020813941955566
(362) DESCRIBE `ports` 0.00072908401489258
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00022101402282715
(364) DESCRIBE `ports` 0.00072002410888672
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00021195411682129
(366) DESCRIBE `ports` 0.00067520141601562
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00018405914306641
(368) DESCRIBE `ports` 0.00067996978759766
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00020098686218262
(370) DESCRIBE `ports` 0.00066494941711426
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00018191337585449
(372) DESCRIBE `ports` 0.00066494941711426
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00019621849060059
(374) DESCRIBE `ports` 0.00069022178649902
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00032210350036621
(376) DESCRIBE `ports` 0.00066494941711426
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4585))) 0.00020790100097656
(378) DESCRIBE `ports` 0.00067782402038574
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4585') 0.0001828670501709
(380) DESCRIBE `ports` 0.00075292587280273
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00019502639770508
(382) DESCRIBE `ports` 0.00066900253295898
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00017786026000977
(384) DESCRIBE `ports` 0.00066709518432617
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.0001981258392334
(386) DESCRIBE `ports` 0.00066804885864258
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00022411346435547
(388) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '74713') AND (sailingdate >= '2019-01-01') 0.0096700191497803
(389) DESCRIBE `avid_specials` 0.0011501312255859
(390) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74713 and class = 'Cruise') OR (item_id = 1013 AND class = 'Ship') OR (item_id = 212 AND class = 'CruiseLine') OR (item_id = 39 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.0015950202941895
(391) DESCRIBE `cruiselines` 0.0013949871063232
(392) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00032186508178711
(393) DESCRIBE `orchid_image` 0.0010499954223633
(394) DESCRIBE `cruiselines` 0.0012829303741455
(395) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.0002751350402832
(396) DESCRIBE `cruises` 0.0020849704742432
(397) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74697') 0.00031805038452148
(398) DESCRIBE `ships` 0.0017681121826172
(399) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1163))) 0.00033807754516602
(400) DESCRIBE `ships` 0.0020420551300049
(401) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1163') 0.00030398368835449
(402) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.000244140625
(403) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00023412704467773
(404) DESCRIBE `itineraries` 0.0010769367218018
(405) DESCRIBE `ports` 0.0010910034179688
(406) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.0002448558807373
(407) DESCRIBE `ports` 0.00076508522033691
(408) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.00021600723266602
(409) DESCRIBE `ports` 0.00070500373840332
(410) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4804') 0.00024604797363281
(411) DESCRIBE `sailingdates` 0.00088787078857422
(412) DESCRIBE `ports` 0.0075368881225586
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.00032711029052734
(414) DESCRIBE `ports` 0.00074505805969238
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4804') 0.0010671615600586
(416) DESCRIBE `ports` 0.00071310997009277
(417) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.003115177154541
(418) DESCRIBE `ports` 0.0010640621185303
(419) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4804') 0.0002291202545166
(420) DESCRIBE `ports` 0.00087404251098633
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1229))) 0.0026988983154297
(422) DESCRIBE `ports` 0.0010027885437012
(423) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1229') 0.00024914741516113
(424) DESCRIBE `ports` 0.00094103813171387
(425) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00027298927307129
(426) DESCRIBE `ports` 0.00073695182800293
(427) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00019693374633789
(428) DESCRIBE `ports` 0.00069499015808105
(429) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3828))) 0.00020098686218262
(430) DESCRIBE `ports` 0.00067400932312012
(431) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3828') 0.00026392936706543
(432) DESCRIBE `ports` 0.00068902969360352
(433) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3828))) 0.0002591609954834
(434) DESCRIBE `ports` 0.0018360614776611
(435) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3828') 0.00019001960754395
(436) DESCRIBE `ports` 0.00086784362792969
(437) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3829))) 0.00019979476928711
(438) DESCRIBE `ports` 0.00072097778320312
(439) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3829') 0.00017619132995605
(440) DESCRIBE `ports` 0.00071191787719727
(441) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 279))) 0.00020599365234375
(442) DESCRIBE `ports` 0.00083518028259277
(443) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '279') 0.00018787384033203
(444) DESCRIBE `ports` 0.00069189071655273
(445) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.00026893615722656
(446) DESCRIBE `ports` 0.0007331371307373
(447) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4804') 0.00018596649169922
(448) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '74697') AND (sailingdate >= '2019-01-01') 0.0054738521575928
(449) DESCRIBE `avid_specials` 0.00085020065307617
(450) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74697 and class = 'Cruise') OR (item_id = 1163 AND class = 'Ship') OR (item_id = 212 AND class = 'CruiseLine') OR (item_id = 39 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.0016171932220459
(451) DESCRIBE `cruiselines` 0.001558780670166
(452) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00032496452331543
(453) DESCRIBE `orchid_image` 0.0010190010070801
(454) DESCRIBE `cruiselines` 0.0012130737304688
(455) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00026607513427734
(456) DESCRIBE `cruises` 0.0015039443969727
(457) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74668') 0.00030112266540527
(458) DESCRIBE `ships` 0.0016629695892334
(459) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1526))) 0.00033783912658691
(460) DESCRIBE `ships` 0.0015919208526611
(461) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1526') 0.00026106834411621
(462) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00036311149597168
(463) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00055599212646484
(464) DESCRIBE `itineraries` 0.0009758472442627
(465) DESCRIBE `ports` 0.00086283683776855
(466) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00027108192443848
(467) DESCRIBE `ports` 0.00084495544433594
(468) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00022292137145996
(469) DESCRIBE `ports` 0.00070595741271973
(470) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00024700164794922
(471) DESCRIBE `sailingdates` 0.00064492225646973
(472) DESCRIBE `ports` 0.00084900856018066
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00026512145996094
(474) DESCRIBE `ports` 0.00071883201599121
(475) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00024509429931641
(476) DESCRIBE `ports` 0.00091195106506348
(477) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00026416778564453
(478) DESCRIBE `ports` 0.00084114074707031
(479) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00022101402282715
(480) DESCRIBE `ports` 0.00076603889465332
(481) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1350))) 0.00024890899658203
(482) DESCRIBE `ports` 0.00098896026611328
(483) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1350') 0.00022697448730469
(484) DESCRIBE `ports` 0.00086593627929688
(485) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.0002439022064209
(486) DESCRIBE `ports` 0.00088191032409668
(487) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00022602081298828
(488) DESCRIBE `ports` 0.00087285041809082
(489) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00025796890258789
(490) DESCRIBE `ports` 0.00092315673828125
(491) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00023317337036133
(492) DESCRIBE `ports` 0.00086593627929688
(493) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00035309791564941
(494) DESCRIBE `ports` 0.0012738704681396
(495) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.0003201961517334
(496) DESCRIBE `ports` 0.00084805488586426
(497) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00023293495178223
(498) DESCRIBE `ports` 0.0007469654083252
(499) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00028300285339355
(500) DESCRIBE `ports` 0.00076699256896973
(501) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00022697448730469
(502) DESCRIBE `ports` 0.0012781620025635
(503) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00052189826965332
(504) DESCRIBE `ports` 0.0011570453643799
(505) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00033998489379883
(506) DESCRIBE `ports` 0.0011200904846191
(507) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00028800964355469
(508) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '74668') AND (sailingdate >= '2019-01-01') 0.011785984039307
(509) DESCRIBE `avid_specials` 0.0013198852539062
(510) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74668 and class = 'Cruise') OR (item_id = 1526 AND class = 'Ship') OR (item_id = 212 AND class = 'CruiseLine') OR (item_id = 39 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.0019748210906982
(511) DESCRIBE `cruiselines` 0.0017170906066895
(512) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00043487548828125
(513) DESCRIBE `orchid_image` 0.0014779567718506
(514) DESCRIBE `cruiselines` 0.0012991428375244
(515) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00031805038452148
(516) DESCRIBE `cruises` 0.0015089511871338
(517) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '45863') 0.00036787986755371
(518) DESCRIBE `ships` 0.0018110275268555
(519) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1163))) 0.00041794776916504
(520) DESCRIBE `ships` 0.0022099018096924
(521) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1163') 0.00040102005004883
(522) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00024104118347168
(523) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00022602081298828
(524) DESCRIBE `itineraries` 0.0011677742004395
(525) DESCRIBE `ports` 0.0012481212615967
(526) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.00035285949707031
(527) DESCRIBE `ports` 0.0010809898376465
(528) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.00030398368835449
(529) DESCRIBE `ports` 0.0010521411895752
(530) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4804') 0.00028800964355469
(531) DESCRIBE `sailingdates` 0.00072312355041504
(532) DESCRIBE `ports` 0.001079797744751
(533) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.00031089782714844
(534) DESCRIBE `ports` 0.00069785118103027
(535) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4804') 0.00020503997802734
(536) DESCRIBE `ports` 0.0006721019744873
(537) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) 0.0002138614654541
(538) DESCRIBE `ports` 0.0009160041809082
(539) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4804') 0.00026106834411621
(540) DESCRIBE `ports` 0.00099706649780273
(541) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1229))) 0.00035810470581055
(542) DESCRIBE `ports` 0.0011889934539795
(543) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1229') 0.0003209114074707
(544) DESCRIBE `ports` 0.0011050701141357
(545) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3829))) 0.00033783912658691
(546) DESCRIBE `ports` 0.00094699859619141
(547) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3829') 0.00024294853210449
(548) DESCRIBE `ports` 0.00083589553833008
(549) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3828))) 0.00023603439331055
(550) DESCRIBE `ports` 0.00083112716674805
(551) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3828') 0.00021600723266602
(552) DESCRIBE `ports` 0.0007929801940918
(553) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00024509429931641
(554) DESCRIBE `ports` 0.00070285797119141
(555) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00019693374633789
(556) DESCRIBE `ports` 0.00068187713623047
(557) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4821))) 0.00023508071899414
(558) DESCRIBE `ports` 0.00072002410888672
(559) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4821') 0.00020098686218262
(560) DESCRIBE `ports` 0.00079202651977539
(561) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3036))) 0.00028204917907715
(562) DESCRIBE `ports` 0.00072693824768066
(563) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3036') 0.00022602081298828
(564) DESCRIBE `ports` 0.00069499015808105
(565) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3036))) 0.00021982192993164
(566) DESCRIBE `ports` 0.00070905685424805
(567) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3036') 0.00020098686218262
(568) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '45863') AND (sailingdate >= '2019-01-01') 0.0058510303497314
(569) DESCRIBE `avid_specials` 0.00093913078308105
(570) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 45863 and class = 'Cruise') OR (item_id = 1163 AND class = 'Ship') OR (item_id = 212 AND class = 'CruiseLine') OR (item_id = 39 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.0017478466033936
(571) DESCRIBE `cruiselines` 0.0015659332275391
(572) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00040507316589355
(573) DESCRIBE `orchid_image` 0.0011978149414062
(574) DESCRIBE `cruiselines` 0.0015389919281006
(575) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00032186508178711
(576) DESCRIBE `ships` 0.0018060207366943
(577) SELECT `ships`.* FROM `ships` WHERE (id IN ('1013', '1163', '1526')) ORDER BY FIND_IN_SET(id, '1013,1163,1526') 0.00069093704223633
(578) DESCRIBE `cruisetypes` 0.0009911060333252
(579) DESCRIBE `destinations` 0.0013759136199951
(580) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('39', '34')) ORDER BY FIND_IN_SET(id, '39,34') 0.0004878044128418
(581) DESCRIBE `cruiselines` 0.001676082611084
(582) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00030517578125
(583) DESCRIBE `cruiselines` 0.0014951229095459
(584) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00031709671020508