Sign up to our newsletter and become the first to know about our latest deals and promotions
| Nights | 108 | Ship | Sea Princess |
| Star Rating |  |
Departs | Auckland, New Zealand |
| Sailing |
2021: |
| Ports of Call | Auckland, Bay of Islands, Sydney, Brisbane, Benoa, Singapore, Colombo Sri Lanka, Muscat More Dubai, Aqaba, Suez Canal, Mykonos, Salerno, Rome (Civitavecchia), Portoferraio, Marseilles, Barcelona, Malaga, Tangier, Lisbon, Cobh (Cork), Greenock (Glasgow), Liverpool, Holyhead, Dover, Inverness, Lerwick, Reykjavik, Nanortalik, Qaqortoq, Nuuk, Red Bay, Quebec City, Port Saguenay, Halifax, New York, Grand Turk, Panama Canal, Quito, Callao (Lima) Peru, Pisco, Easter Island (Hanga Roa), Papeete, Bora Bora, Date Line Crossing |
Select a sailing date for approximate pricing.
Prices are per person, twin share. When booking please check current cruise fare and inclusions. Prices are indicative only, subject to currency fluctuations and may change at any time without notice.
 |
Cafe Corniche |
 |
Library |
 |
Movies Under the Stars |
 |
Princess Theatre |
 |
Razzmatazz |
 |
Rigoletto Dining Room |
 |
Youth & Teen Centre |
Copyright © 2010 Cruise Factor Limited
All rights reserved
PO Box 5081,
Mt Maunganui 3150
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.
Total queries executed: 241
Total elapsed time: 1.215359210968
| # | Query | Time |
|---|---|---|
| (1) | connect | 0.00090503692626953 |
| (2) | DESCRIBE `cruises` | 0.0050759315490723 |
| (3) | SELECT `cruises`.* FROM `cruises` WHERE (orchid_slug = 'sea-world-cruise-2021-ex-auckland-return') AND (orchid_available = 1) LIMIT 1 | 0.8165328502655 |
| (4) | DESCRIBE `avid_specials` | 0.0031030178070068 |
| (5) | SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 87151 and class = 'Cruise') OR (item_id = 451 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 40 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.0023951530456543 |
| (6) | SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '87151') | 0.00061297416687012 |
| (7) | DESCRIBE `ships` | 0.0037789344787598 |
| (8) | SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 451))) | 0.00047111511230469 |
| (9) | DESCRIBE `ships` | 0.0035078525543213 |
| (10) | SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '451') | 0.00040006637573242 |
| (11) | SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') | 0.0003819465637207 |
| (12) | SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') | 0.00050616264343262 |
| (13) | DESCRIBE `itineraries` | 0.0023488998413086 |
| (14) | DESCRIBE `ports` | 0.0019948482513428 |
| (15) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) | 0.0004580020904541 |
| (16) | DESCRIBE `ports` | 0.0019638538360596 |
| (17) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) | 0.00039911270141602 |
| (18) | DESCRIBE `ports` | 0.0017671585083008 |
| (19) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') | 0.00038290023803711 |
| (20) | DESCRIBE `sailingdates` | 0.0016288757324219 |
| (21) | DESCRIBE `ports` | 0.0018699169158936 |
| (22) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) | 0.00039911270141602 |
| (23) | DESCRIBE `ports` | 0.0016980171203613 |
| (24) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') | 0.00041103363037109 |
| (25) | DESCRIBE `ports` | 0.00177001953125 |
| (26) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) | 0.00039792060852051 |
| (27) | DESCRIBE `ports` | 0.0019121170043945 |
| (28) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') | 0.00038695335388184 |
| (29) | DESCRIBE `ports` | 0.0017900466918945 |
| (30) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) | 0.00044608116149902 |
| (31) | DESCRIBE `ports` | 0.0018100738525391 |
| (32) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') | 0.00037407875061035 |
| (33) | DESCRIBE `ports` | 0.0020830631256104 |
| (34) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) | 0.00043416023254395 |
| (35) | DESCRIBE `ports` | 0.0018730163574219 |
| (36) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') | 0.00036978721618652 |
| (37) | DESCRIBE `ports` | 0.0018060207366943 |
| (38) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1440))) | 0.00037598609924316 |
| (39) | DESCRIBE `ports` | 0.0017960071563721 |
| (40) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1440') | 0.00035214424133301 |
| (41) | DESCRIBE `ports` | 0.0019440650939941 |
| (42) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) | 0.00039505958557129 |
| (43) | DESCRIBE `ports` | 0.0017881393432617 |
| (44) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') | 0.00040793418884277 |
| (45) | DESCRIBE `ports` | 0.0018510818481445 |
| (46) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 424))) | 0.00039100646972656 |
| (47) | DESCRIBE `ports` | 0.0017938613891602 |
| (48) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '424') | 0.00039005279541016 |
| (49) | DESCRIBE `ports` | 0.0019969940185547 |
| (50) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 427))) | 0.00038886070251465 |
| (51) | DESCRIBE `ports` | 0.0019781589508057 |
| (52) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '427') | 0.00039505958557129 |
| (53) | DESCRIBE `ports` | 0.001964807510376 |
| (54) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) | 0.00042581558227539 |
| (55) | DESCRIBE `ports` | 0.0017638206481934 |
| (56) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') | 0.00038003921508789 |
| (57) | DESCRIBE `ports` | 0.0017461776733398 |
| (58) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) | 0.00055789947509766 |
| (59) | DESCRIBE `ports` | 0.002018928527832 |
| (60) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') | 0.00040197372436523 |
| (61) | DESCRIBE `ports` | 0.0020749568939209 |
| (62) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 428))) | 0.00042295455932617 |
| (63) | DESCRIBE `ports` | 0.002051830291748 |
| (64) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '428') | 0.0003969669342041 |
| (65) | DESCRIBE `ports` | 0.0018901824951172 |
| (66) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 712))) | 0.00046300888061523 |
| (67) | DESCRIBE `ports` | 0.0018229484558105 |
| (68) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '712') | 0.00043678283691406 |
| (69) | DESCRIBE `ports` | 0.0026009082794189 |
| (70) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 712))) | 0.00055193901062012 |
| (71) | DESCRIBE `ports` | 0.0019998550415039 |
| (72) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '712') | 0.00037693977355957 |
| (73) | DESCRIBE `ports` | 0.0017900466918945 |
| (74) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) | 0.00042295455932617 |
| (75) | DESCRIBE `ports` | 0.0018548965454102 |
| (76) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') | 0.0004420280456543 |
| (77) | DESCRIBE `ports` | 0.0018520355224609 |
| (78) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 704))) | 0.00039577484130859 |
| (79) | DESCRIBE `ports` | 0.0019421577453613 |
| (80) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '704') | 0.00046181678771973 |
| (81) | DESCRIBE `ports` | 0.0019412040710449 |
| (82) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) | 0.00042486190795898 |
| (83) | DESCRIBE `ports` | 0.0017759799957275 |
| (84) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') | 0.00046610832214355 |
| (85) | DESCRIBE `ports` | 0.0018508434295654 |
| (86) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1119))) | 0.00041604042053223 |
| (87) | DESCRIBE `ports` | 0.0018520355224609 |
| (88) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1119') | 0.00039196014404297 |
| (89) | DESCRIBE `ports` | 0.0018148422241211 |
| (90) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) | 0.00043511390686035 |
| (91) | DESCRIBE `ports` | 0.0017530918121338 |
| (92) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') | 0.00041413307189941 |
| (93) | DESCRIBE `ports` | 0.0019309520721436 |
| (94) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) | 0.00055098533630371 |
| (95) | DESCRIBE `ports` | 0.0023739337921143 |
| (96) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') | 0.0008389949798584 |
| (97) | DESCRIBE `ports` | 0.0024349689483643 |
| (98) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) | 0.00070500373840332 |
| (99) | DESCRIBE `ports` | 0.0026271343231201 |
| (100) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') | 0.00055289268493652 |
| (101) | DESCRIBE `ports` | 0.0019850730895996 |
| (102) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 391))) | 0.00060510635375977 |
| (103) | DESCRIBE `ports` | 0.0020561218261719 |
| (104) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '391') | 0.00043582916259766 |
| (105) | DESCRIBE `ports` | 0.0020420551300049 |
| (106) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) | 0.00046992301940918 |
| (107) | DESCRIBE `ports` | 0.0020279884338379 |
| (108) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') | 0.00050997734069824 |
| (109) | DESCRIBE `ports` | 0.0021178722381592 |
| (110) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 752))) | 0.00048613548278809 |
| (111) | DESCRIBE `ports` | 0.001964807510376 |
| (112) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '752') | 0.00051689147949219 |
| (113) | DESCRIBE `ports` | 0.0018761157989502 |
| (114) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 747))) | 0.0005040168762207 |
| (115) | DESCRIBE `ports` | 0.0018448829650879 |
| (116) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '747') | 0.00039887428283691 |
| (117) | DESCRIBE `ports` | 0.0020060539245605 |
| (118) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2001))) | 0.00048995018005371 |
| (119) | DESCRIBE `ports` | 0.0020179748535156 |
| (120) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2001') | 0.00039410591125488 |
| (121) | DESCRIBE `ports` | 0.0018930435180664 |
| (122) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 781))) | 0.00045418739318848 |
| (123) | DESCRIBE `ports` | 0.0019500255584717 |
| (124) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '781') | 0.00046181678771973 |
| (125) | DESCRIBE `ports` | 0.0027599334716797 |
| (126) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 218))) | 0.00060486793518066 |
| (127) | DESCRIBE `ports` | 0.0018467903137207 |
| (128) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '218') | 0.00038290023803711 |
| (129) | DESCRIBE `ports` | 0.0018830299377441 |
| (130) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1938))) | 0.00042986869812012 |
| (131) | DESCRIBE `ports` | 0.0018408298492432 |
| (132) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1938') | 0.00040793418884277 |
| (133) | DESCRIBE `ports` | 0.0019559860229492 |
| (134) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 754))) | 0.00045490264892578 |
| (135) | DESCRIBE `ports` | 0.0023770332336426 |
| (136) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '754') | 0.00045394897460938 |
| (137) | DESCRIBE `ports` | 0.0018858909606934 |
| (138) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 229))) | 0.00042104721069336 |
| (139) | DESCRIBE `ports` | 0.0022330284118652 |
| (140) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '229') | 0.00044894218444824 |
| (141) | DESCRIBE `ports` | 0.0018551349639893 |
| (142) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1176))) | 0.00051999092102051 |
| (143) | DESCRIBE `ports` | 0.0018570423126221 |
| (144) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1176') | 0.00040006637573242 |
| (145) | DESCRIBE `ports` | 0.0017790794372559 |
| (146) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2412))) | 0.00048685073852539 |
| (147) | DESCRIBE `ports` | 0.0018401145935059 |
| (148) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2412') | 0.00038599967956543 |
| (149) | DESCRIBE `ports` | 0.0019738674163818 |
| (150) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1706))) | 0.00043988227844238 |
| (151) | DESCRIBE `ports` | 0.0020520687103271 |
| (152) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1706') | 0.00040006637573242 |
| (153) | DESCRIBE `ports` | 0.0018420219421387 |
| (154) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1087))) | 0.00043296813964844 |
| (155) | DESCRIBE `ports` | 0.0027551651000977 |
| (156) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1087') | 0.00049996376037598 |
| (157) | DESCRIBE `ports` | 0.0021560192108154 |
| (158) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) | 0.00056195259094238 |
| (159) | DESCRIBE `ports` | 0.0024309158325195 |
| (160) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') | 0.00048708915710449 |
| (161) | DESCRIBE `ports` | 0.0018930435180664 |
| (162) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3096))) | 0.00046801567077637 |
| (163) | DESCRIBE `ports` | 0.0024490356445312 |
| (164) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3096') | 0.00046992301940918 |
| (165) | DESCRIBE `ports` | 0.0033059120178223 |
| (166) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 117))) | 0.00071406364440918 |
| (167) | DESCRIBE `ports` | 0.0025861263275146 |
| (168) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '117') | 0.00057077407836914 |
| (169) | DESCRIBE `ports` | 0.0020577907562256 |
| (170) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) | 0.00050592422485352 |
| (171) | DESCRIBE `ports` | 0.0028212070465088 |
| (172) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') | 0.00057291984558105 |
| (173) | DESCRIBE `ports` | 0.0022430419921875 |
| (174) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) | 0.00049591064453125 |
| (175) | DESCRIBE `ports` | 0.0018699169158936 |
| (176) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') | 0.00063300132751465 |
| (177) | DESCRIBE `ports` | 0.0026319026947021 |
| (178) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) | 0.00072097778320312 |
| (179) | DESCRIBE `ports` | 0.002997875213623 |
| (180) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') | 0.00061702728271484 |
| (181) | DESCRIBE `ports` | 0.0019328594207764 |
| (182) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1727))) | 0.0019030570983887 |
| (183) | DESCRIBE `ports` | 0.0021078586578369 |
| (184) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1727') | 0.00042295455932617 |
| (185) | DESCRIBE `ports` | 0.0020561218261719 |
| (186) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 165))) | 0.00060915946960449 |
| (187) | DESCRIBE `ports` | 0.0018670558929443 |
| (188) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '165') | 0.00037693977355957 |
| (189) | DESCRIBE `ports` | 0.0019378662109375 |
| (190) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1646))) | 0.00045394897460938 |
| (191) | DESCRIBE `ports` | 0.0019271373748779 |
| (192) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1646') | 0.00045299530029297 |
| (193) | DESCRIBE `ports` | 0.0018680095672607 |
| (194) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 431))) | 0.00046300888061523 |
| (195) | DESCRIBE `ports` | 0.0021820068359375 |
| (196) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '431') | 0.0004570484161377 |
| (197) | DESCRIBE `ports` | 0.0018880367279053 |
| (198) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 431))) | 0.00047683715820312 |
| (199) | DESCRIBE `ports` | 0.0020551681518555 |
| (200) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '431') | 0.00047206878662109 |
| (201) | DESCRIBE `ports` | 0.0024900436401367 |
| (202) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 880))) | 0.00066590309143066 |
| (203) | DESCRIBE `ports` | 0.0018661022186279 |
| (204) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '880') | 0.00038695335388184 |
| (205) | DESCRIBE `ports` | 0.0017890930175781 |
| (206) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 786))) | 0.00042104721069336 |
| (207) | DESCRIBE `ports` | 0.001910924911499 |
| (208) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '786') | 0.0004270076751709 |
| (209) | DESCRIBE `ports` | 0.0020890235900879 |
| (210) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) | 0.00056719779968262 |
| (211) | DESCRIBE `ports` | 0.0021429061889648 |
| (212) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') | 0.00042104721069336 |
| (213) | DESCRIBE `ports` | 0.0021088123321533 |
| (214) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) | 0.00064921379089355 |
| (215) | DESCRIBE `ports` | 0.0020959377288818 |
| (216) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') | 0.00041794776916504 |
| (217) | DESCRIBE `ports` | 0.0018479824066162 |
| (218) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) | 0.00042414665222168 |
| (219) | DESCRIBE `ports` | 0.0018799304962158 |
| (220) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') | 0.00040602684020996 |
| (221) | DESCRIBE `ports` | 0.0021049976348877 |
| (222) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) | 0.00066304206848145 |
| (223) | DESCRIBE `ports` | 0.0028159618377686 |
| (224) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') | 0.00059103965759277 |
| (225) | DESCRIBE `cruiselines` | 0.0030210018157959 |
| (226) | SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) | 0.00072002410888672 |
| (227) | DESCRIBE `orchid_image` | 0.0027399063110352 |
| (228) | DESCRIBE `cruiselines` | 0.0035638809204102 |
| (229) | SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') | 0.00067996978759766 |
| (230) | DESCRIBE `cabins` | 0.0022130012512207 |
| (231) | DESCRIBE `deckplans` | 0.0020570755004883 |
| (232) | DESCRIBE `shipphotos` | 0.0017509460449219 |
| (233) | DESCRIBE `cruises` | 0.0041060447692871 |
| (234) | SELECT `cruises`.* FROM `cruises` WHERE (id IN (29613, 29952, 34157, 38147, 38149, 40591, 40596, 45258, 45258, 45260)) ORDER BY FIND_IN_SET(id, '29613,29952,34157,38147,38149,40591,40596,45258,45258,45260') | 0.0019938945770264 |
| (235) | DESCRIBE `cruiselines` | 0.0030310153961182 |
| (236) | SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '19', '26', '171', '23', '144', '12', '20', '7', '183', '18', '101', '8', '120', '31', '131', '29', '96', '15', '103', '206', '91', '33', '262', '170', '114', '24', '28', '14', '156', '191', '50', '258', '195', '37', '153', '208', '16', '187', '49', '36', '47', '88', '251', '216', '151', '141', '212', '181', '4', '118', '110', '59', '30', '140', '73', '147', '115', '261', '48', '213', '159', '264', '276', '209', '211', '108', '113', '90', '57', '82', '184', '95', '38', '180', '52', '244', '105', '35', '64', '134', '257', '245', '172')) ORDER BY FIND_IN_SET(id, '218,77,19,26,171,23,144,12,20,7,183,18,101,8,120,31,131,29,96,15,103,206,91,33,262,170,114,24,28,14,156,191,50,258,195,37,153,208,16,187,49,36,47,88,251,216,151,141,212,181,4,118,110,59,30,140,73,147,115,261,48,213,159,264,276,209,211,108,113,90,57,82,184,95,38,180,52,244,105,35,64,134,257,245,172') | 0.0055289268493652 |
| (237) | DESCRIBE `ships` | 0.0050117969512939 |
| (238) | SELECT `ships`.* FROM `ships` WHERE (id IN ('1761', '732', '1744', '517', '726', '258', '737', '780', '1417', '1324', '855', '1588', '1717', '207', '1794', '1291', '871', '874', '977', '1594', '454', '1199', '1572', '1766', '404', '1359', '1272', '770', '22', '330', '461', '1032', '21', '393', '974', '66', '716', '1237', '28', '1292', '797', '1424', '434', '738', '1134', '1682', '553', '332', '521', '265', '1348', '333', '766', '1768', '349', '711', '1415', '1260', '1419', '1423', '585', '1422', '1418', '1420', '1421', '9', '715', '11', '792', '857', '858', '1501', '10', '1677', '163', '407', '439', '455', '739', '25', '1132', '1678', '34', '31', '36', '378', '674', '3', '24', '39', '657', '542', '1460', '520', '1008', '1721', '1205', '1141', '1607', '837', '1569', '385', '1067', '1742', '1302', '1852', '386', '966', '1402', '1773', '882', '1168', '1233', '1372', '113', '160', '1822', '35', '850', '1012', '1505', '1811', '338', '626', '768', '1454', '1455', '1574', '1676', '98', '1135', '1319', '1602', '573', '37', '1373', '63', '285', '451', '610', '1021', '30', '352', '986', '817', '1284', '1413', '1733', '547', '1259', '1282', '1398', '1411', '38', '1410', '1782', '111', '148', '314', '1193', '108', '375', '1088', '1722', '43', '286', '406', '503', '1437', '508', '627', '748', '1108', '198', '340', '526', '1063', '1308', '1320', '1323', '1579', '1711', '1808', '970', '1145', '883', '1325', '116', '124', '327', '485', '854', '1586', '348', '390', '582', '1149', '1738', '394', '590', '1571', '1028', '1208', '119', '1266', '1492', '335', '1068', '1575', '1724', '223', '944', '1412', '1552', '1672', '1810', '82', '616', '791', '1157', '1321', '1587', '75', '114', '652', '704', '1461', '1809', '70', '1801', '147', '351', '441', '462', '4', '480', '545', '658', '678', '1027', '1853', '683', '988', '1289', '78', '162', '201', '325', '601', '884', '69', '401', '403', '722', '1318', '1330', '1408', '1820', '105', '291', '405', '790', '958', '1245', '341', '1139', '1188', '1303', '1486', '149', '389', '776', '1236', '81', '123', '262', '287', '580', '818', '1073', '1772', '483', '651', '1326', '1327', '1539', '1704', '1771', '1037', '1159', '1367', '1526', '423', '673', '1013', '1043', '1151', '1540', '1757', '266', '796', '1019', '1040', '1172', '45', '290', '639', '968', '1463', '1474', '1573', '635', '1223', '1730', '1743', '84', '574', '751', '775', '795', '852', '1160', '1426', '1681', '1740', '1029', '1035', '1217', '1338', '1344', '1715', '1758', '324', '717', '1163', '1206', '1716', '709', '972', '1095', '1143', '1144', '1146', '1150', '1226', '1229', '1283', '1343', '1358', '1409', '1452', '1453', '1604', '1663', '417', '643', '1483', '1807', '1833', '151', '665', '851', '905', '1048', '1136', '1262', '1293', '1448', '1673', '1746', '212', '885', '1042', '1045', '1230', '1231', '1449', '1787', '467', '644', '1026', '1051', '1137', '1152', '1351', '1405', '1647', '1749', '1791', '769', '1109', '1140', '1154', '1340', '1458', '1723', '1759', '1806', '150', '453', '663', '954', '1025', '1090', '1224', '1366', '1368', '1459', '1609', '1632', '1751', '1816', '208', '448', '559', '701', '920', '973', '996', '1049', '1050', '1148', '1274', '1329', '1354', '1360', '1361', '1362', '1519', '1601', '1649', '1708', '1713', '1805', '666', '740', '914', '921', '923', '927', '1044', '1055', '1072', '1196', '1322', '1339', '1714', '1750', '1788', '1823', '707', '886', '915', '916', '926', '930', '931', '1071', '1294', '1580', '1854', '703', '924', '1047', '1052', '1389', '1596', '1650', '93', '299', '300', '422', '1004', '1020', '1036', '1039', '1054', '1225', '1350', '1352', '1451', '1599', '1664', '205', '253', '479', '784', '937', '487', '672', '888', '965', '1256', '1301', '1626', '1674', '1679', '14', '671', '821')) ORDER BY FIND_IN_SET(id, '1761,732,1744,517,726,258,737,780,1417,1324,855,1588,1717,207,1794,1291,871,874,977,1594,454,1199,1572,1766,404,1359,1272,770,22,330,461,1032,21,393,974,66,716,1237,28,1292,797,1424,434,738,1134,1682,553,332,521,265,1348,333,766,1768,349,711,1415,1260,1419,1423,585,1422,1418,1420,1421,9,715,11,792,857,858,1501,10,1677,163,407,439,455,739,25,1132,1678,34,31,36,378,674,3,24,39,657,542,1460,520,1008,1721,1205,1141,1607,837,1569,385,1067,1742,1302,1852,386,966,1402,1773,882,1168,1233,1372,113,160,1822,35,850,1012,1505,1811,338,626,768,1454,1455,1574,1676,98,1135,1319,1602,573,37,1373,63,285,451,610,1021,30,352,986,817,1284,1413,1733,547,1259,1282,1398,1411,38,1410,1782,111,148,314,1193,108,375,1088,1722,43,286,406,503,1437,508,627,748,1108,198,340,526,1063,1308,1320,1323,1579,1711,1808,970,1145,883,1325,116,124,327,485,854,1586,348,390,582,1149,1738,394,590,1571,1028,1208,119,1266,1492,335,1068,1575,1724,223,944,1412,1552,1672,1810,82,616,791,1157,1321,1587,75,114,652,704,1461,1809,70,1801,147,351,441,462,4,480,545,658,678,1027,1853,683,988,1289,78,162,201,325,601,884,69,401,403,722,1318,1330,1408,1820,105,291,405,790,958,1245,341,1139,1188,1303,1486,149,389,776,1236,81,123,262,287,580,818,1073,1772,483,651,1326,1327,1539,1704,1771,1037,1159,1367,1526,423,673,1013,1043,1151,1540,1757,266,796,1019,1040,1172,45,290,639,968,1463,1474,1573,635,1223,1730,1743,84,574,751,775,795,852,1160,1426,1681,1740,1029,1035,1217,1338,1344,1715,1758,324,717,1163,1206,1716,709,972,1095,1143,1144,1146,1150,1226,1229,1283,1343,1358,1409,1452,1453,1604,1663,417,643,1483,1807,1833,151,665,851,905,1048,1136,1262,1293,1448,1673,1746,212,885,1042,1045,1230,1231,1449,1787,467,644,1026,1051,1137,1152,1351,1405,1647,1749,1791,769,1109,1140,1154,1340,1458,1723,1759,1806,150,453,663,954,1025,1090,1224,1366,1368,1459,1609,1632,1751,1816,208,448,559,701,920,973,996,1049,1050,1148,1274,1329,1354,1360,1361,1362,1519,1601,1649,1708,1713,1805,666,740,914,921,923,927,1044,1055,1072,1196,1322,1339,1714,1750,1788,1823,707,886,915,916,926,930,931,1071,1294,1580,1854,703,924,1047,1052,1389,1596,1650,93,299,300,422,1004,1020,1036,1039,1054,1225,1350,1352,1451,1599,1664,205,253,479,784,937,487,672,888,965,1256,1301,1626,1674,1679,14,671,821') | 0.063275814056396 |
| (239) | DESCRIBE `cruisetypes` | 0.0023429393768311 |
| (240) | DESCRIBE `destinations` | 0.0032680034637451 |
| (241) | SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '22', '12', '54', '35', '43', '25', '37', '9', '2', '8', '44', '55', '53', '39', '40', '26', '38', '28', '30', '7', '49', '11', '45', '21', '48', '29', '52', '34', '10', '46', '56', '32')) ORDER BY FIND_IN_SET(id, '50,22,12,54,35,43,25,37,9,2,8,44,55,53,39,40,26,38,28,30,7,49,11,45,21,48,29,52,34,10,46,56,32') | 0.0035340785980225 |