| (1) |
connect |
0.0014159679412842 |
| (2) |
DESCRIBE `cruises` |
0.0055351257324219 |
| (3) |
SELECT `cruises`.* FROM `cruises` WHERE (id IN (74697, 57672, 48300, 40591, 47190, 75369, 11517, 52584, 67266, 67915)) ORDER BY FIND_IN_SET(id, '74697,57672,48300,40591,47190,75369,11517,52584,67266,67915') |
0.0033919811248779 |
| (4) |
DESCRIBE `specials` |
0.0069639682769775 |
| (5) |
DESCRIBE `specials` |
0.0056710243225098 |
| (6) |
SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1511652') |
0.00045084953308105 |
| (7) |
DESCRIBE `ships` |
0.0048460960388184 |
| (8) |
SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1163))) |
0.001291036605835 |
| (9) |
DESCRIBE `ships` |
0.0058128833770752 |
| (10) |
SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1163') |
0.00040292739868164 |
| (11) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') |
0.00027203559875488 |
| (12) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') |
0.00027894973754883 |
| (13) |
DESCRIBE `itineraries` |
0.0030951499938965 |
| (14) |
DESCRIBE `ports` |
0.0017328262329102 |
| (15) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) |
0.0011420249938965 |
| (16) |
DESCRIBE `ports` |
0.0016050338745117 |
| (17) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) |
0.0005791187286377 |
| (18) |
DESCRIBE `ports` |
0.0021798610687256 |
| (19) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4804') |
0.00046110153198242 |
| (20) |
DESCRIBE `specialsailingdates` |
0.0025069713592529 |
| (21) |
DESCRIBE `sailingdates` |
0.0023119449615479 |
| (22) |
SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 471642))) |
0.00066184997558594 |
| (23) |
DESCRIBE `ports` |
0.0016582012176514 |
| (24) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) |
0.00041007995605469 |
| (25) |
DESCRIBE `ports` |
0.0031828880310059 |
| (26) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4804') |
0.00031900405883789 |
| (27) |
DESCRIBE `ports` |
0.0040738582611084 |
| (28) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) |
0.00081586837768555 |
| (29) |
DESCRIBE `ports` |
0.0024590492248535 |
| (30) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4804') |
0.00050902366638184 |
| (31) |
DESCRIBE `ports` |
0.0025968551635742 |
| (32) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1229))) |
0.00047206878662109 |
| (33) |
DESCRIBE `ports` |
0.0048270225524902 |
| (34) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1229') |
0.0011799335479736 |
| (35) |
DESCRIBE `ports` |
0.0041179656982422 |
| (36) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) |
0.00036406517028809 |
| (37) |
DESCRIBE `ports` |
0.0041558742523193 |
| (38) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') |
0.00049400329589844 |
| (39) |
DESCRIBE `ports` |
0.0022380352020264 |
| (40) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3828))) |
0.00048208236694336 |
| (41) |
DESCRIBE `ports` |
0.0019280910491943 |
| (42) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3828') |
0.00042104721069336 |
| (43) |
DESCRIBE `ports` |
0.0021450519561768 |
| (44) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3828))) |
0.0012128353118896 |
| (45) |
DESCRIBE `ports` |
0.0026421546936035 |
| (46) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3828') |
0.00047111511230469 |
| (47) |
DESCRIBE `ports` |
0.0035469532012939 |
| (48) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3829))) |
0.00055789947509766 |
| (49) |
DESCRIBE `ports` |
0.0025382041931152 |
| (50) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3829') |
0.0004730224609375 |
| (51) |
DESCRIBE `ports` |
0.0054008960723877 |
| (52) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 279))) |
0.00079917907714844 |
| (53) |
DESCRIBE `ports` |
0.0023999214172363 |
| (54) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '279') |
0.00033998489379883 |
| (55) |
DESCRIBE `ports` |
0.0019080638885498 |
| (56) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4804))) |
0.0023789405822754 |
| (57) |
DESCRIBE `ports` |
0.0045750141143799 |
| (58) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4804') |
0.00046396255493164 |
| (59) |
DESCRIBE `cruises` |
0.0045120716094971 |
| (60) |
SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 74697))) |
0.00098896026611328 |
| (61) |
DESCRIBE `avid_specials` |
0.0041937828063965 |
| (62) |
SELECT `avid_specials`.* FROM `avid_specials`
LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1511652 and class = 'Special') OR (item_id = 74697 and class = 'Cruise') OR (item_id = 1163 AND class = 'Ship') OR (item_id = 212 AND class = 'CruiseLine') OR (item_id = 39 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) |
0.0016448497772217 |
| (63) |
DESCRIBE `cruiselines` |
0.002979040145874 |
| (64) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) |
0.00019598007202148 |
| (65) |
DESCRIBE `orchid_image` |
0.0022139549255371 |
| (66) |
DESCRIBE `cruiselines` |
0.0050599575042725 |
| (67) |
SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') |
0.00042295455932617 |
| (68) |
DESCRIBE `specials` |
0.006850004196167 |
| (69) |
DESCRIBE `specials` |
0.0069577693939209 |
| (70) |
SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1512776') |
0.0010080337524414 |
| (71) |
DESCRIBE `ships` |
0.0038509368896484 |
| (72) |
SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1205))) |
0 |
| (73) |
DESCRIBE `ships` |
0.0049281120300293 |
| (74) |
SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1205') |
0.00053787231445312 |
| (75) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') |
0.00040006637573242 |
| (76) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') |
0.00033712387084961 |
| (77) |
DESCRIBE `itineraries` |
0.002795934677124 |
| (78) |
DESCRIBE `ports` |
0.0023529529571533 |
| (79) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) |
0.00059986114501953 |
| (80) |
DESCRIBE `ports` |
0.002331018447876 |
| (81) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) |
0.00060009956359863 |
| (82) |
DESCRIBE `ports` |
0.0019640922546387 |
| (83) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') |
0.00030303001403809 |
| (84) |
DESCRIBE `specialsailingdates` |
0.0025100708007812 |
| (85) |
DESCRIBE `sailingdates` |
0.0019409656524658 |
| (86) |
SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 485016))) |
7.8678131103516E-6 |
| (87) |
DESCRIBE `ports` |
0.0021719932556152 |
| (88) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) |
0.00046801567077637 |
| (89) |
DESCRIBE `ports` |
0.0021259784698486 |
| (90) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') |
0.0003809928894043 |
| (91) |
DESCRIBE `ports` |
0.0021629333496094 |
| (92) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) |
0.0011451244354248 |
| (93) |
DESCRIBE `ports` |
0.0022180080413818 |
| (94) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') |
0.00043988227844238 |
| (95) |
DESCRIBE `ports` |
0.0016191005706787 |
| (96) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3671))) |
0.00056004524230957 |
| (97) |
DESCRIBE `ports` |
0.0019009113311768 |
| (98) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3671') |
0.0005180835723877 |
| (99) |
DESCRIBE `ports` |
0.0032839775085449 |
| (100) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2776))) |
0.0012669563293457 |
| (101) |
DESCRIBE `ports` |
0.0024268627166748 |
| (102) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2776') |
0.00051188468933105 |
| (103) |
DESCRIBE `ports` |
0.002514123916626 |
| (104) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) |
0.00077009201049805 |
| (105) |
DESCRIBE `ports` |
0.0035550594329834 |
| (106) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') |
0.00064301490783691 |
| (107) |
DESCRIBE `ports` |
0.0021870136260986 |
| (108) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) |
0.0004730224609375 |
| (109) |
DESCRIBE `ports` |
0.0024611949920654 |
| (110) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') |
0.00034594535827637 |
| (111) |
DESCRIBE `ports` |
0.0018961429595947 |
| (112) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) |
0.00043892860412598 |
| (113) |
DESCRIBE `ports` |
0.0018818378448486 |
| (114) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') |
0.00040698051452637 |
| (115) |
DESCRIBE `ports` |
0.0018250942230225 |
| (116) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5068))) |
0.00041794776916504 |
| (117) |
DESCRIBE `ports` |
0.0022168159484863 |
| (118) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5068') |
0.00041890144348145 |
| (119) |
DESCRIBE `ports` |
0.0023510456085205 |
| (120) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5645))) |
0.00056695938110352 |
| (121) |
DESCRIBE `ports` |
0.0024540424346924 |
| (122) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5645') |
0.0004279613494873 |
| (123) |
DESCRIBE `ports` |
0.0026140213012695 |
| (124) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2779))) |
0.00041604042053223 |
| (125) |
DESCRIBE `ports` |
0.002223014831543 |
| (126) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2779') |
0.00037598609924316 |
| (127) |
DESCRIBE `ports` |
0.0026340484619141 |
| (128) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) |
0.00043821334838867 |
| (129) |
DESCRIBE `ports` |
0.0019021034240723 |
| (130) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') |
0.00038790702819824 |
| (131) |
DESCRIBE `cruises` |
0.0033888816833496 |
| (132) |
SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 57672))) |
0.00043702125549316 |
| (133) |
DESCRIBE `avid_specials` |
0.001352071762085 |
| (134) |
SELECT `avid_specials`.* FROM `avid_specials`
LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1512776 and class = 'Special') OR (item_id = 57672 and class = 'Cruise') OR (item_id = 1205 AND class = 'Ship') OR (item_id = 191 AND class = 'CruiseLine') OR (item_id = 54 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.0011129379272461 |
| (135) |
DESCRIBE `cruiselines` |
0.0026769638061523 |
| (136) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 191))) |
0.00047016143798828 |
| (137) |
DESCRIBE `orchid_image` |
0.0026459693908691 |
| (138) |
DESCRIBE `cruiselines` |
0.0032680034637451 |
| (139) |
SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '191') |
0.00079798698425293 |
| (140) |
DESCRIBE `specials` |
0.0053949356079102 |
| (141) |
DESCRIBE `specials` |
0.0049760341644287 |
| (142) |
SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1512771') |
0.0011129379272461 |
| (143) |
DESCRIBE `ships` |
0.0042169094085693 |
| (144) |
SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1205))) |
0.00026798248291016 |
| (145) |
DESCRIBE `ships` |
0.0035650730133057 |
| (146) |
SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1205') |
8.7976455688477E-5 |
| (147) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') |
0 |
| (148) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') |
0.00092291831970215 |
| (149) |
DESCRIBE `itineraries` |
0.0017979145050049 |
| (150) |
DESCRIBE `ports` |
0.003046989440918 |
| (151) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) |
0.00047111511230469 |
| (152) |
DESCRIBE `ports` |
0.0017509460449219 |
| (153) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) |
0.0013320446014404 |
| (154) |
DESCRIBE `ports` |
0.0019059181213379 |
| (155) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') |
0.00061798095703125 |
| (156) |
DESCRIBE `specialsailingdates` |
0.001446008682251 |
| (157) |
DESCRIBE `sailingdates` |
0.0016610622406006 |
| (158) |
SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 485043))) |
0.00045394897460938 |
| (159) |
DESCRIBE `ports` |
0.0015900135040283 |
| (160) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) |
0.00034284591674805 |
| (161) |
DESCRIBE `ports` |
0.0015950202941895 |
| (162) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') |
0.00032711029052734 |
| (163) |
DESCRIBE `ports` |
0.0015690326690674 |
| (164) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) |
0.00037002563476562 |
| (165) |
DESCRIBE `ports` |
0.0018301010131836 |
| (166) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') |
0.00038290023803711 |
| (167) |
DESCRIBE `ports` |
0.0015511512756348 |
| (168) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3671))) |
0.00037884712219238 |
| (169) |
DESCRIBE `ports` |
0.0014529228210449 |
| (170) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3671') |
0.00029993057250977 |
| (171) |
DESCRIBE `ports` |
0.001446008682251 |
| (172) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2776))) |
0.00033092498779297 |
| (173) |
DESCRIBE `ports` |
0.0017669200897217 |
| (174) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2776') |
0.0003809928894043 |
| (175) |
DESCRIBE `ports` |
0.0015518665313721 |
| (176) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) |
0.00039911270141602 |
| (177) |
DESCRIBE `ports` |
0.0018408298492432 |
| (178) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') |
0.00043416023254395 |
| (179) |
DESCRIBE `ports` |
0.0019259452819824 |
| (180) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) |
0.00071287155151367 |
| (181) |
DESCRIBE `ports` |
0.0021770000457764 |
| (182) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') |
0.0012028217315674 |
| (183) |
DESCRIBE `ports` |
0.0016059875488281 |
| (184) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) |
0.00045680999755859 |
| (185) |
DESCRIBE `ports` |
0.0022590160369873 |
| (186) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') |
0.00043797492980957 |
| (187) |
DESCRIBE `cruises` |
0.0038430690765381 |
| (188) |
SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 48300))) |
0.00056099891662598 |
| (189) |
DESCRIBE `avid_specials` |
0.0018210411071777 |
| (190) |
SELECT `avid_specials`.* FROM `avid_specials`
LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1512771 and class = 'Special') OR (item_id = 48300 and class = 'Cruise') OR (item_id = 1205 AND class = 'Ship') OR (item_id = 191 AND class = 'CruiseLine') OR (item_id = 54 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.0014770030975342 |
| (191) |
DESCRIBE `cruiselines` |
0.0025010108947754 |
| (192) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 191))) |
0.0004429817199707 |
| (193) |
DESCRIBE `orchid_image` |
0.0020678043365479 |
| (194) |
DESCRIBE `cruiselines` |
0.0040500164031982 |
| (195) |
SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '191') |
0.0004730224609375 |
| (196) |
DESCRIBE `specials` |
0.005342960357666 |
| (197) |
DESCRIBE `specials` |
0.005361795425415 |
| (198) |
SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1512766') |
0.00050711631774902 |
| (199) |
DESCRIBE `ships` |
0.0037949085235596 |
| (200) |
SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1032))) |
0.00052285194396973 |
| (201) |
DESCRIBE `ships` |
0.0044939517974854 |
| (202) |
SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1032') |
0 |
| (203) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') |
0.0003819465637207 |
| (204) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') |
0 |
| (205) |
DESCRIBE `itineraries` |
0.0021660327911377 |
| (206) |
DESCRIBE `ports` |
0.0026040077209473 |
| (207) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) |
0.0003972053527832 |
| (208) |
DESCRIBE `ports` |
0.0023260116577148 |
| (209) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) |
0 |
| (210) |
DESCRIBE `ports` |
0.0018219947814941 |
| (211) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') |
8.702278137207E-5 |
| (212) |
DESCRIBE `specialsailingdates` |
0.0014858245849609 |
| (213) |
DESCRIBE `sailingdates` |
0.0015640258789062 |
| (214) |
SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 485428))) |
0.00076103210449219 |
| (215) |
DESCRIBE `ports` |
0.0020430088043213 |
| (216) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) |
0.00048995018005371 |
| (217) |
DESCRIBE `ports` |
0.0017669200897217 |
| (218) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') |
0.0003509521484375 |
| (219) |
DESCRIBE `ports` |
0.0023550987243652 |
| (220) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) |
0.00061511993408203 |
| (221) |
DESCRIBE `ports` |
0.0016789436340332 |
| (222) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') |
0.00044608116149902 |
| (223) |
DESCRIBE `ports` |
0.0024940967559814 |
| (224) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) |
0.00045299530029297 |
| (225) |
DESCRIBE `ports` |
0.0019130706787109 |
| (226) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') |
0.00042104721069336 |
| (227) |
DESCRIBE `ports` |
0.0019760131835938 |
| (228) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) |
0.00053882598876953 |
| (229) |
DESCRIBE `ports` |
0.0021049976348877 |
| (230) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') |
0.00043392181396484 |
| (231) |
DESCRIBE `cruises` |
0.0035209655761719 |
| (232) |
SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 40591))) |
0.00050997734069824 |
| (233) |
DESCRIBE `avid_specials` |
0.0018069744110107 |
| (234) |
SELECT `avid_specials`.* FROM `avid_specials`
LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1512766 and class = 'Special') OR (item_id = 40591 and class = 'Cruise') OR (item_id = 1032 AND class = 'Ship') OR (item_id = 191 AND class = 'CruiseLine') OR (item_id = 55 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.0014629364013672 |
| (235) |
DESCRIBE `cruiselines` |
0.0042951107025146 |
| (236) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 191))) |
0.00062203407287598 |
| (237) |
DESCRIBE `orchid_image` |
0.0033140182495117 |
| (238) |
DESCRIBE `cruiselines` |
0.0027329921722412 |
| (239) |
SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '191') |
0.00046181678771973 |
| (240) |
DESCRIBE `specials` |
0.0066900253295898 |
| (241) |
DESCRIBE `specials` |
0.0051980018615723 |
| (242) |
SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1511987') |
0.00059700012207031 |
| (243) |
DESCRIBE `ships` |
0.0040171146392822 |
| (244) |
SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 333))) |
0.00079488754272461 |
| (245) |
DESCRIBE `ships` |
0.0044560432434082 |
| (246) |
SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '333') |
0.00057506561279297 |
| (247) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') |
0.00034594535827637 |
| (248) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') |
0.0003359317779541 |
| (249) |
DESCRIBE `itineraries` |
0.0040700435638428 |
| (250) |
DESCRIBE `ports` |
0.0021469593048096 |
| (251) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) |
0.00049018859863281 |
| (252) |
DESCRIBE `ports` |
0.0018970966339111 |
| (253) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) |
0.00054001808166504 |
| (254) |
DESCRIBE `ports` |
0.0020010471343994 |
| (255) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') |
0.00045013427734375 |
| (256) |
DESCRIBE `specialsailingdates` |
0.0019059181213379 |
| (257) |
DESCRIBE `sailingdates` |
0.0019888877868652 |
| (258) |
SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423912))) |
0.00063586235046387 |
| (259) |
DESCRIBE `ports` |
0.0021510124206543 |
| (260) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) |
0.00049495697021484 |
| (261) |
DESCRIBE `ports` |
0.0020501613616943 |
| (262) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') |
0.00045299530029297 |
| (263) |
DESCRIBE `ports` |
0.0020182132720947 |
| (264) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 296))) |
0.00039887428283691 |
| (265) |
DESCRIBE `ports` |
0.0019690990447998 |
| (266) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '296') |
0.00034904479980469 |
| (267) |
DESCRIBE `ports` |
0.0019948482513428 |
| (268) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 412))) |
0.00036311149597168 |
| (269) |
DESCRIBE `ports` |
0.0017518997192383 |
| (270) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '412') |
0.00032401084899902 |
| (271) |
DESCRIBE `ports` |
0.0025949478149414 |
| (272) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) |
0.00041913986206055 |
| (273) |
DESCRIBE `ports` |
0.0019450187683105 |
| (274) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') |
0.00049781799316406 |
| (275) |
DESCRIBE `ports` |
0.0014569759368896 |
| (276) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1727))) |
0.00023889541625977 |
| (277) |
DESCRIBE `ports` |
0.0019149780273438 |
| (278) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1727') |
0.00060486793518066 |
| (279) |
DESCRIBE `ports` |
0.0025839805603027 |
| (280) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) |
0.00047183036804199 |
| (281) |
DESCRIBE `ports` |
0.002863883972168 |
| (282) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') |
0.00038409233093262 |
| (283) |
DESCRIBE `cruises` |
0.0045249462127686 |
| (284) |
SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 47190))) |
0.00083112716674805 |
| (285) |
DESCRIBE `avid_specials` |
0.017944812774658 |
| (286) |
SELECT `avid_specials`.* FROM `avid_specials`
LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1511987 and class = 'Special') OR (item_id = 47190 and class = 'Cruise') OR (item_id = 333 AND class = 'Ship') OR (item_id = 218 AND class = 'CruiseLine') OR (item_id = 12 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.0018980503082275 |
| (287) |
DESCRIBE `cruiselines` |
0.0023829936981201 |
| (288) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) |
0.00047111511230469 |
| (289) |
DESCRIBE `orchid_image` |
0.0023279190063477 |
| (290) |
DESCRIBE `cruiselines` |
0.0027790069580078 |
| (291) |
SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') |
0.00044894218444824 |
| (292) |
DESCRIBE `specials` |
0.0050818920135498 |
| (293) |
DESCRIBE `specials` |
0.0050160884857178 |
| (294) |
SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1512244') |
0.00042605400085449 |
| (295) |
DESCRIBE `ships` |
0.0031349658966064 |
| (296) |
SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1320))) |
0.00054693222045898 |
| (297) |
DESCRIBE `ships` |
0.0035879611968994 |
| (298) |
SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1320') |
0.00040507316589355 |
| (299) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') |
0.00027084350585938 |
| (300) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') |
0.00031113624572754 |
| (301) |
DESCRIBE `itineraries` |
0.0015320777893066 |
| (302) |
DESCRIBE `ports` |
0.0016658306121826 |
| (303) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) |
0.0003819465637207 |
| (304) |
DESCRIBE `ports` |
0.0019397735595703 |
| (305) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) |
0.00040602684020996 |
| (306) |
DESCRIBE `ports` |
0.0023000240325928 |
| (307) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') |
0.00039386749267578 |
| (308) |
DESCRIBE `specialsailingdates` |
0.0014588832855225 |
| (309) |
DESCRIBE `sailingdates` |
0.0014879703521729 |
| (310) |
SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 475646))) |
0.00094103813171387 |
| (311) |
DESCRIBE `ports` |
0.0018479824066162 |
| (312) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) |
0.00043392181396484 |
| (313) |
DESCRIBE `ports` |
0.0018041133880615 |
| (314) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') |
0.0003819465637207 |
| (315) |
DESCRIBE `ports` |
0.0014328956604004 |
| (316) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) |
0.00039410591125488 |
| (317) |
DESCRIBE `ports` |
0.0018231868743896 |
| (318) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') |
0.00036501884460449 |
| (319) |
DESCRIBE `ports` |
0.0018570423126221 |
| (320) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2283))) |
0.00040602684020996 |
| (321) |
DESCRIBE `ports` |
0.0017750263214111 |
| (322) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2283') |
0.00037002563476562 |
| (323) |
DESCRIBE `ports` |
0.0017950534820557 |
| (324) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) |
0.00041294097900391 |
| (325) |
DESCRIBE `ports` |
0.0017099380493164 |
| (326) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') |
0.00029683113098145 |
| (327) |
DESCRIBE `ports` |
0.0014979839324951 |
| (328) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) |
0.00033688545227051 |
| (329) |
DESCRIBE `ports` |
0.0016930103302002 |
| (330) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') |
0.00030088424682617 |
| (331) |
DESCRIBE `ports` |
0.002094030380249 |
| (332) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) |
0.00040602684020996 |
| (333) |
DESCRIBE `ports` |
0.001539945602417 |
| (334) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') |
0.00051784515380859 |
| (335) |
DESCRIBE `cruises` |
0.0036461353302002 |
| (336) |
SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 75369))) |
0.00068807601928711 |
| (337) |
DESCRIBE `avid_specials` |
0.0017199516296387 |
| (338) |
SELECT `avid_specials`.* FROM `avid_specials`
LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1512244 and class = 'Special') OR (item_id = 75369 and class = 'Cruise') OR (item_id = 1320 AND class = 'Ship') OR (item_id = 218 AND class = 'CruiseLine') OR (item_id = 12 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.0016970634460449 |
| (339) |
DESCRIBE `cruiselines` |
0.0030679702758789 |
| (340) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) |
0.00050616264343262 |
| (341) |
DESCRIBE `orchid_image` |
0.002155065536499 |
| (342) |
DESCRIBE `cruiselines` |
0.0033421516418457 |
| (343) |
SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') |
0.00078988075256348 |
| (344) |
DESCRIBE `specials` |
0.0091331005096436 |
| (345) |
DESCRIBE `specials` |
0.0050020217895508 |
| (346) |
SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1512752') |
0.001079797744751 |
| (347) |
DESCRIBE `ships` |
0.0059499740600586 |
| (348) |
SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 521))) |
0.00070595741271973 |
| (349) |
DESCRIBE `ships` |
0.003911018371582 |
| (350) |
SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '521') |
0.0004420280456543 |
| (351) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') |
0.00035309791564941 |
| (352) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') |
0.00034904479980469 |
| (353) |
DESCRIBE `itineraries` |
0.0025579929351807 |
| (354) |
DESCRIBE `ports` |
0.0020229816436768 |
| (355) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) |
0.00062394142150879 |
| (356) |
DESCRIBE `ports` |
0.0019412040710449 |
| (357) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) |
7.7009201049805E-5 |
| (358) |
DESCRIBE `ports` |
0.0017328262329102 |
| (359) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2778') |
0.00019288063049316 |
| (360) |
DESCRIBE `specialsailingdates` |
0.0016670227050781 |
| (361) |
DESCRIBE `sailingdates` |
0.0015549659729004 |
| (362) |
SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423040))) |
0.00059795379638672 |
| (363) |
DESCRIBE `ports` |
0.002532958984375 |
| (364) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) |
0 |
| (365) |
DESCRIBE `ports` |
0.0032308101654053 |
| (366) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2778') |
0.0004119873046875 |
| (367) |
DESCRIBE `ports` |
0.0021779537200928 |
| (368) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3490))) |
0.0011239051818848 |
| (369) |
DESCRIBE `ports` |
0.0021600723266602 |
| (370) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3490') |
0.00041985511779785 |
| (371) |
DESCRIBE `ports` |
0.015257120132446 |
| (372) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5160))) |
0.00057792663574219 |
| (373) |
DESCRIBE `ports` |
0.0034699440002441 |
| (374) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5160') |
0.00049495697021484 |
| (375) |
DESCRIBE `ports` |
0.0021200180053711 |
| (376) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) |
0.0005180835723877 |
| (377) |
DESCRIBE `ports` |
0.0016269683837891 |
| (378) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') |
7.2002410888672E-5 |
| (379) |
DESCRIBE `ports` |
0.0031440258026123 |
| (380) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4095))) |
0.0010099411010742 |
| (381) |
DESCRIBE `ports` |
0.001943826675415 |
| (382) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4095') |
0.00045108795166016 |
| (383) |
DESCRIBE `ports` |
0.0018100738525391 |
| (384) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) |
0.0004429817199707 |
| (385) |
DESCRIBE `ports` |
0.0019919872283936 |
| (386) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') |
0.00043010711669922 |
| (387) |
DESCRIBE `ports` |
0.0019381046295166 |
| (388) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2776))) |
0.00040411949157715 |
| (389) |
DESCRIBE `ports` |
0.0016541481018066 |
| (390) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2776') |
0.00029492378234863 |
| (391) |
DESCRIBE `ports` |
0.001823902130127 |
| (392) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3671))) |
0.00050806999206543 |
| (393) |
DESCRIBE `ports` |
0.0018999576568604 |
| (394) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3671') |
0.00040483474731445 |
| (395) |
DESCRIBE `ports` |
0.0020358562469482 |
| (396) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2775))) |
0.00046586990356445 |
| (397) |
DESCRIBE `ports` |
0.0019018650054932 |
| (398) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2775') |
0.00040006637573242 |
| (399) |
DESCRIBE `ports` |
0.0016219615936279 |
| (400) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) |
0.00042104721069336 |
| (401) |
DESCRIBE `ports` |
0.0018999576568604 |
| (402) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') |
0.0003211498260498 |
| (403) |
DESCRIBE `cruises` |
0.0033190250396729 |
| (404) |
SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 11517))) |
0.00062108039855957 |
| (405) |
DESCRIBE `avid_specials` |
0.001802921295166 |
| (406) |
SELECT `avid_specials`.* FROM `avid_specials`
LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1512752 and class = 'Special') OR (item_id = 11517 and class = 'Cruise') OR (item_id = 521 AND class = 'Ship') OR (item_id = 120 AND class = 'CruiseLine') OR (item_id = 54 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.0016689300537109 |
| (407) |
DESCRIBE `cruiselines` |
0.0026450157165527 |
| (408) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) |
0.0004889965057373 |
| (409) |
DESCRIBE `orchid_image` |
0.0021109580993652 |
| (410) |
DESCRIBE `cruiselines` |
0.003093957901001 |
| (411) |
SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') |
0.00057697296142578 |
| (412) |
DESCRIBE `specials` |
0.0056929588317871 |
| (413) |
DESCRIBE `specials` |
0.005396842956543 |
| (414) |
SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1512003') |
0.00052499771118164 |
| (415) |
DESCRIBE `ships` |
0.0039598941802979 |
| (416) |
SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 582))) |
0.0006110668182373 |
| (417) |
DESCRIBE `ships` |
0.003911018371582 |
| (418) |
SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '582') |
0.00062203407287598 |
| (419) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') |
0.00061488151550293 |
| (420) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') |
0.00042986869812012 |
| (421) |
DESCRIBE `itineraries` |
0.0020081996917725 |
| (422) |
DESCRIBE `ports` |
0.0020968914031982 |
| (423) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) |
0.00044488906860352 |
| (424) |
DESCRIBE `ports` |
0.0018289089202881 |
| (425) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) |
0.00043487548828125 |
| (426) |
DESCRIBE `ports` |
0.0018680095672607 |
| (427) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') |
0 |
| (428) |
DESCRIBE `specialsailingdates` |
0.0015120506286621 |
| (429) |
DESCRIBE `sailingdates` |
0.0013349056243896 |
| (430) |
SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 424907))) |
0.00032520294189453 |
| (431) |
DESCRIBE `ports` |
0.0015799999237061 |
| (432) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) |
0.0003509521484375 |
| (433) |
DESCRIBE `ports` |
0.0022652149200439 |
| (434) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') |
0.00020098686218262 |
| (435) |
DESCRIBE `ports` |
0.0019547939300537 |
| (436) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) |
0 |
| (437) |
DESCRIBE `ports` |
0.001384973526001 |
| (438) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') |
0.00033783912658691 |
| (439) |
DESCRIBE `ports` |
0.0019419193267822 |
| (440) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 327))) |
0.00043201446533203 |
| (441) |
DESCRIBE `ports` |
0.0026729106903076 |
| (442) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '327') |
0.00055193901062012 |
| (443) |
DESCRIBE `ports` |
0.0012011528015137 |
| (444) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) |
0.00063204765319824 |
| (445) |
DESCRIBE `ports` |
0.0017249584197998 |
| (446) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') |
0.00085282325744629 |
| (447) |
DESCRIBE `ports` |
0.0016269683837891 |
| (448) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) |
0.00033402442932129 |
| (449) |
DESCRIBE `ports` |
0.0014379024505615 |
| (450) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') |
0.00030779838562012 |
| (451) |
DESCRIBE `cruises` |
0.0029659271240234 |
| (452) |
SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 52584))) |
0.00049304962158203 |
| (453) |
DESCRIBE `avid_specials` |
0.0014140605926514 |
| (454) |
SELECT `avid_specials`.* FROM `avid_specials`
LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1512003 and class = 'Special') OR (item_id = 52584 and class = 'Cruise') OR (item_id = 582 AND class = 'Ship') OR (item_id = 218 AND class = 'CruiseLine') OR (item_id = 12 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.0015718936920166 |
| (455) |
DESCRIBE `cruiselines` |
0.0027689933776855 |
| (456) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) |
0.0010719299316406 |
| (457) |
DESCRIBE `orchid_image` |
0.0012669563293457 |
| (458) |
DESCRIBE `cruiselines` |
0.0028829574584961 |
| (459) |
SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') |
2.1934509277344E-5 |
| (460) |
DESCRIBE `specials` |
0.0039849281311035 |
| (461) |
DESCRIBE `specials` |
0.0041108131408691 |
| (462) |
SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1512019') |
0.00048398971557617 |
| (463) |
DESCRIBE `ships` |
0.0032641887664795 |
| (464) |
SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 970))) |
0.00094008445739746 |
| (465) |
DESCRIBE `ships` |
0.0049018859863281 |
| (466) |
SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '970') |
0.00050115585327148 |
| (467) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') |
0.0004429817199707 |
| (468) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') |
0.00038695335388184 |
| (469) |
DESCRIBE `itineraries` |
0.0017640590667725 |
| (470) |
DESCRIBE `ports` |
0.0017521381378174 |
| (471) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) |
0.0004270076751709 |
| (472) |
DESCRIBE `ports` |
0.0015439987182617 |
| (473) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) |
0.00044393539428711 |
| (474) |
DESCRIBE `ports` |
0.0015549659729004 |
| (475) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') |
0.00030398368835449 |
| (476) |
DESCRIBE `specialsailingdates` |
0.0013689994812012 |
| (477) |
DESCRIBE `sailingdates` |
0.0015699863433838 |
| (478) |
SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423693))) |
0 |
| (479) |
DESCRIBE `sailingdates` |
0.0014059543609619 |
| (480) |
SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423694))) |
0.00031280517578125 |
| (481) |
DESCRIBE `ports` |
0.0017240047454834 |
| (482) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) |
0 |
| (483) |
DESCRIBE `ports` |
0.0014858245849609 |
| (484) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') |
0.00040698051452637 |
| (485) |
DESCRIBE `ports` |
0.0019030570983887 |
| (486) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4894))) |
0.00054097175598145 |
| (487) |
DESCRIBE `ports` |
0.0012199878692627 |
| (488) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4894') |
0.00045013427734375 |
| (489) |
DESCRIBE `ports` |
0.0015649795532227 |
| (490) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) |
0.00035810470581055 |
| (491) |
DESCRIBE `ports` |
0.0015871524810791 |
| (492) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') |
0 |
| (493) |
DESCRIBE `ports` |
0.00098896026611328 |
| (494) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) |
0.0004279613494873 |
| (495) |
DESCRIBE `ports` |
0.00084185600280762 |
| (496) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') |
0.00032687187194824 |
| (497) |
DESCRIBE `ports` |
0.0019569396972656 |
| (498) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1727))) |
0.00043296813964844 |
| (499) |
DESCRIBE `ports` |
0.0015130043029785 |
| (500) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1727') |
0 |
| (501) |
DESCRIBE `ports` |
0.0020649433135986 |
| (502) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) |
0.00079202651977539 |
| (503) |
DESCRIBE `ports` |
0.002140998840332 |
| (504) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') |
0 |
| (505) |
DESCRIBE `cruises` |
0.0038838386535645 |
| (506) |
SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 67266))) |
0.00066208839416504 |
| (507) |
DESCRIBE `avid_specials` |
0.0017921924591064 |
| (508) |
SELECT `avid_specials`.* FROM `avid_specials`
LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1512019 and class = 'Special') OR (item_id = 67266 and class = 'Cruise') OR (item_id = 970 AND class = 'Ship') OR (item_id = 218 AND class = 'CruiseLine') OR (item_id = 12 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.0023190975189209 |
| (509) |
DESCRIBE `cruiselines` |
0.0025229454040527 |
| (510) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) |
0.00043296813964844 |
| (511) |
DESCRIBE `orchid_image` |
0.0015740394592285 |
| (512) |
DESCRIBE `cruiselines` |
0.0022139549255371 |
| (513) |
SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') |
0.00049614906311035 |
| (514) |
DESCRIBE `specials` |
0.0041718482971191 |
| (515) |
DESCRIBE `specials` |
0.005277156829834 |
| (516) |
SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1511854') |
0.0006110668182373 |
| (517) |
DESCRIBE `ships` |
0.0040509700775146 |
| (518) |
SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 669))) |
0.00062394142150879 |
| (519) |
DESCRIBE `ships` |
0.0037331581115723 |
| (520) |
SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '669') |
0.0003819465637207 |
| (521) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') |
0.00027298927307129 |
| (522) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') |
0.00030612945556641 |
| (523) |
DESCRIBE `itineraries` |
0.0015749931335449 |
| (524) |
DESCRIBE `ports` |
0.0013980865478516 |
| (525) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) |
0.00034594535827637 |
| (526) |
DESCRIBE `ports` |
0.0013778209686279 |
| (527) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) |
0.00030207633972168 |
| (528) |
DESCRIBE `ports` |
0.001309871673584 |
| (529) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') |
0.00029110908508301 |
| (530) |
DESCRIBE `specialsailingdates` |
0.0012211799621582 |
| (531) |
DESCRIBE `sailingdates` |
0.0012009143829346 |
| (532) |
SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 428520))) |
0.00037693977355957 |
| (533) |
DESCRIBE `sailingdates` |
0.0012998580932617 |
| (534) |
SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 428521))) |
0.00028896331787109 |
| (535) |
DESCRIBE `ports` |
0.0014438629150391 |
| (536) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) |
0.00031805038452148 |
| (537) |
DESCRIBE `ports` |
0.0014309883117676 |
| (538) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') |
0.00028896331787109 |
| (539) |
DESCRIBE `ports` |
0.0018970966339111 |
| (540) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) |
0.00038814544677734 |
| (541) |
DESCRIBE `ports` |
0.0015881061553955 |
| (542) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') |
0.00029683113098145 |
| (543) |
DESCRIBE `ports` |
0.0015819072723389 |
| (544) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2148))) |
0.00036096572875977 |
| (545) |
DESCRIBE `ports` |
0.0014269351959229 |
| (546) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2148') |
0.0003509521484375 |
| (547) |
DESCRIBE `ports` |
0.0018100738525391 |
| (548) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 166))) |
0.00038695335388184 |
| (549) |
DESCRIBE `ports` |
0.0015599727630615 |
| (550) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '166') |
0.00036883354187012 |
| (551) |
DESCRIBE `ports` |
0.0014419555664062 |
| (552) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) |
0.00033688545227051 |
| (553) |
DESCRIBE `ports` |
0.001500129699707 |
| (554) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') |
0.0003209114074707 |
| (555) |
DESCRIBE `cruises` |
0.0028140544891357 |
| (556) |
SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 67915))) |
0.00052595138549805 |
| (557) |
DESCRIBE `avid_specials` |
0.0015690326690674 |
| (558) |
SELECT `avid_specials`.* FROM `avid_specials`
LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1511854 and class = 'Special') OR (item_id = 67915 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.0017569065093994 |
| (559) |
DESCRIBE `cruiselines` |
0.0027880668640137 |
| (560) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) |
0.00049996376037598 |
| (561) |
DESCRIBE `orchid_image` |
0.0025060176849365 |
| (562) |
DESCRIBE `cruiselines` |
0.0026748180389404 |
| (563) |
SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') |
0.0003969669342041 |
| (564) |
DESCRIBE `cruiselines` |
0.0030767917633057 |
| (565) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '191', '23', '101', '120', '4', '212')) ORDER BY FIND_IN_SET(id, '218,191,23,101,120,4,212') |
0.00081205368041992 |
| (566) |
DESCRIBE `ships` |
0.0031969547271729 |
| (567) |
SELECT `ships`.* FROM `ships` WHERE (id IN ('1205', '441', '390', '1032', '1303', '10', '451', '582', '669', '1237', '3', '9', '11', '21', '27', '333', '439', '521', '854', '970', '1320', '1579', '4', '22', '24', '25', '28', '105', '327', '461', '739', '1163', '1224', '1773')) ORDER BY FIND_IN_SET(id, '1205,441,390,1032,1303,10,451,582,669,1237,3,9,11,21,27,333,439,521,854,970,1320,1579,4,22,24,25,28,105,327,461,739,1163,1224,1773') |
0.0041489601135254 |
| (568) |
DESCRIBE `cruisetypes` |
0.0019280910491943 |
| (569) |
DESCRIBE `destinations` |
0.0012800693511963 |
| (570) |
SELECT `destinations`.* FROM `destinations` WHERE (id IN ('12', '54', '48', '29', '9', '53', '40', '55', '8', '39', '50')) ORDER BY FIND_IN_SET(id, '12,54,48,29,9,53,40,55,8,39,50') |
0.0013189315795898 |
