| (1) |
connect |
0.00081801414489746 |
| (2) |
DESCRIBE `cruises` |
0.0033471584320068 |
| (3) |
SELECT `cruises`.* FROM `cruises` WHERE (id IN (67295, 72995, 69895, 80004, 67917, 80005, 78125, 66816, 77957, 75551)) ORDER BY FIND_IN_SET(id, '67295,72995,69895,80004,67917,80005,78125,66816,77957,75551') |
0.0019900798797607 |
| (4) |
DESCRIBE `specials` |
0.003709077835083 |
| (5) |
DESCRIBE `specials` |
0.0036249160766602 |
| (6) |
SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1496939') |
0.00061202049255371 |
| (7) |
DESCRIBE `ships` |
0.0027709007263184 |
| (8) |
SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) |
0.00059700012207031 |
| (9) |
DESCRIBE `ships` |
0.0027899742126465 |
| (10) |
SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') |
0.00041913986206055 |
| (11) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') |
0.00026488304138184 |
| (12) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') |
0.00025200843811035 |
| (13) |
DESCRIBE `itineraries` |
0.0014750957489014 |
| (14) |
DESCRIBE `ports` |
0.0014500617980957 |
| (15) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) |
0.00040793418884277 |
| (16) |
DESCRIBE `ports` |
0.0013339519500732 |
| (17) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) |
0.00032186508178711 |
| (18) |
DESCRIBE `ports` |
0.0016231536865234 |
| (19) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') |
0.00033688545227051 |
| (20) |
DESCRIBE `specialsailingdates` |
0.0012052059173584 |
| (21) |
DESCRIBE `sailingdates` |
0.0012040138244629 |
| (22) |
SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 424403))) |
0.00058293342590332 |
| (23) |
DESCRIBE `ports` |
0.0014121532440186 |
| (24) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) |
0.0003359317779541 |
| (25) |
DESCRIBE `ports` |
0.0013689994812012 |
| (26) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') |
0.00040793418884277 |
| (27) |
DESCRIBE `ports` |
0.0012550354003906 |
| (28) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) |
0.00031495094299316 |
| (29) |
DESCRIBE `ports` |
0.0016210079193115 |
| (30) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') |
0.0003349781036377 |
| (31) |
DESCRIBE `ports` |
0.0015501976013184 |
| (32) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) |
0.00044703483581543 |
| (33) |
DESCRIBE `ports` |
0.0015699863433838 |
| (34) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') |
0.00035190582275391 |
| (35) |
DESCRIBE `ports` |
0.0018038749694824 |
| (36) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) |
0.00042510032653809 |
| (37) |
DESCRIBE `ports` |
0.0019161701202393 |
| (38) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') |
0.00039410591125488 |
| (39) |
DESCRIBE `ports` |
0.0017778873443604 |
| (40) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) |
0.0004279613494873 |
| (41) |
DESCRIBE `ports` |
0.0018768310546875 |
| (42) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') |
0.00041890144348145 |
| (43) |
DESCRIBE `cruises` |
0.0036990642547607 |
| (44) |
SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 67295))) |
0.00056886672973633 |
| (45) |
DESCRIBE `avid_specials` |
0.0016930103302002 |
| (46) |
SELECT `avid_specials`.* FROM `avid_specials`
LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1496939 and class = 'Special') OR (item_id = 67295 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) |
0.0041420459747314 |
| (47) |
DESCRIBE `cruiselines` |
0.0028769969940186 |
| (48) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) |
0.00053000450134277 |
| (49) |
DESCRIBE `orchid_image` |
0.0021557807922363 |
| (50) |
DESCRIBE `cruiselines` |
0.0024089813232422 |
| (51) |
SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') |
0.00041294097900391 |
| (52) |
DESCRIBE `specials` |
0.0042529106140137 |
| (53) |
DESCRIBE `specials` |
0.0044970512390137 |
| (54) |
SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1497393') |
0.00044393539428711 |
| (55) |
DESCRIBE `ships` |
0.0030860900878906 |
| (56) |
SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 485))) |
0.00042605400085449 |
| (57) |
DESCRIBE `ships` |
0.0027861595153809 |
| (58) |
SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '485') |
0.00037693977355957 |
| (59) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') |
0.00027012825012207 |
| (60) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') |
0.0002598762512207 |
| (61) |
DESCRIBE `itineraries` |
0.0018410682678223 |
| (62) |
DESCRIBE `ports` |
0.0019609928131104 |
| (63) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) |
0.00051498413085938 |
| (64) |
DESCRIBE `ports` |
0.0020480155944824 |
| (65) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) |
0.00047206878662109 |
| (66) |
DESCRIBE `ports` |
0.00189208984375 |
| (67) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') |
0.00038886070251465 |
| (68) |
DESCRIBE `specialsailingdates` |
0.0013201236724854 |
| (69) |
DESCRIBE `sailingdates` |
0.0017719268798828 |
| (70) |
SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 460245))) |
0.00059294700622559 |
| (71) |
DESCRIBE `ports` |
0.0019488334655762 |
| (72) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) |
0.0004580020904541 |
| (73) |
DESCRIBE `ports` |
0.0018739700317383 |
| (74) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') |
0.00038886070251465 |
| (75) |
DESCRIBE `ports` |
0.0018899440765381 |
| (76) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2086))) |
0.00045919418334961 |
| (77) |
DESCRIBE `ports` |
0.0018517971038818 |
| (78) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2086') |
0.00041484832763672 |
| (79) |
DESCRIBE `ports` |
0.0016601085662842 |
| (80) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) |
0.00038385391235352 |
| (81) |
DESCRIBE `ports` |
0.0013768672943115 |
| (82) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') |
0.0003809928894043 |
| (83) |
DESCRIBE `ports` |
0.0016579627990723 |
| (84) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) |
0.00044894218444824 |
| (85) |
DESCRIBE `ports` |
0.0017709732055664 |
| (86) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') |
0.00042915344238281 |
| (87) |
DESCRIBE `ports` |
0.0017809867858887 |
| (88) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) |
0.00037384033203125 |
| (89) |
DESCRIBE `ports` |
0.0018188953399658 |
| (90) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') |
0.00035595893859863 |
| (91) |
DESCRIBE `ports` |
0.0015029907226562 |
| (92) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) |
0.00033712387084961 |
| (93) |
DESCRIBE `ports` |
0.0013802051544189 |
| (94) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') |
0.00036382675170898 |
| (95) |
DESCRIBE `ports` |
0.001323938369751 |
| (96) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) |
0.00032711029052734 |
| (97) |
DESCRIBE `ports` |
0.0015161037445068 |
| (98) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') |
0.0028560161590576 |
| (99) |
DESCRIBE `ports` |
0.0014641284942627 |
| (100) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) |
0.00075006484985352 |
| (101) |
DESCRIBE `ports` |
0.0015871524810791 |
| (102) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') |
0.00030899047851562 |
| (103) |
DESCRIBE `ports` |
0.0013349056243896 |
| (104) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) |
0.0003659725189209 |
| (105) |
DESCRIBE `ports` |
0.0014350414276123 |
| (106) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') |
0.00029802322387695 |
| (107) |
DESCRIBE `ports` |
0.0015280246734619 |
| (108) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) |
0.00040602684020996 |
| (109) |
DESCRIBE `ports` |
0.0013511180877686 |
| (110) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') |
0.00028681755065918 |
| (111) |
DESCRIBE `ports` |
0.0013489723205566 |
| (112) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) |
0.00035810470581055 |
| (113) |
DESCRIBE `ports` |
0.0013670921325684 |
| (114) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') |
0.00033807754516602 |
| (115) |
DESCRIBE `ports` |
0.0016839504241943 |
| (116) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) |
0.00037598609924316 |
| (117) |
DESCRIBE `ports` |
0.0013649463653564 |
| (118) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') |
0.00030899047851562 |
| (119) |
DESCRIBE `ports` |
0.0013799667358398 |
| (120) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) |
0.00031304359436035 |
| (121) |
DESCRIBE `ports` |
0.0014958381652832 |
| (122) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') |
0.00030016899108887 |
| (123) |
DESCRIBE `ports` |
0.0012800693511963 |
| (124) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) |
0.00040698051452637 |
| (125) |
DESCRIBE `ports` |
0.001471996307373 |
| (126) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') |
0.0003349781036377 |
| (127) |
DESCRIBE `ports` |
0.0014641284942627 |
| (128) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) |
0.00034403800964355 |
| (129) |
DESCRIBE `ports` |
0.0014481544494629 |
| (130) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') |
0.00028705596923828 |
| (131) |
DESCRIBE `cruises` |
0.0028390884399414 |
| (132) |
SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 72995))) |
0.00046205520629883 |
| (133) |
DESCRIBE `avid_specials` |
0.0014228820800781 |
| (134) |
SELECT `avid_specials`.* FROM `avid_specials`
LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1497393 and class = 'Special') OR (item_id = 72995 and class = 'Cruise') OR (item_id = 485 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) |
0.0017139911651611 |
| (135) |
DESCRIBE `cruiselines` |
0.0024600028991699 |
| (136) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) |
0.00049591064453125 |
| (137) |
DESCRIBE `orchid_image` |
0.0018370151519775 |
| (138) |
DESCRIBE `cruiselines` |
0.0019080638885498 |
| (139) |
SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') |
0.00040197372436523 |
| (140) |
DESCRIBE `specials` |
0.0047369003295898 |
| (141) |
DESCRIBE `specials` |
0.0054609775543213 |
| (142) |
SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1496799') |
0.00052309036254883 |
| (143) |
DESCRIBE `ships` |
0.0034520626068115 |
| (144) |
SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 287))) |
0.00058889389038086 |
| (145) |
DESCRIBE `ships` |
0.0039131641387939 |
| (146) |
SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '287') |
0.00049185752868652 |
| (147) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') |
0.00032186508178711 |
| (148) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') |
0.00034594535827637 |
| (149) |
DESCRIBE `itineraries` |
0.0019481182098389 |
| (150) |
DESCRIBE `ports` |
0.0018651485443115 |
| (151) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) |
0.00048613548278809 |
| (152) |
DESCRIBE `ports` |
0.0019540786743164 |
| (153) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) |
0.0005490779876709 |
| (154) |
DESCRIBE `ports` |
0.0020380020141602 |
| (155) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') |
0.00044107437133789 |
| (156) |
DESCRIBE `specialsailingdates` |
0.0015997886657715 |
| (157) |
DESCRIBE `sailingdates` |
0.0017561912536621 |
| (158) |
SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 438774))) |
0.00057315826416016 |
| (159) |
DESCRIBE `ports` |
0.0017919540405273 |
| (160) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) |
0.00044584274291992 |
| (161) |
DESCRIBE `ports` |
0.0017449855804443 |
| (162) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') |
0.00038695335388184 |
| (163) |
DESCRIBE `ports` |
0.0018031597137451 |
| (164) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) |
0.00042891502380371 |
| (165) |
DESCRIBE `ports` |
0.001945972442627 |
| (166) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') |
0.00044679641723633 |
| (167) |
DESCRIBE `ports` |
0.0018761157989502 |
| (168) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) |
0.00038409233093262 |
| (169) |
DESCRIBE `ports` |
0.0018990039825439 |
| (170) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') |
0.00041103363037109 |
| (171) |
DESCRIBE `ports` |
0.0016908645629883 |
| (172) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) |
0.00040793418884277 |
| (173) |
DESCRIBE `ports` |
0.0014808177947998 |
| (174) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') |
0.00031089782714844 |
| (175) |
DESCRIBE `ports` |
0.0014939308166504 |
| (176) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) |
0.00036406517028809 |
| (177) |
DESCRIBE `ports` |
0.0014560222625732 |
| (178) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') |
0.00043416023254395 |
| (179) |
DESCRIBE `ports` |
0.0018370151519775 |
| (180) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) |
0.00042891502380371 |
| (181) |
DESCRIBE `ports` |
0.0015559196472168 |
| (182) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') |
0.00031495094299316 |
| (183) |
DESCRIBE `ports` |
0.001561164855957 |
| (184) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) |
0.0003659725189209 |
| (185) |
DESCRIBE `ports` |
0.0014419555664062 |
| (186) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') |
0.00030088424682617 |
| (187) |
DESCRIBE `ports` |
0.0015838146209717 |
| (188) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) |
0.00034213066101074 |
| (189) |
DESCRIBE `ports` |
0.0016028881072998 |
| (190) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') |
0.00031304359436035 |
| (191) |
DESCRIBE `cruises` |
0.0026900768280029 |
| (192) |
SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 69895))) |
0.00052094459533691 |
| (193) |
DESCRIBE `avid_specials` |
0.001352071762085 |
| (194) |
SELECT `avid_specials`.* FROM `avid_specials`
LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1496799 and class = 'Special') OR (item_id = 69895 and class = 'Cruise') OR (item_id = 287 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) |
0.0012521743774414 |
| (195) |
DESCRIBE `cruiselines` |
0.0025339126586914 |
| (196) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) |
0.00047183036804199 |
| (197) |
DESCRIBE `orchid_image` |
0.0016670227050781 |
| (198) |
DESCRIBE `cruiselines` |
0.0019118785858154 |
| (199) |
SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') |
0.00039410591125488 |
| (200) |
DESCRIBE `specials` |
0.0049901008605957 |
| (201) |
DESCRIBE `specials` |
0.005328893661499 |
| (202) |
SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1492180') |
0.00057101249694824 |
| (203) |
DESCRIBE `ships` |
0.0036330223083496 |
| (204) |
SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 394))) |
0.00055384635925293 |
| (205) |
DESCRIBE `ships` |
0.0036261081695557 |
| (206) |
SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '394') |
0.00046491622924805 |
| (207) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') |
0.00033807754516602 |
| (208) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') |
0.00031781196594238 |
| (209) |
DESCRIBE `itineraries` |
0.0018050670623779 |
| (210) |
DESCRIBE `ports` |
0.0018229484558105 |
| (211) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) |
0.00050592422485352 |
| (212) |
DESCRIBE `ports` |
0.0017318725585938 |
| (213) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) |
0.00042414665222168 |
| (214) |
DESCRIBE `ports` |
0.0016129016876221 |
| (215) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') |
0.00029587745666504 |
| (216) |
DESCRIBE `specialsailingdates` |
0.0010490417480469 |
| (217) |
DESCRIBE `sailingdates` |
0.0011980533599854 |
| (218) |
SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 494406))) |
0.0004880428314209 |
| (219) |
DESCRIBE `ports` |
0.0013799667358398 |
| (220) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) |
0.00033092498779297 |
| (221) |
DESCRIBE `ports` |
0.0013120174407959 |
| (222) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') |
0.00034880638122559 |
| (223) |
DESCRIBE `ports` |
0.0014650821685791 |
| (224) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) |
0.00044608116149902 |
| (225) |
DESCRIBE `ports` |
0.0018758773803711 |
| (226) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') |
0.00038719177246094 |
| (227) |
DESCRIBE `ports` |
0.0018110275268555 |
| (228) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) |
0.0004730224609375 |
| (229) |
DESCRIBE `ports` |
0.0019509792327881 |
| (230) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') |
0.0003972053527832 |
| (231) |
DESCRIBE `cruises` |
0.0027949810028076 |
| (232) |
SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 80004))) |
0.00038790702819824 |
| (233) |
DESCRIBE `avid_specials` |
0.0013527870178223 |
| (234) |
SELECT `avid_specials`.* FROM `avid_specials`
LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1492180 and class = 'Special') OR (item_id = 80004 and class = 'Cruise') OR (item_id = 394 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) |
0.0018820762634277 |
| (235) |
DESCRIBE `cruiselines` |
0.0026190280914307 |
| (236) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) |
0.00046491622924805 |
| (237) |
DESCRIBE `orchid_image` |
0.0020499229431152 |
| (238) |
DESCRIBE `cruiselines` |
0.002551794052124 |
| (239) |
SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') |
0.00032210350036621 |
| (240) |
DESCRIBE `specials` |
0.0040149688720703 |
| (241) |
DESCRIBE `specials` |
0.0054471492767334 |
| (242) |
SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1488100') |
0.00058603286743164 |
| (243) |
DESCRIBE `ships` |
0.0028688907623291 |
| (244) |
SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 669))) |
0.00048494338989258 |
| (245) |
DESCRIBE `ships` |
0.0038509368896484 |
| (246) |
SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '669') |
0.00048303604125977 |
| (247) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') |
0.00034809112548828 |
| (248) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') |
0.00043606758117676 |
| (249) |
DESCRIBE `itineraries` |
0.001917839050293 |
| (250) |
DESCRIBE `ports` |
0.0015218257904053 |
| (251) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) |
0.00036096572875977 |
| (252) |
DESCRIBE `ports` |
0.0014121532440186 |
| (253) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) |
0.00033092498779297 |
| (254) |
DESCRIBE `ports` |
0.0016450881958008 |
| (255) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') |
0.00037121772766113 |
| (256) |
DESCRIBE `specialsailingdates` |
0.00136399269104 |
| (257) |
DESCRIBE `sailingdates` |
0.0014998912811279 |
| (258) |
SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 428527))) |
0.00046610832214355 |
| (259) |
DESCRIBE `ports` |
0.0017869472503662 |
| (260) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) |
0.00046586990356445 |
| (261) |
DESCRIBE `ports` |
0.0018100738525391 |
| (262) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') |
0.00041007995605469 |
| (263) |
DESCRIBE `ports` |
0.0015969276428223 |
| (264) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) |
0.00036096572875977 |
| (265) |
DESCRIBE `ports` |
0.0013570785522461 |
| (266) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') |
0.00029993057250977 |
| (267) |
DESCRIBE `ports` |
0.0017960071563721 |
| (268) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 166))) |
0.00054001808166504 |
| (269) |
DESCRIBE `ports` |
0.0017819404602051 |
| (270) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '166') |
0.00038003921508789 |
| (271) |
DESCRIBE `ports` |
0.0014891624450684 |
| (272) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 166))) |
0.00031495094299316 |
| (273) |
DESCRIBE `ports` |
0.0013461112976074 |
| (274) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '166') |
0.00027585029602051 |
| (275) |
DESCRIBE `ports` |
0.0012838840484619 |
| (276) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) |
0.00036191940307617 |
| (277) |
DESCRIBE `ports` |
0.001662015914917 |
| (278) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') |
0.0004420280456543 |
| (279) |
DESCRIBE `cruises` |
0.0041100978851318 |
| (280) |
SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 67917))) |
0.00060796737670898 |
| (281) |
DESCRIBE `avid_specials` |
0.0018219947814941 |
| (282) |
SELECT `avid_specials`.* FROM `avid_specials`
LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1488100 and class = 'Special') OR (item_id = 67917 and class = 'Cruise') OR (item_id = 669 AND class = 'Ship') OR (item_id = 218 AND class = 'CruiseLine') OR (item_id = 53 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.0014269351959229 |
| (283) |
DESCRIBE `cruiselines` |
0.0023071765899658 |
| (284) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) |
0.00041913986206055 |
| (285) |
DESCRIBE `orchid_image` |
0.0018670558929443 |
| (286) |
DESCRIBE `cruiselines` |
0.0021989345550537 |
| (287) |
SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') |
0.00036311149597168 |
| (288) |
DESCRIBE `specials` |
0.0042550563812256 |
| (289) |
DESCRIBE `specials` |
0.0042991638183594 |
| (290) |
SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1492181') |
0.00075697898864746 |
| (291) |
DESCRIBE `ships` |
0.0035390853881836 |
| (292) |
SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 394))) |
0.0004420280456543 |
| (293) |
DESCRIBE `ships` |
0.0058019161224365 |
| (294) |
SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '394') |
0.00043201446533203 |
| (295) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') |
0.00032997131347656 |
| (296) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') |
0.00031399726867676 |
| (297) |
DESCRIBE `itineraries` |
0.0017809867858887 |
| (298) |
DESCRIBE `ports` |
0.0018329620361328 |
| (299) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) |
0.00045895576477051 |
| (300) |
DESCRIBE `ports` |
0.0025410652160645 |
| (301) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) |
0.00042104721069336 |
| (302) |
DESCRIBE `ports` |
0.001708984375 |
| (303) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') |
0.00036501884460449 |
| (304) |
DESCRIBE `specialsailingdates` |
0.0013468265533447 |
| (305) |
DESCRIBE `sailingdates` |
0.0030171871185303 |
| (306) |
SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 494408))) |
0.00045895576477051 |
| (307) |
DESCRIBE `ports` |
0.0017838478088379 |
| (308) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) |
0.00042891502380371 |
| (309) |
DESCRIBE `ports` |
0.0017530918121338 |
| (310) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') |
0.00037789344787598 |
| (311) |
DESCRIBE `ports` |
0.0020499229431152 |
| (312) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) |
0.00041294097900391 |
| (313) |
DESCRIBE `ports` |
0.0016739368438721 |
| (314) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') |
0.00035309791564941 |
| (315) |
DESCRIBE `ports` |
0.0017380714416504 |
| (316) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2086))) |
0.00042295455932617 |
| (317) |
DESCRIBE `ports` |
0.0017318725585938 |
| (318) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2086') |
0.00042581558227539 |
| (319) |
DESCRIBE `ports` |
0.0017900466918945 |
| (320) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) |
0.0006401538848877 |
| (321) |
DESCRIBE `ports` |
0.0018730163574219 |
| (322) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') |
0.00037622451782227 |
| (323) |
DESCRIBE `ports` |
0.0017211437225342 |
| (324) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) |
0.0004119873046875 |
| (325) |
DESCRIBE `ports` |
0.0017080307006836 |
| (326) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') |
0.00038003921508789 |
| (327) |
DESCRIBE `ports` |
0.00180983543396 |
| (328) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) |
0.00058698654174805 |
| (329) |
DESCRIBE `ports` |
0.0016138553619385 |
| (330) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') |
0.00036406517028809 |
| (331) |
DESCRIBE `ports` |
0.0016670227050781 |
| (332) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) |
0.00043416023254395 |
| (333) |
DESCRIBE `ports` |
0.0018188953399658 |
| (334) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') |
0.00040388107299805 |
| (335) |
DESCRIBE `ports` |
0.0017149448394775 |
| (336) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) |
0.00043296813964844 |
| (337) |
DESCRIBE `ports` |
0.0018770694732666 |
| (338) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') |
0.0004570484161377 |
| (339) |
DESCRIBE `ports` |
0.0081949234008789 |
| (340) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) |
0.00045990943908691 |
| (341) |
DESCRIBE `ports` |
0.0018310546875 |
| (342) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') |
0.00036907196044922 |
| (343) |
DESCRIBE `ports` |
0.0045289993286133 |
| (344) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) |
0.00054097175598145 |
| (345) |
DESCRIBE `ports` |
0.0017378330230713 |
| (346) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') |
0.00037121772766113 |
| (347) |
DESCRIBE `ports` |
0.0019650459289551 |
| (348) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) |
0.0035991668701172 |
| (349) |
DESCRIBE `ports` |
0.0020239353179932 |
| (350) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') |
0.0014898777008057 |
| (351) |
DESCRIBE `cruises` |
0.0034010410308838 |
| (352) |
SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 80005))) |
0.0010011196136475 |
| (353) |
DESCRIBE `avid_specials` |
0.0014920234680176 |
| (354) |
SELECT `avid_specials`.* FROM `avid_specials`
LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1492181 and class = 'Special') OR (item_id = 80005 and class = 'Cruise') OR (item_id = 394 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) |
0.013238191604614 |
| (355) |
DESCRIBE `cruiselines` |
0.0021998882293701 |
| (356) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) |
0.00031495094299316 |
| (357) |
DESCRIBE `orchid_image` |
0.0019850730895996 |
| (358) |
DESCRIBE `cruiselines` |
0.0022969245910645 |
| (359) |
SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') |
0.0031599998474121 |
| (360) |
DESCRIBE `specials` |
0.0044300556182861 |
| (361) |
DESCRIBE `specials` |
0.014611005783081 |
| (362) |
SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1491947') |
0.0038261413574219 |
| (363) |
DESCRIBE `ships` |
0.0041980743408203 |
| (364) |
SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1474))) |
0.00038003921508789 |
| (365) |
DESCRIBE `ships` |
0.002586841583252 |
| (366) |
SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1474') |
0.00037384033203125 |
| (367) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') |
0.00040507316589355 |
| (368) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') |
0.0003359317779541 |
| (369) |
DESCRIBE `itineraries` |
0.0018799304962158 |
| (370) |
DESCRIBE `ports` |
0.0019278526306152 |
| (371) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 324))) |
0.00043201446533203 |
| (372) |
DESCRIBE `ports` |
0.0018379688262939 |
| (373) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 324))) |
0.00029993057250977 |
| (374) |
DESCRIBE `ports` |
0.0024628639221191 |
| (375) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '324') |
0.00037002563476562 |
| (376) |
DESCRIBE `specialsailingdates` |
0.0093908309936523 |
| (377) |
DESCRIBE `sailingdates` |
0.0028891563415527 |
| (378) |
SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 486299))) |
0.00050592422485352 |
| (379) |
DESCRIBE `ports` |
0.0016639232635498 |
| (380) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 324))) |
0.0003199577331543 |
| (381) |
DESCRIBE `ports` |
0.0015208721160889 |
| (382) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '324') |
0.00032401084899902 |
| (383) |
DESCRIBE `ports` |
0.0017650127410889 |
| (384) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2024))) |
0.0068080425262451 |
| (385) |
DESCRIBE `ports` |
0.0040388107299805 |
| (386) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2024') |
0.0029010772705078 |
| (387) |
DESCRIBE `ports` |
0.0015261173248291 |
| (388) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 786))) |
0.0047228336334229 |
| (389) |
DESCRIBE `ports` |
0.0013599395751953 |
| (390) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '786') |
0.00028610229492188 |
| (391) |
DESCRIBE `ports` |
0.001147985458374 |
| (392) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) |
0.0013399124145508 |
| (393) |
DESCRIBE `ports` |
0.0013551712036133 |
| (394) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') |
0.0069019794464111 |
| (395) |
DESCRIBE `ports` |
0.0020442008972168 |
| (396) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) |
0.00044488906860352 |
| (397) |
DESCRIBE `ports` |
0.0019500255584717 |
| (398) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') |
0.006483793258667 |
| (399) |
DESCRIBE `ports` |
0.0018270015716553 |
| (400) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) |
0.00037693977355957 |
| (401) |
DESCRIBE `ports` |
0.0016021728515625 |
| (402) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') |
0.0019040107727051 |
| (403) |
DESCRIBE `ports` |
0.0050630569458008 |
| (404) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) |
0.00044393539428711 |
| (405) |
DESCRIBE `ports` |
0.0014948844909668 |
| (406) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') |
0.004270076751709 |
| (407) |
DESCRIBE `ports` |
0.0013940334320068 |
| (408) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) |
0.0041749477386475 |
| (409) |
DESCRIBE `ports` |
0.0018270015716553 |
| (410) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') |
0.005842924118042 |
| (411) |
DESCRIBE `ports` |
0.0013258457183838 |
| (412) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) |
0.00020194053649902 |
| (413) |
DESCRIBE `ports` |
0.0013141632080078 |
| (414) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') |
0.00035786628723145 |
| (415) |
DESCRIBE `ports` |
0.0017800331115723 |
| (416) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) |
0.0093638896942139 |
| (417) |
DESCRIBE `ports` |
0.0014948844909668 |
| (418) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') |
0.00030303001403809 |
| (419) |
DESCRIBE `ports` |
0.0012598037719727 |
| (420) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) |
0.0003972053527832 |
| (421) |
DESCRIBE `ports` |
0.0016889572143555 |
| (422) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') |
0.0062789916992188 |
| (423) |
DESCRIBE `ports` |
0.0018138885498047 |
| (424) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) |
0.00017809867858887 |
| (425) |
DESCRIBE `ports` |
0.0018539428710938 |
| (426) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') |
0.0038189888000488 |
| (427) |
DESCRIBE `ports` |
0.0013320446014404 |
| (428) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) |
0.0036540031433105 |
| (429) |
DESCRIBE `ports` |
0.0013589859008789 |
| (430) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') |
0.0027909278869629 |
| (431) |
DESCRIBE `cruises` |
0.0024800300598145 |
| (432) |
SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 78125))) |
0.0048279762268066 |
| (433) |
DESCRIBE `avid_specials` |
0.001291036605835 |
| (434) |
SELECT `avid_specials`.* FROM `avid_specials`
LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1491947 and class = 'Special') OR (item_id = 78125 and class = 'Cruise') OR (item_id = 1474 AND class = 'Ship') OR (item_id = 262 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) |
0.0010519027709961 |
| (435) |
DESCRIBE `cruiselines` |
0.0083119869232178 |
| (436) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262))) |
0.00051522254943848 |
| (437) |
DESCRIBE `orchid_image` |
0.0014989376068115 |
| (438) |
DESCRIBE `cruiselines` |
0.0061781406402588 |
| (439) |
SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '262') |
0.00033402442932129 |
| (440) |
DESCRIBE `specials` |
0.007728099822998 |
| (441) |
DESCRIBE `specials` |
0.0096771717071533 |
| (442) |
SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1481854') |
0.015400171279907 |
| (443) |
DESCRIBE `ships` |
0.0033450126647949 |
| (444) |
SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 683))) |
0.00056791305541992 |
| (445) |
DESCRIBE `ships` |
0.0033080577850342 |
| (446) |
SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '683') |
0.008303165435791 |
| (447) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') |
0.00033187866210938 |
| (448) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') |
0.00024986267089844 |
| (449) |
DESCRIBE `itineraries` |
0.0085620880126953 |
| (450) |
DESCRIBE `ports` |
0.0013580322265625 |
| (451) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) |
0.0067930221557617 |
| (452) |
DESCRIBE `ports` |
0.0013730525970459 |
| (453) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) |
0.00030994415283203 |
| (454) |
DESCRIBE `ports` |
0.0013871192932129 |
| (455) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') |
0.00027894973754883 |
| (456) |
DESCRIBE `specialsailingdates` |
0.0012249946594238 |
| (457) |
DESCRIBE `sailingdates` |
0.0011570453643799 |
| (458) |
SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 419451))) |
0.0027570724487305 |
| (459) |
DESCRIBE `ports` |
0.0013630390167236 |
| (460) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) |
0.00099086761474609 |
| (461) |
DESCRIBE `ports` |
0.0013561248779297 |
| (462) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') |
0.00029587745666504 |
| (463) |
DESCRIBE `ports` |
0.0017101764678955 |
| (464) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) |
0.00032401084899902 |
| (465) |
DESCRIBE `ports` |
0.0016121864318848 |
| (466) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') |
0.00031805038452148 |
| (467) |
DESCRIBE `ports` |
0.0012671947479248 |
| (468) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) |
0.0003349781036377 |
| (469) |
DESCRIBE `ports` |
0.0013301372528076 |
| (470) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') |
0.00026583671569824 |
| (471) |
DESCRIBE `ports` |
0.001345157623291 |
| (472) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) |
0.00029683113098145 |
| (473) |
DESCRIBE `ports` |
0.0012879371643066 |
| (474) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') |
3.3140182495117E-5 |
| (475) |
DESCRIBE `ports` |
0.001500129699707 |
| (476) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) |
0.00040197372436523 |
| (477) |
DESCRIBE `ports` |
0.0013608932495117 |
| (478) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') |
0 |
| (479) |
DESCRIBE `ports` |
0.0014030933380127 |
| (480) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) |
0.00043797492980957 |
| (481) |
DESCRIBE `ports` |
0.0010879039764404 |
| (482) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') |
0.00029397010803223 |
| (483) |
DESCRIBE `ports` |
0.0012609958648682 |
| (484) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) |
0.0003209114074707 |
| (485) |
DESCRIBE `ports` |
0.0014200210571289 |
| (486) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') |
0.0005338191986084 |
| (487) |
DESCRIBE `ports` |
0.0018548965454102 |
| (488) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) |
0.0003809928894043 |
| (489) |
DESCRIBE `ports` |
0.00130295753479 |
| (490) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') |
0.00029277801513672 |
| (491) |
DESCRIBE `ports` |
0.0013151168823242 |
| (492) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 23))) |
0.0003211498260498 |
| (493) |
DESCRIBE `ports` |
0.0012619495391846 |
| (494) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '23') |
0.00030517578125 |
| (495) |
DESCRIBE `cruises` |
0.0024080276489258 |
| (496) |
SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 66816))) |
0.00053286552429199 |
| (497) |
DESCRIBE `avid_specials` |
0.0013511180877686 |
| (498) |
SELECT `avid_specials`.* FROM `avid_specials`
LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1481854 and class = 'Special') OR (item_id = 66816 and class = 'Cruise') OR (item_id = 683 AND class = 'Ship') OR (item_id = 8 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) |
0.0011880397796631 |
| (499) |
DESCRIBE `cruiselines` |
0.0022299289703369 |
| (500) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) |
0.00046300888061523 |
| (501) |
DESCRIBE `orchid_image` |
0.0016229152679443 |
| (502) |
DESCRIBE `cruiselines` |
0.0020670890808105 |
| (503) |
SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') |
0.00032186508178711 |
| (504) |
DESCRIBE `specials` |
0.0038859844207764 |
| (505) |
DESCRIBE `specials` |
0.0043399333953857 |
| (506) |
SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1489695') |
0.00055408477783203 |
| (507) |
DESCRIBE `ships` |
0.0026659965515137 |
| (508) |
SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1402))) |
0.00043582916259766 |
| (509) |
DESCRIBE `ships` |
0.002877950668335 |
| (510) |
SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1402') |
0.00053095817565918 |
| (511) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') |
0.00033807754516602 |
| (512) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') |
0.00034809112548828 |
| (513) |
DESCRIBE `itineraries` |
0.0021369457244873 |
| (514) |
DESCRIBE `ports` |
0.0016601085662842 |
| (515) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) |
0.00037503242492676 |
| (516) |
DESCRIBE `ports` |
0.001317024230957 |
| (517) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) |
0.00031805038452148 |
| (518) |
DESCRIBE `ports` |
0.0013258457183838 |
| (519) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') |
0.00031399726867676 |
| (520) |
DESCRIBE `specialsailingdates` |
0.0011360645294189 |
| (521) |
DESCRIBE `sailingdates` |
0.0012929439544678 |
| (522) |
SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 485882))) |
0.00045990943908691 |
| (523) |
DESCRIBE `ports` |
0.001859188079834 |
| (524) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) |
0.00052404403686523 |
| (525) |
DESCRIBE `ports` |
0.0019669532775879 |
| (526) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') |
0.00044393539428711 |
| (527) |
DESCRIBE `ports` |
0.0019428730010986 |
| (528) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) |
0.00049495697021484 |
| (529) |
DESCRIBE `ports` |
0.0019059181213379 |
| (530) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') |
0.00041890144348145 |
| (531) |
DESCRIBE `cruises` |
0.0035881996154785 |
| (532) |
SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 77957))) |
0.00070500373840332 |
| (533) |
DESCRIBE `avid_specials` |
0.0018081665039062 |
| (534) |
SELECT `avid_specials`.* FROM `avid_specials`
LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1489695 and class = 'Special') OR (item_id = 77957 and class = 'Cruise') OR (item_id = 1402 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 8 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.0013229846954346 |
| (535) |
DESCRIBE `cruiselines` |
0.0029010772705078 |
| (536) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) |
0.00055599212646484 |
| (537) |
DESCRIBE `orchid_image` |
0.0020821094512939 |
| (538) |
DESCRIBE `cruiselines` |
0.0021288394927979 |
| (539) |
SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') |
0.00037097930908203 |
| (540) |
DESCRIBE `specials` |
0.0042579174041748 |
| (541) |
DESCRIBE `specials` |
0.005511999130249 |
| (542) |
SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1485102') |
0.00059199333190918 |
| (543) |
DESCRIBE `ships` |
0.0036311149597168 |
| (544) |
SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1672))) |
0.00047087669372559 |
| (545) |
DESCRIBE `ships` |
0.0031440258026123 |
| (546) |
SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1672') |
0.00040793418884277 |
| (547) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') |
0.00029492378234863 |
| (548) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') |
0.00030803680419922 |
| (549) |
DESCRIBE `itineraries` |
0.0016539096832275 |
| (550) |
DESCRIBE `ports` |
0.0017330646514893 |
| (551) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) |
0.00043892860412598 |
| (552) |
DESCRIBE `ports` |
0.0017271041870117 |
| (553) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) |
0.00047183036804199 |
| (554) |
DESCRIBE `ports` |
0.0018949508666992 |
| (555) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') |
0.00035691261291504 |
| (556) |
DESCRIBE `specialsailingdates` |
0.0013070106506348 |
| (557) |
DESCRIBE `sailingdates` |
0.0012660026550293 |
| (558) |
SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 476173))) |
0.00056982040405273 |
| (559) |
DESCRIBE `ports` |
0.0017011165618896 |
| (560) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) |
0.00048494338989258 |
| (561) |
DESCRIBE `ports` |
0.0016779899597168 |
| (562) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') |
0.00039315223693848 |
| (563) |
DESCRIBE `ports` |
0.0016701221466064 |
| (564) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) |
0.00050687789916992 |
| (565) |
DESCRIBE `ports` |
0.0017430782318115 |
| (566) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') |
0.00041294097900391 |
| (567) |
DESCRIBE `ports` |
0.0017290115356445 |
| (568) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1775))) |
0.00048995018005371 |
| (569) |
DESCRIBE `ports` |
0.0019440650939941 |
| (570) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1775') |
0.00050497055053711 |
| (571) |
DESCRIBE `ports` |
0.0019659996032715 |
| (572) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 733))) |
0.00051116943359375 |
| (573) |
DESCRIBE `ports` |
0.0019748210906982 |
| (574) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '733') |
0.00047087669372559 |
| (575) |
DESCRIBE `ports` |
0.0018720626831055 |
| (576) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) |
0.00050783157348633 |
| (577) |
DESCRIBE `ports` |
0.0016229152679443 |
| (578) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') |
0.00045204162597656 |
| (579) |
DESCRIBE `ports` |
0.0017189979553223 |
| (580) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) |
0.00057101249694824 |
| (581) |
DESCRIBE `ports` |
0.0018229484558105 |
| (582) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') |
0.00044417381286621 |
| (583) |
DESCRIBE `ports` |
0.0017869472503662 |
| (584) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) |
0.00046205520629883 |
| (585) |
DESCRIBE `ports` |
0.001762866973877 |
| (586) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') |
0.00042390823364258 |
| (587) |
DESCRIBE `ports` |
0.0015521049499512 |
| (588) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) |
0.00037384033203125 |
| (589) |
DESCRIBE `ports` |
0.0015268325805664 |
| (590) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') |
0.00035405158996582 |
| (591) |
DESCRIBE `ports` |
0.0017290115356445 |
| (592) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) |
0.00043582916259766 |
| (593) |
DESCRIBE `ports` |
0.0016300678253174 |
| (594) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') |
0.00036907196044922 |
| (595) |
DESCRIBE `cruises` |
0.0029158592224121 |
| (596) |
SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 75551))) |
0.0005488395690918 |
| (597) |
DESCRIBE `avid_specials` |
0.0015230178833008 |
| (598) |
SELECT `avid_specials`.* FROM `avid_specials`
LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1485102 and class = 'Special') OR (item_id = 75551 and class = 'Cruise') OR (item_id = 1672 AND class = 'Ship') OR (item_id = 151 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.00142502784729 |
| (599) |
DESCRIBE `cruiselines` |
0.0021119117736816 |
| (600) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) |
0.00050497055053711 |
| (601) |
DESCRIBE `orchid_image` |
0.0021679401397705 |
| (602) |
DESCRIBE `cruiselines` |
0.0031960010528564 |
| (603) |
SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') |
0.00036311149597168 |
| (604) |
DESCRIBE `cruiselines` |
0.0026190280914307 |
| (605) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('91', '151', '23', '29', '8', '15', '37', '187', '262', '4', '20', '26', '33', '218')) ORDER BY FIND_IN_SET(id, '91,151,23,29,8,15,37,187,262,4,20,26,33,218') |
0.0017640590667725 |
| (606) |
DESCRIBE `ships` |
0.0042340755462646 |
| (607) |
SELECT `ships`.* FROM `ships` WHERE (id IN ('451', '148', '394', '652', '683', '780', '1108', '1454', '1474', '1672', '4', '163', '223', '287', '485', '616', '669', '678', '1284', '1319', '1402')) ORDER BY FIND_IN_SET(id, '451,148,394,652,683,780,1108,1454,1474,1672,4,163,223,287,485,616,669,678,1284,1319,1402') |
0.0030748844146729 |
| (608) |
DESCRIBE `cruisetypes` |
0.0023500919342041 |
| (609) |
DESCRIBE `destinations` |
0.0024740695953369 |
| (610) |
SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '40', '22', '8', '2', '25', '26', '35', '53')) ORDER BY FIND_IN_SET(id, '43,40,22,8,2,25,26,35,53') |
0.0014169216156006 |
