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

Total elapsed time: 0.56297898292542

# Query Time
(1) connect 0.00054812431335449
(2) DESCRIBE `cruises` 0.0018000602722168
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (65271, 67715, 57141, 67818, 55776, 66168, 66489, 66493, 68950, 69997)) ORDER BY FIND_IN_SET(id, '65271,67715,57141,67818,55776,66168,66489,66493,68950,69997') 0.001007080078125
(4) DESCRIBE `cruises` 0.0021471977233887
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65271') 0.0002598762512207
(6) DESCRIBE `ships` 0.0012781620025635
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 204))) 0.00026583671569824
(8) DESCRIBE `ships` 0.001533031463623
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '204') 0.00022006034851074
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020885467529297
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017595291137695
(12) DESCRIBE `itineraries` 0.00080299377441406
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '65271') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0028350353240967
(14) DESCRIBE `ports` 0.0012140274047852
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00031900405883789
(16) DESCRIBE `ports` 0.00082302093505859
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00027203559875488
(18) DESCRIBE `ports` 0.00073885917663574
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00019598007202148
(20) DESCRIBE `sailingdates` 0.0006568431854248
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '65271') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0010840892791748
(22) DESCRIBE `ports` 0.0010302066802979
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00023102760314941
(24) DESCRIBE `ports` 0.00093889236450195
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00019407272338867
(26) DESCRIBE `ports` 0.00067400932312012
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 703))) 0.00026893615722656
(28) DESCRIBE `ports` 0.00089621543884277
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '703') 0.00022292137145996
(30) DESCRIBE `ports` 0.00095605850219727
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1191))) 0.00021505355834961
(32) DESCRIBE `ports` 0.00073790550231934
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1191') 0.00022792816162109
(34) DESCRIBE `ports` 0.00095009803771973
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00026512145996094
(36) DESCRIBE `ports` 0.0010149478912354
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0002439022064209
(38) DESCRIBE `ports` 0.00098896026611328
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00028705596923828
(40) DESCRIBE `ports` 0.00095582008361816
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00025200843811035
(42) DESCRIBE `ports` 0.00098800659179688
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00023698806762695
(44) DESCRIBE `ports` 0.00080180168151855
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00024890899658203
(46) DESCRIBE `ports` 0.00089383125305176
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 587))) 0.00027894973754883
(48) DESCRIBE `ports` 0.0009758472442627
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '587') 0.00021195411682129
(50) DESCRIBE `ports` 0.0010230541229248
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 246))) 0.00022196769714355
(52) DESCRIBE `ports` 0.00098681449890137
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '246') 0.00020694732666016
(54) DESCRIBE `ports` 0.00086402893066406
(55) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00027704238891602
(56) DESCRIBE `ports` 0.00089120864868164
(57) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00021195411682129
(58) DESCRIBE `avid_specials` 0.0007932186126709
(59) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65271 and class = 'Cruise') OR (item_id = 204 AND class = 'Ship') OR (item_id = 50 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011999607086182
(60) DESCRIBE `cruiselines` 0.0010290145874023
(61) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 50))) 0.00023794174194336
(62) DESCRIBE `orchid_image` 0.00080108642578125
(63) DESCRIBE `cruiselines` 0.00098180770874023
(64) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '50') 0.00025200843811035
(65) DESCRIBE `cruises` 0.0021309852600098
(66) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67715') 0.00030803680419922
(67) DESCRIBE `ships` 0.0022141933441162
(68) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 973))) 0.00034594535827637
(69) DESCRIBE `ships` 0.0018038749694824
(70) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '973') 0.00024199485778809
(71) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00023889541625977
(72) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00023412704467773
(73) DESCRIBE `itineraries` 0.0010480880737305
(74) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '67715') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0012238025665283
(75) DESCRIBE `ports` 0.00089097023010254
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00025391578674316
(77) DESCRIBE `ports` 0.00071287155151367
(78) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00020503997802734
(79) DESCRIBE `ports` 0.00074315071105957
(80) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00019598007202148
(81) DESCRIBE `sailingdates` 0.00061202049255371
(82) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '67715') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00057601928710938
(83) DESCRIBE `ports` 0.00071096420288086
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00021505355834961
(85) DESCRIBE `ports` 0.00067591667175293
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00026607513427734
(87) DESCRIBE `ports` 0.00081491470336914
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00020813941955566
(89) DESCRIBE `ports` 0.00071597099304199
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00030899047851562
(91) DESCRIBE `ports` 0.001147985458374
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00031685829162598
(93) DESCRIBE `ports` 0.001121997833252
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00026512145996094
(95) DESCRIBE `ports` 0.0010251998901367
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00029897689819336
(97) DESCRIBE `ports` 0.0010559558868408
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00025701522827148
(99) DESCRIBE `ports` 0.0010249614715576
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00037407875061035
(101) DESCRIBE `ports` 0.0010230541229248
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00025486946105957
(103) DESCRIBE `ports` 0.0010240077972412
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1601))) 0.00028681755065918
(105) DESCRIBE `ports` 0.0010349750518799
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1601') 0.00025796890258789
(107) DESCRIBE `ports` 0.001086950302124
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1576))) 0.0002901554107666
(109) DESCRIBE `ports` 0.001046895980835
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1576') 0.00026798248291016
(111) DESCRIBE `ports` 0.0010678768157959
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00028705596923828
(113) DESCRIBE `ports` 0.0010561943054199
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00025177001953125
(115) DESCRIBE `ports` 0.0010290145874023
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1574))) 0.00028896331787109
(117) DESCRIBE `ports` 0.0010700225830078
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1574') 0.00025796890258789
(119) DESCRIBE `ports` 0.0010421276092529
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00029397010803223
(121) DESCRIBE `ports` 0.0010490417480469
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.00026106834411621
(123) DESCRIBE `ports` 0.0010299682617188
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00028300285339355
(125) DESCRIBE `ports` 0.0010581016540527
(126) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.00025796890258789
(127) DESCRIBE `ports` 0.0010631084442139
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1570))) 0.00028896331787109
(129) DESCRIBE `ports` 0.0010490417480469
(130) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1570') 0.00026321411132812
(131) DESCRIBE `ports` 0.0010659694671631
(132) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1600))) 0.00029778480529785
(133) DESCRIBE `ports` 0.0010559558868408
(134) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1600') 0.00026297569274902
(135) DESCRIBE `ports` 0.0010428428649902
(136) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00028491020202637
(137) DESCRIBE `ports` 0.0010759830474854
(138) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00025796890258789
(139) DESCRIBE `ports` 0.001021146774292
(140) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1564))) 0.0002901554107666
(141) DESCRIBE `ports` 0.0010659694671631
(142) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1564') 0.00026798248291016
(143) DESCRIBE `ports` 0.001032829284668
(144) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1596))) 0.0002899169921875
(145) DESCRIBE `ports` 0.0010340213775635
(146) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1596') 0.00025606155395508
(147) DESCRIBE `ports` 0.0010299682617188
(148) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1595))) 0.00029802322387695
(149) DESCRIBE `ports` 0.0010528564453125
(150) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1595') 0.00027012825012207
(151) DESCRIBE `ports` 0.0011239051818848
(152) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2964))) 0.00030112266540527
(153) DESCRIBE `ports` 0.0010271072387695
(154) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2964') 0.00029087066650391
(155) DESCRIBE `ports` 0.0010089874267578
(156) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00028109550476074
(157) DESCRIBE `ports` 0.00099611282348633
(158) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00025701522827148
(159) DESCRIBE `ports` 0.0010769367218018
(160) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00029087066650391
(161) DESCRIBE `ports` 0.0010459423065186
(162) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00026392936706543
(163) DESCRIBE `ports` 0.0010039806365967
(164) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00023007392883301
(165) DESCRIBE `ports` 0.00072908401489258
(166) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00019502639770508
(167) DESCRIBE `avid_specials` 0.00080299377441406
(168) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67715 and class = 'Cruise') OR (item_id = 973 AND class = 'Ship') OR (item_id = 101 AND class = 'CruiseLine') OR (item_id = 50 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0018749237060547
(169) DESCRIBE `cruiselines` 0.0015249252319336
(170) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 101))) 0.00033998489379883
(171) DESCRIBE `orchid_image` 0.0011401176452637
(172) DESCRIBE `cruiselines` 0.0018630027770996
(173) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '101') 0.00034308433532715
(174) DESCRIBE `cruises` 0.0022552013397217
(175) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '57141') 0.00038719177246094
(176) DESCRIBE `ships` 0.0021889209747314
(177) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1044))) 0.00039100646972656
(178) DESCRIBE `ships` 0.0018792152404785
(179) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1044') 0.00025105476379395
(180) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00024890899658203
(181) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00023317337036133
(182) DESCRIBE `itineraries` 0.0010981559753418
(183) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '57141') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0014572143554688
(184) DESCRIBE `ports` 0.0011091232299805
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00031590461730957
(186) DESCRIBE `ports` 0.00084805488586426
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00022792816162109
(188) DESCRIBE `ports` 0.00075507164001465
(189) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.0002288818359375
(190) DESCRIBE `sailingdates` 0.00076198577880859
(191) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '57141') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0012469291687012
(192) DESCRIBE `ports` 0.0012421607971191
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00039410591125488
(194) DESCRIBE `ports` 0.0011160373687744
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00021100044250488
(196) DESCRIBE `ports` 0.00069093704223633
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00022292137145996
(198) DESCRIBE `ports` 0.00074386596679688
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00018811225891113
(200) DESCRIBE `ports` 0.0006859302520752
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00021481513977051
(202) DESCRIBE `ports` 0.00075817108154297
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00020718574523926
(204) DESCRIBE `ports` 0.00069117546081543
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00020599365234375
(206) DESCRIBE `ports` 0.00069808959960938
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.0002131462097168
(208) DESCRIBE `ports` 0.00070595741271973
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1576))) 0.00020313262939453
(210) DESCRIBE `ports` 0.00071501731872559
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1576') 0.00022602081298828
(212) DESCRIBE `ports` 0.00078010559082031
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00025606155395508
(214) DESCRIBE `ports` 0.00078511238098145
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00018501281738281
(216) DESCRIBE `ports` 0.00074005126953125
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00020098686218262
(218) DESCRIBE `ports` 0.00071310997009277
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00018310546875
(220) DESCRIBE `ports` 0.00067996978759766
(221) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1574))) 0.00020480155944824
(222) DESCRIBE `ports` 0.00082993507385254
(223) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1574') 0.00024700164794922
(224) DESCRIBE `ports` 0.00095891952514648
(225) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00027799606323242
(226) DESCRIBE `ports` 0.0010120868682861
(227) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.00026106834411621
(228) DESCRIBE `ports` 0.00093221664428711
(229) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1570))) 0.0002741813659668
(230) DESCRIBE `ports` 0.00098681449890137
(231) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1570') 0.00024890899658203
(232) DESCRIBE `ports` 0.00095701217651367
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1569))) 0.00023508071899414
(234) DESCRIBE `ports` 0.0010108947753906
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1569') 0.00023412704467773
(236) DESCRIBE `ports` 0.00075507164001465
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1600))) 0.00022602081298828
(238) DESCRIBE `ports` 0.00105881690979
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1600') 0.00026583671569824
(240) DESCRIBE `ports` 0.00076198577880859
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1567))) 0.00022101402282715
(242) DESCRIBE `ports` 0.00071907043457031
(243) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1567') 0.00022292137145996
(244) DESCRIBE `ports` 0.0007472038269043
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1566))) 0.00021100044250488
(246) DESCRIBE `ports` 0.001011848449707
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1566') 0.00028586387634277
(248) DESCRIBE `ports` 0.0010471343994141
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2378))) 0.00028896331787109
(250) DESCRIBE `ports` 0.0011370182037354
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2378') 0.00025105476379395
(252) DESCRIBE `ports` 0.0010099411010742
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1565))) 0.00021886825561523
(254) DESCRIBE `ports` 0.00074911117553711
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1565') 0.00019097328186035
(256) DESCRIBE `ports` 0.0006859302520752
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1599))) 0.00020599365234375
(258) DESCRIBE `ports` 0.00072002410888672
(259) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1599') 0.00022196769714355
(260) DESCRIBE `ports` 0.00077104568481445
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1590))) 0.00021600723266602
(262) DESCRIBE `ports` 0.00085306167602539
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1590') 0.00020194053649902
(264) DESCRIBE `ports` 0.00088191032409668
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1564))) 0.00021696090698242
(266) DESCRIBE `ports` 0.00068306922912598
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1564') 0.00018501281738281
(268) DESCRIBE `ports` 0.00069499015808105
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1592))) 0.00023102760314941
(270) DESCRIBE `ports` 0.00069785118103027
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1592') 0.00018215179443359
(272) DESCRIBE `ports` 0.0006721019744873
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1593))) 0.00020408630371094
(274) DESCRIBE `ports` 0.00071096420288086
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1593') 0.00023698806762695
(276) DESCRIBE `ports` 0.00077199935913086
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00020599365234375
(278) DESCRIBE `ports` 0.0006868839263916
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.0001828670501709
(280) DESCRIBE `ports` 0.00069808959960938
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00020098686218262
(282) DESCRIBE `ports` 0.00067281723022461
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.0001828670501709
(284) DESCRIBE `ports` 0.00068998336791992
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00020194053649902
(286) DESCRIBE `ports` 0.00070309638977051
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00018501281738281
(288) DESCRIBE `avid_specials` 0.00080490112304688
(289) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 57141 and class = 'Cruise') OR (item_id = 1044 AND class = 'Ship') OR (item_id = 144 AND class = 'CruiseLine') OR (item_id = 50 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010321140289307
(290) DESCRIBE `cruiselines` 0.0010678768157959
(291) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00027298927307129
(292) DESCRIBE `orchid_image` 0.00095391273498535
(293) DESCRIBE `cruiselines` 0.0011839866638184
(294) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00023484230041504
(295) DESCRIBE `cruises` 0.0014948844909668
(296) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67818') 0.00024700164794922
(297) DESCRIBE `ships` 0.001352071762085
(298) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 349))) 0.00024700164794922
(299) DESCRIBE `ships` 0.0012500286102295
(300) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '349') 0.00018095970153809
(301) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018405914306641
(302) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016403198242188
(303) DESCRIBE `itineraries` 0.00065302848815918
(304) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '67818') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00053620338439941
(305) DESCRIBE `ports` 0.00071287155151367
(306) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00022387504577637
(307) DESCRIBE `ports` 0.00067400932312012
(308) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.0001988410949707
(309) DESCRIBE `ports` 0.00068116188049316
(310) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00018405914306641
(311) DESCRIBE `sailingdates` 0.00060486793518066
(312) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '67818') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00038790702819824
(313) DESCRIBE `ports` 0.00069308280944824
(314) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.0002129077911377
(315) DESCRIBE `ports` 0.00070095062255859
(316) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00018191337585449
(317) DESCRIBE `ports` 0.00066709518432617
(318) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4475))) 0.00019502639770508
(319) DESCRIBE `ports` 0.00066709518432617
(320) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4475') 0.00017809867858887
(321) DESCRIBE `ports` 0.00071096420288086
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3698))) 0.00020909309387207
(323) DESCRIBE `ports` 0.00068402290344238
(324) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3698') 0.00018119812011719
(325) DESCRIBE `ports` 0.00076007843017578
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1432))) 0.00024795532226562
(327) DESCRIBE `ports` 0.00066900253295898
(328) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1432') 0.00023102760314941
(329) DESCRIBE `ports` 0.00071096420288086
(330) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1433))) 0.00020098686218262
(331) DESCRIBE `ports` 0.00081419944763184
(332) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1433') 0.00023698806762695
(333) DESCRIBE `ports` 0.00071191787719727
(334) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5353))) 0.00022697448730469
(335) DESCRIBE `ports` 0.00096392631530762
(336) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5353') 0.00023293495178223
(337) DESCRIBE `ports` 0.00090503692626953
(338) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00026416778564453
(339) DESCRIBE `ports` 0.00096011161804199
(340) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00024795532226562
(341) DESCRIBE `ports` 0.00069904327392578
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1273))) 0.00022506713867188
(343) DESCRIBE `ports` 0.00067615509033203
(344) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1273') 0.00020289421081543
(345) DESCRIBE `ports` 0.00070500373840332
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2509))) 0.00019598007202148
(347) DESCRIBE `ports` 0.00096487998962402
(348) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2509') 0.00025796890258789
(349) DESCRIBE `ports` 0.00094103813171387
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1307))) 0.0002739429473877
(351) DESCRIBE `ports` 0.00098514556884766
(352) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1307') 0.00018405914306641
(353) DESCRIBE `ports` 0.00067806243896484
(354) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1308))) 0.00020503997802734
(355) DESCRIBE `ports` 0.00067305564880371
(356) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1308') 0.00018596649169922
(357) DESCRIBE `ports` 0.00065302848815918
(358) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00021600723266602
(359) DESCRIBE `ports` 0.00065112113952637
(360) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00018310546875
(361) DESCRIBE `avid_specials` 0.00065207481384277
(362) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67818 and class = 'Cruise') OR (item_id = 349 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 35 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.0010879039764404
(363) DESCRIBE `cruiselines` 0.00099802017211914
(364) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00021195411682129
(365) DESCRIBE `orchid_image` 0.000762939453125
(366) DESCRIBE `cruiselines` 0.00089097023010254
(367) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00017881393432617
(368) DESCRIBE `cruises` 0.001255989074707
(369) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '55776') 0.00023698806762695
(370) DESCRIBE `ships` 0.0014748573303223
(371) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1316))) 0.00031495094299316
(372) DESCRIBE `ships` 0.0016510486602783
(373) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1316') 0.00024890899658203
(374) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0002129077911377
(375) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0001828670501709
(376) DESCRIBE `itineraries` 0.00069499015808105
(377) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '55776') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0012590885162354
(378) DESCRIBE `ports` 0.0008690357208252
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00025701522827148
(380) DESCRIBE `ports` 0.00070595741271973
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00020909309387207
(382) DESCRIBE `ports` 0.00070309638977051
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00020289421081543
(384) DESCRIBE `sailingdates` 0.00063610076904297
(385) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '55776') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0012121200561523
(386) DESCRIBE `ports` 0.001101016998291
(387) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00031781196594238
(388) DESCRIBE `ports` 0.00070405006408691
(389) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00019097328186035
(390) DESCRIBE `ports` 0.00071191787719727
(391) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00022315979003906
(392) DESCRIBE `ports` 0.00069308280944824
(393) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00018310546875
(394) DESCRIBE `ports` 0.00066709518432617
(395) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00023818016052246
(396) DESCRIBE `ports` 0.00072193145751953
(397) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00018811225891113
(398) DESCRIBE `ports` 0.00070905685424805
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00020194053649902
(400) DESCRIBE `ports` 0.00066518783569336
(401) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00018191337585449
(402) DESCRIBE `ports` 0.00070095062255859
(403) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1576))) 0.0001988410949707
(404) DESCRIBE `ports` 0.00066304206848145
(405) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1576') 0.00018095970153809
(406) DESCRIBE `ports` 0.00066113471984863
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00022006034851074
(408) DESCRIBE `ports` 0.00066304206848145
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00018095970153809
(410) DESCRIBE `ports` 0.00066280364990234
(411) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1574))) 0.0001978874206543
(412) DESCRIBE `ports` 0.0007779598236084
(413) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1574') 0.00019192695617676
(414) DESCRIBE `ports` 0.00067305564880371
(415) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00020194053649902
(416) DESCRIBE `ports` 0.00067591667175293
(417) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.00019001960754395
(418) DESCRIBE `ports` 0.00083708763122559
(419) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1570))) 0.00020384788513184
(420) DESCRIBE `ports` 0.00087690353393555
(421) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1570') 0.00018620491027832
(422) DESCRIBE `ports` 0.00067591667175293
(423) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1600))) 0.00020909309387207
(424) DESCRIBE `ports` 0.00066709518432617
(425) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1600') 0.00018191337585449
(426) DESCRIBE `ports` 0.0007169246673584
(427) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1567))) 0.00027990341186523
(428) DESCRIBE `ports` 0.00072383880615234
(429) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1567') 0.00021004676818848
(430) DESCRIBE `ports` 0.00068187713623047
(431) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1563))) 0.00020813941955566
(432) DESCRIBE `ports` 0.0006709098815918
(433) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1563') 0.00025105476379395
(434) DESCRIBE `ports` 0.00094699859619141
(435) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1592))) 0.00027608871459961
(436) DESCRIBE `ports` 0.0009150505065918
(437) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1592') 0.00023102760314941
(438) DESCRIBE `ports` 0.00092196464538574
(439) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3685))) 0.00022387504577637
(440) DESCRIBE `ports` 0.00075197219848633
(441) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3685') 0.00018906593322754
(442) DESCRIBE `ports` 0.00072097778320312
(443) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00021100044250488
(444) DESCRIBE `ports` 0.00066804885864258
(445) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00018620491027832
(446) DESCRIBE `avid_specials` 0.00061607360839844
(447) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 55776 and class = 'Cruise') OR (item_id = 1316 AND class = 'Ship') OR (item_id = 77 AND class = 'CruiseLine') OR (item_id = 50 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010120868682861
(448) DESCRIBE `cruiselines` 0.0013689994812012
(449) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.00060009956359863
(450) DESCRIBE `orchid_image` 0.0013701915740967
(451) DESCRIBE `cruiselines` 0.0015099048614502
(452) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.0002748966217041
(453) DESCRIBE `cruises` 0.001755952835083
(454) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66168') 0.00024318695068359
(455) DESCRIBE `ships` 0.0013129711151123
(456) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 766))) 0.00027012825012207
(457) DESCRIBE `ships` 0.0012631416320801
(458) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '766') 0.00018715858459473
(459) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017714500427246
(460) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016403198242188
(461) DESCRIBE `itineraries` 0.00067305564880371
(462) DESCRIBE `ports` 0.00081586837768555
(463) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00022602081298828
(464) DESCRIBE `ports` 0.00081110000610352
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00019598007202148
(466) DESCRIBE `ports` 0.00066304206848145
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00018501281738281
(468) DESCRIBE `sailingdates` 0.00067687034606934
(469) DESCRIBE `ports` 0.00069093704223633
(470) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00037002563476562
(471) DESCRIBE `ports` 0.0010640621185303
(472) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00026917457580566
(473) DESCRIBE `ports` 0.0007929801940918
(474) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 248))) 0.00022697448730469
(475) DESCRIBE `ports` 0.00074005126953125
(476) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '248') 0.00019598007202148
(477) DESCRIBE `ports` 0.00070595741271973
(478) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1842))) 0.00020503997802734
(479) DESCRIBE `ports` 0.00066494941711426
(480) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1842') 0.00020003318786621
(481) DESCRIBE `ports` 0.00065994262695312
(482) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00021100044250488
(483) DESCRIBE `ports` 0.0007021427154541
(484) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00017595291137695
(485) DESCRIBE `ports` 0.00066494941711426
(486) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.0001990795135498
(487) DESCRIBE `ports` 0.00065898895263672
(488) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00017809867858887
(489) DESCRIBE `ports` 0.00070095062255859
(490) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.00020885467529297
(491) DESCRIBE `ports` 0.00070786476135254
(492) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.00017595291137695
(493) DESCRIBE `ports` 0.00074887275695801
(494) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 529))) 0.00019097328186035
(495) DESCRIBE `ports` 0.00067305564880371
(496) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '529') 0.00017499923706055
(497) DESCRIBE `ports` 0.00070691108703613
(498) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.0001988410949707
(499) DESCRIBE `ports` 0.00069499015808105
(500) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.00017595291137695
(501) DESCRIBE `ports` 0.00065994262695312
(502) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.00023198127746582
(503) DESCRIBE `ports` 0.00066494941711426
(504) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.00020813941955566
(505) DESCRIBE `ports` 0.00068306922912598
(506) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2403))) 0.00019407272338867
(507) DESCRIBE `ports` 0.00066304206848145
(508) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2403') 0.00017499923706055
(509) DESCRIBE `ports` 0.00065803527832031
(510) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00022387504577637
(511) DESCRIBE `ports` 0.00067281723022461
(512) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00020813941955566
(513) DESCRIBE `avid_specials` 0.000701904296875
(514) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66168 and class = 'Cruise') OR (item_id = 766 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 28 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.0010740756988525
(515) DESCRIBE `cruiselines` 0.0010008811950684
(516) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00023794174194336
(517) DESCRIBE `orchid_image` 0.00078010559082031
(518) DESCRIBE `cruiselines` 0.00095891952514648
(519) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00024700164794922
(520) DESCRIBE `cruises` 0.0013039112091064
(521) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66489') 0.00024700164794922
(522) DESCRIBE `ships` 0.0014050006866455
(523) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1311))) 0.00028491020202637
(524) DESCRIBE `ships` 0.0012810230255127
(525) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1311') 0.00021696090698242
(526) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017404556274414
(527) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016307830810547
(528) DESCRIBE `itineraries` 0.00065898895263672
(529) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66489') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0011138916015625
(530) DESCRIBE `ports` 0.0009911060333252
(531) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.0002589225769043
(532) DESCRIBE `ports` 0.00068402290344238
(533) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00019383430480957
(534) DESCRIBE `ports` 0.0006721019744873
(535) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00020098686218262
(536) DESCRIBE `sailingdates` 0.00059914588928223
(537) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66489') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00066709518432617
(538) DESCRIBE `ports` 0.00072002410888672
(539) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00027203559875488
(540) DESCRIBE `ports` 0.00099492073059082
(541) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00024509429931641
(542) DESCRIBE `ports` 0.00099897384643555
(543) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00030088424682617
(544) DESCRIBE `ports` 0.00099301338195801
(545) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00024509429931641
(546) DESCRIBE `ports` 0.0009770393371582
(547) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00020599365234375
(548) DESCRIBE `ports` 0.00066995620727539
(549) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.0001828670501709
(550) DESCRIBE `ports` 0.00066685676574707
(551) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.0001978874206543
(552) DESCRIBE `ports` 0.00064897537231445
(553) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00018501281738281
(554) DESCRIBE `ports` 0.00065398216247559
(555) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1601))) 0.00020098686218262
(556) DESCRIBE `ports` 0.00064802169799805
(557) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1601') 0.0001828670501709
(558) DESCRIBE `ports` 0.00066208839416504
(559) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1576))) 0.00020098686218262
(560) DESCRIBE `ports` 0.00065112113952637
(561) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1576') 0.00017189979553223
(562) DESCRIBE `ports` 0.00070786476135254
(563) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1581))) 0.0001990795135498
(564) DESCRIBE `ports` 0.00068306922912598
(565) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1581') 0.00017499923706055
(566) DESCRIBE `ports` 0.0006868839263916
(567) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00019311904907227
(568) DESCRIBE `ports` 0.00065207481384277
(569) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00017595291137695
(570) DESCRIBE `ports` 0.0006718635559082
(571) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1574))) 0.00020194053649902
(572) DESCRIBE `ports` 0.00065302848815918
(573) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1574') 0.00017499923706055
(574) DESCRIBE `ports` 0.00065207481384277
(575) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00019717216491699
(576) DESCRIBE `ports` 0.00067591667175293
(577) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.00019001960754395
(578) DESCRIBE `ports` 0.00064897537231445
(579) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1570))) 0.00018978118896484
(580) DESCRIBE `ports` 0.0006561279296875
(581) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1570') 0.00017213821411133
(582) DESCRIBE `ports` 0.0006709098815918
(583) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1600))) 0.00019502639770508
(584) DESCRIBE `ports` 0.00065302848815918
(585) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1600') 0.00017309188842773
(586) DESCRIBE `ports` 0.00093388557434082
(587) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1566))) 0.00020217895507812
(588) DESCRIBE `ports` 0.00066709518432617
(589) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1566') 0.00017499923706055
(590) DESCRIBE `ports` 0.00065302848815918
(591) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1564))) 0.00019192695617676
(592) DESCRIBE `ports` 0.00066494941711426
(593) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1564') 0.00017213821411133
(594) DESCRIBE `ports` 0.00064921379089355
(595) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1592))) 0.00019407272338867
(596) DESCRIBE `ports` 0.00065183639526367
(597) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1592') 0.00017404556274414
(598) DESCRIBE `ports` 0.00067901611328125
(599) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00019598007202148
(600) DESCRIBE `ports` 0.00064897537231445
(601) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00017189979553223
(602) DESCRIBE `ports` 0.00064587593078613
(603) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00019001960754395
(604) DESCRIBE `ports` 0.0007321834564209
(605) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00017499923706055
(606) DESCRIBE `avid_specials` 0.00062799453735352
(607) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66489 and class = 'Cruise') OR (item_id = 1311 AND class = 'Ship') OR (item_id = 249 AND class = 'CruiseLine') OR (item_id = 50 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010218620300293
(608) DESCRIBE `cruiselines` 0.0011241436004639
(609) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 249))) 0.00026583671569824
(610) DESCRIBE `orchid_image` 0.0010712146759033
(611) DESCRIBE `cruiselines` 0.0013389587402344
(612) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '249') 0.00018692016601562
(613) DESCRIBE `cruises` 0.0015499591827393
(614) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66493') 0.00026202201843262
(615) DESCRIBE `ships` 0.0014529228210449
(616) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1310))) 0.00027203559875488
(617) DESCRIBE `ships` 0.0014150142669678
(618) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1310') 0.00019717216491699
(619) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00020003318786621
(620) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017786026000977
(621) DESCRIBE `itineraries` 0.00076794624328613
(622) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66493') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00041317939758301
(623) DESCRIBE `ports` 0.00073003768920898
(624) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00025200843811035
(625) DESCRIBE `ports` 0.0009610652923584
(626) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00019621849060059
(627) DESCRIBE `ports` 0.00070309638977051
(628) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00018000602722168
(629) DESCRIBE `sailingdates` 0.00060009956359863
(630) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66493') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00037908554077148
(631) DESCRIBE `ports` 0.00074601173400879
(632) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00022077560424805
(633) DESCRIBE `ports` 0.00074481964111328
(634) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.0002288818359375
(635) DESCRIBE `ports` 0.00090599060058594
(636) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2634))) 0.00025796890258789
(637) DESCRIBE `ports` 0.00089406967163086
(638) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2634') 0.00018215179443359
(639) DESCRIBE `ports` 0.00068497657775879
(640) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1592))) 0.0001990795135498
(641) DESCRIBE `ports` 0.00066018104553223
(642) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1592') 0.00017595291137695
(643) DESCRIBE `ports` 0.00065803527832031
(644) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1564))) 0.00019311904907227
(645) DESCRIBE `ports` 0.0006568431854248
(646) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1564') 0.00017595291137695
(647) DESCRIBE `ports` 0.0006558895111084
(648) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1566))) 0.00020313262939453
(649) DESCRIBE `ports` 0.00067782402038574
(650) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1566') 0.00017404556274414
(651) DESCRIBE `ports` 0.00065779685974121
(652) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1600))) 0.0002131462097168
(653) DESCRIBE `ports` 0.00066113471984863
(654) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1600') 0.00018692016601562
(655) DESCRIBE `ports` 0.0006861686706543
(656) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1570))) 0.00019407272338867
(657) DESCRIBE `ports` 0.00066399574279785
(658) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1570') 0.00023102760314941
(659) DESCRIBE `ports` 0.00067496299743652
(660) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00021696090698242
(661) DESCRIBE `ports` 0.00066113471984863
(662) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.00017786026000977
(663) DESCRIBE `ports` 0.00068783760070801
(664) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1574))) 0.00020694732666016
(665) DESCRIBE `ports` 0.00076007843017578
(666) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1574') 0.00017809867858887
(667) DESCRIBE `ports` 0.00088286399841309
(668) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00025320053100586
(669) DESCRIBE `ports` 0.00096821784973145
(670) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00023698806762695
(671) DESCRIBE `ports` 0.00095295906066895
(672) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1576))) 0.00025200843811035
(673) DESCRIBE `ports` 0.00095105171203613
(674) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1576') 0.0002288818359375
(675) DESCRIBE `ports` 0.0009758472442627
(676) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1601))) 0.00022506713867188
(677) DESCRIBE `ports` 0.0008540153503418
(678) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1601') 0.00018000602722168
(679) DESCRIBE `ports` 0.00066304206848145
(680) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00019717216491699
(681) DESCRIBE `ports` 0.00067996978759766
(682) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00017881393432617
(683) DESCRIBE `ports` 0.00067710876464844
(684) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00019311904907227
(685) DESCRIBE `ports` 0.00086402893066406
(686) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.0002129077911377
(687) DESCRIBE `ports` 0.00067996978759766
(688) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00021815299987793
(689) DESCRIBE `ports` 0.00070786476135254
(690) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00017786026000977
(691) DESCRIBE `ports` 0.00067305564880371
(692) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00020599365234375
(693) DESCRIBE `ports` 0.00073480606079102
(694) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00017595291137695
(695) DESCRIBE `avid_specials` 0.00060796737670898
(696) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66493 and class = 'Cruise') OR (item_id = 1310 AND class = 'Ship') OR (item_id = 249 AND class = 'CruiseLine') OR (item_id = 50 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0016710758209229
(697) DESCRIBE `cruiselines` 0.0015919208526611
(698) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 249))) 0.00027585029602051
(699) DESCRIBE `orchid_image` 0.00086402893066406
(700) DESCRIBE `cruiselines` 0.0010378360748291
(701) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '249') 0.00022602081298828
(702) DESCRIBE `cruises` 0.0013599395751953
(703) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68950') 0.0002739429473877
(704) DESCRIBE `ships` 0.0013279914855957
(705) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1342))) 0.00028395652770996
(706) DESCRIBE `ships` 0.0019040107727051
(707) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1342') 0.0003669261932373
(708) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00022482872009277
(709) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00021219253540039
(710) DESCRIBE `itineraries` 0.0010659694671631
(711) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68950') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0014638900756836
(712) DESCRIBE `ports` 0.0012650489807129
(713) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00036191940307617
(714) DESCRIBE `ports` 0.00095105171203613
(715) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00026106834411621
(716) DESCRIBE `ports` 0.00096607208251953
(717) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00024294853210449
(718) DESCRIBE `sailingdates` 0.00083398818969727
(719) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '68950') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0011351108551025
(720) DESCRIBE `ports` 0.0010550022125244
(721) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00030398368835449
(722) DESCRIBE `ports` 0.00095200538635254
(723) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00023484230041504
(724) DESCRIBE `ports` 0.00093197822570801
(725) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3685))) 0.00026702880859375
(726) DESCRIBE `ports` 0.00095295906066895
(727) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3685') 0.00024509429931641
(728) DESCRIBE `ports` 0.00093388557434082
(729) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1592))) 0.0002739429473877
(730) DESCRIBE `ports` 0.00095486640930176
(731) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1592') 0.00024199485778809
(732) DESCRIBE `ports` 0.00099992752075195
(733) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1563))) 0.00026488304138184
(734) DESCRIBE `ports` 0.00094294548034668
(735) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1563') 0.00023913383483887
(736) DESCRIBE `ports` 0.00095200538635254
(737) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1566))) 0.00028181076049805
(738) DESCRIBE `ports` 0.0009620189666748
(739) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1566') 0.00024509429931641
(740) DESCRIBE `ports` 0.00098013877868652
(741) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1600))) 0.00027298927307129
(742) DESCRIBE `ports` 0.00094819068908691
(743) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1600') 0.00023412704467773
(744) DESCRIBE `ports` 0.00095009803771973
(745) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1570))) 0.00026512145996094
(746) DESCRIBE `ports` 0.00093197822570801
(747) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1570') 0.00023198127746582
(748) DESCRIBE `ports` 0.00095295906066895
(749) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00027012825012207
(750) DESCRIBE `ports` 0.00095891952514648
(751) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.0002601146697998
(752) DESCRIBE `ports` 0.00096011161804199
(753) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1574))) 0.00028395652770996
(754) DESCRIBE `ports` 0.00095891952514648
(755) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1574') 0.00024604797363281
(756) DESCRIBE `ports` 0.00093913078308105
(757) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00026321411132812
(758) DESCRIBE `ports` 0.00093603134155273
(759) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00023889541625977
(760) DESCRIBE `ports` 0.00094985961914062
(761) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1576))) 0.00026202201843262
(762) DESCRIBE `ports` 0.00095891952514648
(763) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1576') 0.00024008750915527
(764) DESCRIBE `ports` 0.0009300708770752
(765) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2914))) 0.00026297569274902
(766) DESCRIBE `ports` 0.00096297264099121
(767) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2914') 0.00023603439331055
(768) DESCRIBE `ports` 0.00092792510986328
(769) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00026488304138184
(770) DESCRIBE `ports` 0.0010020732879639
(771) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00023508071899414
(772) DESCRIBE `ports` 0.000946044921875
(773) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00026988983154297
(774) DESCRIBE `ports` 0.00096607208251953
(775) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00023007392883301
(776) DESCRIBE `ports` 0.00094389915466309
(777) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00026798248291016
(778) DESCRIBE `ports` 0.0010240077972412
(779) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.0002601146697998
(780) DESCRIBE `ports` 0.00093603134155273
(781) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00026416778564453
(782) DESCRIBE `ports` 0.00094914436340332
(783) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00023007392883301
(784) DESCRIBE `avid_specials` 0.00084400177001953
(785) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68950 and class = 'Cruise') OR (item_id = 1342 AND class = 'Ship') OR (item_id = 77 AND class = 'CruiseLine') OR (item_id = 50 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0016839504241943
(786) DESCRIBE `cruiselines` 0.0013630390167236
(787) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.00028610229492188
(788) DESCRIBE `orchid_image` 0.0010662078857422
(789) DESCRIBE `cruiselines` 0.001366138458252
(790) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.00023603439331055
(791) DESCRIBE `cruises` 0.0018720626831055
(792) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69997') 0.00028896331787109
(793) DESCRIBE `ships` 0.0018959045410156
(794) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1295))) 0.0003960132598877
(795) DESCRIBE `ships` 0.0019290447235107
(796) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1295') 0.00029993057250977
(797) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00022792816162109
(798) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00021791458129883
(799) DESCRIBE `itineraries` 0.00096297264099121
(800) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69997') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0013201236724854
(801) DESCRIBE `ports` 0.0012290477752686
(802) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00031614303588867
(803) DESCRIBE `ports` 0.00094413757324219
(804) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.0002751350402832
(805) DESCRIBE `ports` 0.00094795227050781
(806) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00024294853210449
(807) DESCRIBE `sailingdates` 0.00083017349243164
(808) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69997') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00073695182800293
(809) DESCRIBE `ports` 0.0010621547698975
(810) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00029182434082031
(811) DESCRIBE `ports` 0.00094389915466309
(812) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00023794174194336
(813) DESCRIBE `ports` 0.00096893310546875
(814) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00026583671569824
(815) DESCRIBE `ports` 0.00094509124755859
(816) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00023198127746582
(817) DESCRIBE `ports` 0.00096893310546875
(818) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00026893615722656
(819) DESCRIBE `ports` 0.00095891952514648
(820) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00023484230041504
(821) DESCRIBE `ports` 0.00094008445739746
(822) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.0002751350402832
(823) DESCRIBE `ports` 0.00093507766723633
(824) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00023698806762695
(825) DESCRIBE `ports` 0.00096821784973145
(826) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1601))) 0.00026512145996094
(827) DESCRIBE `ports` 0.00095415115356445
(828) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1601') 0.00023913383483887
(829) DESCRIBE `ports` 0.00098800659179688
(830) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1576))) 0.00021696090698242
(831) DESCRIBE `ports` 0.0007779598236084
(832) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1576') 0.00018620491027832
(833) DESCRIBE `ports` 0.00074100494384766
(834) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00021004676818848
(835) DESCRIBE `ports` 0.00067496299743652
(836) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00018310546875
(837) DESCRIBE `ports` 0.0006721019744873
(838) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2094))) 0.00021719932556152
(839) DESCRIBE `ports` 0.00068807601928711
(840) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2094') 0.00019001960754395
(841) DESCRIBE `ports` 0.00067496299743652
(842) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1574))) 0.00020599365234375
(843) DESCRIBE `ports` 0.0006718635559082
(844) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1574') 0.0001828670501709
(845) DESCRIBE `ports` 0.00073504447937012
(846) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00037407875061035
(847) DESCRIBE `ports` 0.00086402893066406
(848) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.00019502639770508
(849) DESCRIBE `ports` 0.00067901611328125
(850) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1570))) 0.00023412704467773
(851) DESCRIBE `ports` 0.0010321140289307
(852) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1570') 0.00025200843811035
(853) DESCRIBE `ports` 0.00095701217651367
(854) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1600))) 0.00023889541625977
(855) DESCRIBE `ports` 0.00071907043457031
(856) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1600') 0.00019311904907227
(857) DESCRIBE `ports` 0.0006861686706543
(858) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1600))) 0.00023508071899414
(859) DESCRIBE `ports` 0.0007781982421875
(860) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1600') 0.00019598007202148
(861) DESCRIBE `ports` 0.00083208084106445
(862) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1564))) 0.00022697448730469
(863) DESCRIBE `ports` 0.00070714950561523
(864) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1564') 0.00022602081298828
(865) DESCRIBE `ports` 0.00079011917114258
(866) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1592))) 0.00024199485778809
(867) DESCRIBE `ports` 0.00069689750671387
(868) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1592') 0.00018596649169922
(869) DESCRIBE `ports` 0.00070810317993164
(870) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00022602081298828
(871) DESCRIBE `ports` 0.00071811676025391
(872) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00019001960754395
(873) DESCRIBE `ports` 0.00067496299743652
(874) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00020909309387207
(875) DESCRIBE `ports` 0.00073409080505371
(876) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00018906593322754
(877) DESCRIBE `avid_specials` 0.00064301490783691
(878) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69997 and class = 'Cruise') OR (item_id = 1295 AND class = 'Ship') OR (item_id = 156 AND class = 'CruiseLine') OR (item_id = 50 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011579990386963
(879) DESCRIBE `cruiselines` 0.0010859966278076
(880) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 156))) 0.00024580955505371
(881) DESCRIBE `orchid_image` 0.00081300735473633
(882) DESCRIBE `cruiselines` 0.00095081329345703
(883) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '156') 0.00021195411682129
(884) DESCRIBE `cruiselines` 0.0012979507446289
(885) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '19', '26', '23', '171', '144', '31', '18', '101', '20', '183', '8', '7', '96', '120', '12', '221', '103', '50', '29', '15', '268', '37', '91', '110', '33', '208', '232', '114', '28', '131', '49', '118', '206', '24', '156', '181', '262', '187', '258', '151', '36', '153', '220', '204', '256', '212', '30', '47', '249', '16', '14', '191', '238', '174', '141', '195', '239', '211', '4', '35', '216', '113', '213', '146', '182', '90', '159', '188', '168', '196', '136', '237', '209', '115', '180', '73', '95', '170', '219', '108', '225', '229', '57', '59', '231', '184', '248', '140', '52', '269', '132', '276', '88', '261', '275', '264', '244', '82', '230', '105', '38', '116', '266', '48', '119', '64', '240', '39', '245', '210', '134', '224')) ORDER BY FIND_IN_SET(id, '218,77,19,26,23,171,144,31,18,101,20,183,8,7,96,120,12,221,103,50,29,15,268,37,91,110,33,208,232,114,28,131,49,118,206,24,156,181,262,187,258,151,36,153,220,204,256,212,30,47,249,16,14,191,238,174,141,195,239,211,4,35,216,113,213,146,182,90,159,188,168,196,136,237,209,115,180,73,95,170,219,108,225,229,57,59,231,184,248,140,52,269,132,276,88,261,275,264,244,82,230,105,38,116,266,48,119,64,240,39,245,210,134,224') 0.0029881000518799
(886) DESCRIBE `ships` 0.0019009113311768
(887) SELECT `ships`.* FROM `ships` WHERE (id IN ('1127', '1247', '1554', '1555', '977', '1199', '1291', '1359', '1588', '1067', '1237', '407', '258', '726', '1599', '27', '22', '461', '28', '1594', '21', '393', '1424', '817', '1422', '1135', '1419', '1420', '1423', '1418', '1421', '349', '780', '1415', '452', '113', '462', '517', '766', '404', '265', '24', '11', '439', '1574', '9', '10', '1245', '542', '330', '585', '207', '674', '1141', '1460', '455', '770', '1215', '974', '797', '124', '1272', '792', '739', '5', '553', '1455', '116', '520', '573', '1572', '3', '1607', '25', '78', '1193', '340', '711', '1021', '1068', '160', '14', '434', '1284', '1402', '253', '421', '1095', '1302', '390', '748', '855', '874', '1172', '1586', '43', '580', '871', '285', '559', '765', '791', '1320', '658', '1323', '1139', '1064', '1571', '582', '590', '286', '678', '119', '327', '406', '526', '970', '405', '854', '454', '616', '993', '1348', '1581', '722', '850', '883', '1236', '1678', '823', '1569', '81', '114', '610', '731', '859', '521', '1008', '163', '403', '547', '1027', '1330', '784', '966', '1088', '1325', '1326', '1327', '1454', '30', '31', '36', '84', '348', '378', '652', '732', '34', '35', '37', '82', '333', '338', '657', '1012', '1319', '1575', '38', '39', '325', '351', '1672', '4', '683', '1143', '262', '451', '1108', '1205', '508', '1318', '389', '1151', '1471', '1579', '111', '123', '148', '314', '1367', '1376', '1587', '290', '335', '1157', '1214', '93', '287', '352', '626', '751', '1013', '1075', '483', '1040', '1063', '1233', '1308', '1321', '1398', '1405', '1614', '162', '394', '651', '1137', '1145', '1223', '1344', '1345', '1724', '291', '545', '673', '1144', '1243', '1343', '98', '852', '1043', '1159', '1303', '1604', '45', '441', '768', '1413', '1452', '1453', '152', '401', '716', '968', '1025', '1090', '1136', '1163', '1168', '1283', '1492', '150', '769', '988', '1032', '1149', '1301', '1373', '149', '669', '59', '151', '1226', '1241', '1526', '1552', '1602', '201', '223', '324', '467', '639', '905', '1134', '1150', '1448', '776', '888', '973', '1449', '313', '601', '882', '1029', '1647', '1711', '266', '417', '986', '1152', '1382', '1411', '1417', '1458', '1539', '341', '480', '1026', '1176', '1292', '1351', '74', '108', '996', '1055', '1188', '1231', '1489', '1496', '1717', '503', '837', '885', '954', '1034', '1049', '1366', '1609', '1615', '105', '666', '704', '851', '1047', '1260', '1285', '1362', '1368', '1372', '790', '1230', '1408', '1516', '75', '574', '796', '857', '1154', '1208', '1253', '1470', '1505', '811', '985', '1282', '1518', '205', '208', '493', '1054', '1409', '1632', '147', '332', '494', '618', '701', '836', '1051', '1224', '1384', '1521', '1540', '1682', '422', '643', '738', '884', '1037', '1383', '1407', '1501', '1628', '204', '423', '818', '1073', '1486', '448', '749', '1148', '1517', '1522', '485', '795', '1042', '1262', '1410', '1593', '1627', '781', '938', '994', '1138', '1611', '709', '717', '937', '972', '995', '1266', '1437', '66', '212', '479', '665', '1017', '1229', '1716', '1461', '1481', '1514', '1601', '1612', '1684', '420', '1045', '1175', '1254', '1412', '1619', '1639', '17', '499', '1028', '1259', '1515', '1713', '1715', '375', '453', '1293', '1439', '1673', '1714', '487', '798', '1011', '1053', '1106', '1206', '1240', '1704', '1606', '70', '1360', '1361', '1459', '775', '1035', '1052', '1110', '1232', '419', '715', '808', '958', '1048', '1060', '1189', '1274', '1613', '1192', '1338', '1385', '1708', '69', '1071', '1089', '1256', '1339', '1342', '1474', '1723', '944', '969', '1036', '1158', '1183', '1184', '1347', '1483', '1697', '1729', '225', '886', '1058', '1160', '1298', '1311', '1355', '1543', '1019', '1195', '1310', '1322', '1545', '1679', '62', '288')) ORDER BY FIND_IN_SET(id, '1127,1247,1554,1555,977,1199,1291,1359,1588,1067,1237,407,258,726,1599,27,22,461,28,1594,21,393,1424,817,1422,1135,1419,1420,1423,1418,1421,349,780,1415,452,113,462,517,766,404,265,24,11,439,1574,9,10,1245,542,330,585,207,674,1141,1460,455,770,1215,974,797,124,1272,792,739,5,553,1455,116,520,573,1572,3,1607,25,78,1193,340,711,1021,1068,160,14,434,1284,1402,253,421,1095,1302,390,748,855,874,1172,1586,43,580,871,285,559,765,791,1320,658,1323,1139,1064,1571,582,590,286,678,119,327,406,526,970,405,854,454,616,993,1348,1581,722,850,883,1236,1678,823,1569,81,114,610,731,859,521,1008,163,403,547,1027,1330,784,966,1088,1325,1326,1327,1454,30,31,36,84,348,378,652,732,34,35,37,82,333,338,657,1012,1319,1575,38,39,325,351,1672,4,683,1143,262,451,1108,1205,508,1318,389,1151,1471,1579,111,123,148,314,1367,1376,1587,290,335,1157,1214,93,287,352,626,751,1013,1075,483,1040,1063,1233,1308,1321,1398,1405,1614,162,394,651,1137,1145,1223,1344,1345,1724,291,545,673,1144,1243,1343,98,852,1043,1159,1303,1604,45,441,768,1413,1452,1453,152,401,716,968,1025,1090,1136,1163,1168,1283,1492,150,769,988,1032,1149,1301,1373,149,669,59,151,1226,1241,1526,1552,1602,201,223,324,467,639,905,1134,1150,1448,776,888,973,1449,313,601,882,1029,1647,1711,266,417,986,1152,1382,1411,1417,1458,1539,341,480,1026,1176,1292,1351,74,108,996,1055,1188,1231,1489,1496,1717,503,837,885,954,1034,1049,1366,1609,1615,105,666,704,851,1047,1260,1285,1362,1368,1372,790,1230,1408,1516,75,574,796,857,1154,1208,1253,1470,1505,811,985,1282,1518,205,208,493,1054,1409,1632,147,332,494,618,701,836,1051,1224,1384,1521,1540,1682,422,643,738,884,1037,1383,1407,1501,1628,204,423,818,1073,1486,448,749,1148,1517,1522,485,795,1042,1262,1410,1593,1627,781,938,994,1138,1611,709,717,937,972,995,1266,1437,66,212,479,665,1017,1229,1716,1461,1481,1514,1601,1612,1684,420,1045,1175,1254,1412,1619,1639,17,499,1028,1259,1515,1713,1715,375,453,1293,1439,1673,1714,487,798,1011,1053,1106,1206,1240,1704,1606,70,1360,1361,1459,775,1035,1052,1110,1232,419,715,808,958,1048,1060,1189,1274,1613,1192,1338,1385,1708,69,1071,1089,1256,1339,1342,1474,1723,944,969,1036,1158,1183,1184,1347,1483,1697,1729,225,886,1058,1160,1298,1311,1355,1543,1019,1195,1310,1322,1545,1679,62,288') 0.029985904693604
(888) DESCRIBE `cruisetypes` 0.0010108947753906
(889) DESCRIBE `destinations` 0.0011639595031738
(890) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '22', '54', '35', '37', '2', '9', '25', '43', '8', '39', '53', '28', '26', '11', '55', '38', '40', '21', '7', '48', '49', '44', '30', '29', '56', '45', '10', '34', '52', '46', '32')) ORDER BY FIND_IN_SET(id, '50,12,22,54,35,37,2,9,25,43,8,39,53,28,26,11,55,38,40,21,7,48,49,44,30,29,56,45,10,34,52,46,32') 0.0013740062713623