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.
Step aboard Sea Princess and prepare for a vacation that will dazzle your senses. From the four-story Atrium to tantalizing dining options, a Vegas-style casino and a variety of incredible entertainment choices, including Movies Under the Stars®, you'll find a relaxing retreat that's as captivating as the places you'll visit on this grand vessel.
NB: When Sea Princess in the South Pacific her onboard currency changes to AU$. For the rest of the year it will be US$.
| Star Rating | |
| Currency Used | US Dollars |
| Cruise Type | Contemporary |
| Maiden Voyage | 1998 |
| Refurbished | October 2015 |
| Tonnage | 77,499 tonnes |
| Length | 857 feet |
| Beam | 105.8 feet |
| Draft | 26.6 feet |
| Passenger Capacity | 2000 |
| Crew Nationality | International |
| Cuisine | International |
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: 248
Total elapsed time: 1.1905083656311
| # | Query | Time |
|---|---|---|
| (1) | connect | 0.00092697143554688 |
| (2) | DESCRIBE `cruises` | 0.004580020904541 |
| (3) | SELECT `cruises`.* FROM `cruises` WHERE (orchid_slug = 'sea-world-cruise-2021-ex-auckland-return') AND (orchid_available = 1) LIMIT 1 | 0.79419898986816 |
| (4) | DESCRIBE `avid_specials` | 0.0018799304962158 |
| (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.0022871494293213 |
| (6) | SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '87151') | 0.00044798851013184 |
| (7) | DESCRIBE `ships` | 0.0035400390625 |
| (8) | SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 451))) | 0.00044417381286621 |
| (9) | DESCRIBE `ships` | 0.0036919116973877 |
| (10) | SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '451') | 0.00040602684020996 |
| (11) | SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') | 0.00048995018005371 |
| (12) | SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') | 0.00033903121948242 |
| (13) | DESCRIBE `itineraries` | 0.0017919540405273 |
| (14) | DESCRIBE `ports` | 0.0018429756164551 |
| (15) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) | 0.00043296813964844 |
| (16) | DESCRIBE `ports` | 0.0018429756164551 |
| (17) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) | 0.00041317939758301 |
| (18) | DESCRIBE `ports` | 0.0017697811126709 |
| (19) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') | 0.00037288665771484 |
| (20) | DESCRIBE `sailingdates` | 0.001716136932373 |
| (21) | DESCRIBE `ports` | 0.0017838478088379 |
| (22) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) | 0.00040292739868164 |
| (23) | DESCRIBE `ports` | 0.0018060207366943 |
| (24) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') | 0.00038599967956543 |
| (25) | DESCRIBE `ports` | 0.0018901824951172 |
| (26) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) | 0.00050997734069824 |
| (27) | DESCRIBE `ports` | 0.0019490718841553 |
| (28) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') | 0.00038790702819824 |
| (29) | DESCRIBE `ports` | 0.0018088817596436 |
| (30) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) | 0.00041103363037109 |
| (31) | DESCRIBE `ports` | 0.0020170211791992 |
| (32) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') | 0.00049304962158203 |
| (33) | DESCRIBE `ports` | 0.0025730133056641 |
| (34) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) | 0.00057888031005859 |
| (35) | DESCRIBE `ports` | 0.0023720264434814 |
| (36) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') | 0.00039005279541016 |
| (37) | DESCRIBE `ports` | 0.0018270015716553 |
| (38) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1440))) | 0.00037598609924316 |
| (39) | DESCRIBE `ports` | 0.0018730163574219 |
| (40) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1440') | 0.0003511905670166 |
| (41) | DESCRIBE `ports` | 0.0017600059509277 |
| (42) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) | 0.00038790702819824 |
| (43) | DESCRIBE `ports` | 0.0018060207366943 |
| (44) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') | 0.00038909912109375 |
| (45) | DESCRIBE `ports` | 0.0018370151519775 |
| (46) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 424))) | 0.00038504600524902 |
| (47) | DESCRIBE `ports` | 0.0017561912536621 |
| (48) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '424') | 0.00036215782165527 |
| (49) | DESCRIBE `ports` | 0.0019629001617432 |
| (50) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 427))) | 0.00039196014404297 |
| (51) | DESCRIBE `ports` | 0.0019011497497559 |
| (52) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '427') | 0.00041103363037109 |
| (53) | DESCRIBE `ports` | 0.0022590160369873 |
| (54) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) | 0.00043201446533203 |
| (55) | DESCRIBE `ports` | 0.0019879341125488 |
| (56) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') | 0.00038599967956543 |
| (57) | DESCRIBE `ports` | 0.0018391609191895 |
| (58) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) | 0.00041007995605469 |
| (59) | DESCRIBE `ports` | 0.001816987991333 |
| (60) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') | 0.00039291381835938 |
| (61) | DESCRIBE `ports` | 0.0017509460449219 |
| (62) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 428))) | 0.0003969669342041 |
| (63) | DESCRIBE `ports` | 0.0018651485443115 |
| (64) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '428') | 0.00046801567077637 |
| (65) | DESCRIBE `ports` | 0.0018570423126221 |
| (66) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 712))) | 0.00037288665771484 |
| (67) | DESCRIBE `ports` | 0.0017690658569336 |
| (68) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '712') | 0.00035405158996582 |
| (69) | DESCRIBE `ports` | 0.0018050670623779 |
| (70) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 712))) | 0.00039792060852051 |
| (71) | DESCRIBE `ports` | 0.001859188079834 |
| (72) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '712') | 0.0003509521484375 |
| (73) | DESCRIBE `ports` | 0.0018289089202881 |
| (74) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) | 0.00041484832763672 |
| (75) | DESCRIBE `ports` | 0.001978874206543 |
| (76) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') | 0.00036787986755371 |
| (77) | DESCRIBE `ports` | 0.0018801689147949 |
| (78) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 704))) | 0.00039315223693848 |
| (79) | DESCRIBE `ports` | 0.0019700527191162 |
| (80) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '704') | 0.0003659725189209 |
| (81) | DESCRIBE `ports` | 0.0018560886383057 |
| (82) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) | 0.00041818618774414 |
| (83) | DESCRIBE `ports` | 0.0017750263214111 |
| (84) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') | 0.00037002563476562 |
| (85) | DESCRIBE `ports` | 0.0019211769104004 |
| (86) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1119))) | 0.00038909912109375 |
| (87) | DESCRIBE `ports` | 0.0019650459289551 |
| (88) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1119') | 0.0004880428314209 |
| (89) | DESCRIBE `ports` | 0.0021672248840332 |
| (90) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) | 0.00061702728271484 |
| (91) | DESCRIBE `ports` | 0.0021488666534424 |
| (92) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') | 0.00043606758117676 |
| (93) | DESCRIBE `ports` | 0.0018069744110107 |
| (94) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) | 0.00043392181396484 |
| (95) | DESCRIBE `ports` | 0.0020039081573486 |
| (96) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') | 0.0004270076751709 |
| (97) | DESCRIBE `ports` | 0.0018119812011719 |
| (98) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) | 0.0004580020904541 |
| (99) | DESCRIBE `ports` | 0.0017759799957275 |
| (100) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') | 0.00042104721069336 |
| (101) | DESCRIBE `ports` | 0.0018749237060547 |
| (102) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 391))) | 0.0004417896270752 |
| (103) | DESCRIBE `ports` | 0.0017359256744385 |
| (104) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '391') | 0.00038385391235352 |
| (105) | DESCRIBE `ports` | 0.0018320083618164 |
| (106) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) | 0.00039315223693848 |
| (107) | DESCRIBE `ports` | 0.0018150806427002 |
| (108) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') | 0.00037407875061035 |
| (109) | DESCRIBE `ports` | 0.002284049987793 |
| (110) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 752))) | 0.00052499771118164 |
| (111) | DESCRIBE `ports` | 0.002234935760498 |
| (112) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '752') | 0.00045514106750488 |
| (113) | DESCRIBE `ports` | 0.0021400451660156 |
| (114) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 747))) | 0.00074195861816406 |
| (115) | DESCRIBE `ports` | 0.0020151138305664 |
| (116) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '747') | 0.00046801567077637 |
| (117) | DESCRIBE `ports` | 0.0017898082733154 |
| (118) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2001))) | 0.00043702125549316 |
| (119) | DESCRIBE `ports` | 0.0018379688262939 |
| (120) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2001') | 0.00047707557678223 |
| (121) | DESCRIBE `ports` | 0.0019569396972656 |
| (122) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 781))) | 0.00046491622924805 |
| (123) | DESCRIBE `ports` | 0.0018270015716553 |
| (124) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '781') | 0.00038003921508789 |
| (125) | DESCRIBE `ports` | 0.0017478466033936 |
| (126) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 218))) | 0.00039505958557129 |
| (127) | DESCRIBE `ports` | 0.0018539428710938 |
| (128) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '218') | 0.00037598609924316 |
| (129) | DESCRIBE `ports` | 0.0024120807647705 |
| (130) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1938))) | 0.00057506561279297 |
| (131) | DESCRIBE `ports` | 0.0026850700378418 |
| (132) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1938') | 0.00050210952758789 |
| (133) | DESCRIBE `ports` | 0.0024528503417969 |
| (134) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 754))) | 0.00077986717224121 |
| (135) | DESCRIBE `ports` | 0.0021400451660156 |
| (136) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '754') | 0.00046992301940918 |
| (137) | DESCRIBE `ports` | 0.0018219947814941 |
| (138) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 229))) | 0.0004889965057373 |
| (139) | DESCRIBE `ports` | 0.0019688606262207 |
| (140) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '229') | 0.00040602684020996 |
| (141) | DESCRIBE `ports` | 0.0021309852600098 |
| (142) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1176))) | 0.00045204162597656 |
| (143) | DESCRIBE `ports` | 0.0018429756164551 |
| (144) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1176') | 0.000457763671875 |
| (145) | DESCRIBE `ports` | 0.0017621517181396 |
| (146) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2412))) | 0.00048208236694336 |
| (147) | DESCRIBE `ports` | 0.0023388862609863 |
| (148) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2412') | 0.00042295455932617 |
| (149) | DESCRIBE `ports` | 0.0022141933441162 |
| (150) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1706))) | 0.00060796737670898 |
| (151) | DESCRIBE `ports` | 0.0029418468475342 |
| (152) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1706') | 0.00058412551879883 |
| (153) | DESCRIBE `ports` | 0.0027048587799072 |
| (154) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1087))) | 0.00064396858215332 |
| (155) | DESCRIBE `ports` | 0.0026421546936035 |
| (156) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1087') | 0.000762939453125 |
| (157) | DESCRIBE `ports` | 0.0026130676269531 |
| (158) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) | 0.00077295303344727 |
| (159) | DESCRIBE `ports` | 0.0027370452880859 |
| (160) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') | 0.00055885314941406 |
| (161) | DESCRIBE `ports` | 0.0023071765899658 |
| (162) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3096))) | 0.00043487548828125 |
| (163) | DESCRIBE `ports` | 0.0020360946655273 |
| (164) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3096') | 0.00039911270141602 |
| (165) | DESCRIBE `ports` | 0.0017461776733398 |
| (166) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 117))) | 0.00042009353637695 |
| (167) | DESCRIBE `ports` | 0.0017440319061279 |
| (168) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '117') | 0.00037717819213867 |
| (169) | DESCRIBE `ports` | 0.0017890930175781 |
| (170) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) | 0.0003960132598877 |
| (171) | DESCRIBE `ports` | 0.0017650127410889 |
| (172) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') | 0.00041079521179199 |
| (173) | DESCRIBE `ports` | 0.0021839141845703 |
| (174) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) | 0.00055098533630371 |
| (175) | DESCRIBE `ports` | 0.0025670528411865 |
| (176) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') | 0.00057387351989746 |
| (177) | DESCRIBE `ports` | 0.0018770694732666 |
| (178) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) | 0.00046801567077637 |
| (179) | DESCRIBE `ports` | 0.0020530223846436 |
| (180) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') | 0.00038313865661621 |
| (181) | DESCRIBE `ports` | 0.0018858909606934 |
| (182) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1727))) | 0.00042390823364258 |
| (183) | DESCRIBE `ports` | 0.0018200874328613 |
| (184) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1727') | 0.0006258487701416 |
| (185) | DESCRIBE `ports` | 0.001816987991333 |
| (186) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 165))) | 0.00045490264892578 |
| (187) | DESCRIBE `ports` | 0.0025448799133301 |
| (188) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '165') | 0.00047612190246582 |
| (189) | DESCRIBE `ports` | 0.0019850730895996 |
| (190) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1646))) | 0.00051403045654297 |
| (191) | DESCRIBE `ports` | 0.002079963684082 |
| (192) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1646') | 0.00045990943908691 |
| (193) | DESCRIBE `ports` | 0.0019519329071045 |
| (194) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 431))) | 0.00042295455932617 |
| (195) | DESCRIBE `ports` | 0.0018119812011719 |
| (196) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '431') | 0.00045490264892578 |
| (197) | DESCRIBE `ports` | 0.0017421245574951 |
| (198) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 431))) | 0.0003960132598877 |
| (199) | DESCRIBE `ports` | 0.0018420219421387 |
| (200) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '431') | 0.00037312507629395 |
| (201) | DESCRIBE `ports` | 0.0017290115356445 |
| (202) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 880))) | 0.00040507316589355 |
| (203) | DESCRIBE `ports` | 0.001741886138916 |
| (204) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '880') | 0.00037503242492676 |
| (205) | DESCRIBE `ports` | 0.0019350051879883 |
| (206) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 786))) | 0.0003960132598877 |
| (207) | DESCRIBE `ports` | 0.0018179416656494 |
| (208) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '786') | 0.00037217140197754 |
| (209) | DESCRIBE `ports` | 0.0018579959869385 |
| (210) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) | 0.0005500316619873 |
| (211) | DESCRIBE `ports` | 0.0019009113311768 |
| (212) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') | 0.00043416023254395 |
| (213) | DESCRIBE `ports` | 0.0018401145935059 |
| (214) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) | 0.00041389465332031 |
| (215) | DESCRIBE `ports` | 0.0018608570098877 |
| (216) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') | 0.00038003921508789 |
| (217) | DESCRIBE `ports` | 0.0019521713256836 |
| (218) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) | 0.00047111511230469 |
| (219) | DESCRIBE `ports` | 0.0018789768218994 |
| (220) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') | 0.00040602684020996 |
| (221) | DESCRIBE `ports` | 0.002288818359375 |
| (222) | SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) | 0.00043582916259766 |
| (223) | DESCRIBE `ports` | 0.0018181800842285 |
| (224) | SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') | 0.00037789344787598 |
| (225) | DESCRIBE `cruiselines` | 0.0029330253601074 |
| (226) | SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) | 0.00044083595275879 |
| (227) | DESCRIBE `orchid_image` | 0.0019879341125488 |
| (228) | DESCRIBE `cruiselines` | 0.0025439262390137 |
| (229) | SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') | 0.00039315223693848 |
| (230) | DESCRIBE `cabins` | 0.0018332004547119 |
| (231) | DESCRIBE `deckplans` | 0.0016829967498779 |
| (232) | DESCRIBE `shipphotos` | 0.0025439262390137 |
| (233) | DESCRIBE `cruiselines` | 0.0029110908508301 |
| (234) | SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) | 0.00050210952758789 |
| (235) | DESCRIBE `orchid_image` | 0.0019569396972656 |
| (236) | DESCRIBE `cruiselines` | 0.0026578903198242 |
| (237) | SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') | 0.00070405006408691 |
| (238) | SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') | 0.00058412551879883 |
| (239) | SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') | 0.00046706199645996 |
| (240) | DESCRIBE `cruises` | 0.00528883934021 |
| (241) | 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.0033600330352783 |
| (242) | DESCRIBE `cruiselines` | 0.0032148361206055 |
| (243) | 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.0070369243621826 |
| (244) | DESCRIBE `ships` | 0.004101037979126 |
| (245) | 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.06364893913269 |
| (246) | DESCRIBE `cruisetypes` | 0.0017549991607666 |
| (247) | DESCRIBE `destinations` | 0.0023188591003418 |
| (248) | 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.0031871795654297 |