| (1) |
connect |
0.00059294700622559 |
| (2) |
DESCRIBE `cruises` |
0.0017940998077393 |
| (3) |
SELECT `cruises`.* FROM `cruises` WHERE (orchid_slug = 'emmylou-overnight-cruise-ex-echuca-return') AND (orchid_available = 1) LIMIT 1 |
0.00056600570678711 |
| (4) |
DESCRIBE `avid_specials` |
0.000701904296875 |
| (5) |
SELECT `avid_specials`.* FROM `avid_specials`
LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 289 and class = 'Cruise') OR (item_id = 198 AND class = 'Ship') OR (item_id = 48 AND class = 'CruiseLine') OR (item_id = 46 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.00091719627380371 |
| (6) |
SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '289') |
0.00018692016601562 |
| (7) |
DESCRIBE `ships` |
0.0014338493347168 |
| (8) |
SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 198))) |
0.00026106834411621 |
| (9) |
DESCRIBE `ships` |
0.0012969970703125 |
| (10) |
SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '198') |
0.0001838207244873 |
| (11) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') |
0.00017809867858887 |
| (12) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') |
0.0001680850982666 |
| (13) |
DESCRIBE `itineraries` |
0.00067996978759766 |
| (14) |
DESCRIBE `ports` |
0.00071406364440918 |
| (15) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 257))) |
0.00024795532226562 |
| (16) |
DESCRIBE `ports` |
0.0006868839263916 |
| (17) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 257))) |
0.0001978874206543 |
| (18) |
DESCRIBE `ports` |
0.0006861686706543 |
| (19) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '257') |
0.00018000602722168 |
| (20) |
DESCRIBE `sailingdates` |
0.00062394142150879 |
| (21) |
DESCRIBE `ports` |
0.00073385238647461 |
| (22) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 257))) |
0.00023293495178223 |
| (23) |
DESCRIBE `ports` |
0.00068497657775879 |
| (24) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '257') |
0.00018095970153809 |
| (25) |
DESCRIBE `ports` |
0.0006859302520752 |
| (26) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 259))) |
0.0001988410949707 |
| (27) |
DESCRIBE `ports` |
0.00067901611328125 |
| (28) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '259') |
0.00017809867858887 |
| (29) |
DESCRIBE `ports` |
0.00067281723022461 |
| (30) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 257))) |
0.00019383430480957 |
| (31) |
DESCRIBE `ports` |
0.00070500373840332 |
| (32) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '257') |
0.00017404556274414 |
| (33) |
DESCRIBE `cruiselines` |
0.001007080078125 |
| (34) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 48))) |
0.0002131462097168 |
| (35) |
DESCRIBE `orchid_image` |
0.00076913833618164 |
| (36) |
DESCRIBE `cruiselines` |
0.00094485282897949 |
| (37) |
SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '48') |
0.00018095970153809 |
| (38) |
DESCRIBE `cabins` |
0.00069403648376465 |
| (39) |
DESCRIBE `deckplans` |
0.00065398216247559 |
| (40) |
DESCRIBE `shipphotos` |
0.00087285041809082 |
| (41) |
DESCRIBE `cruiselines` |
0.0018959045410156 |
| (42) |
DESCRIBE `cruisetypes` |
0.00085806846618652 |
| (43) |
DESCRIBE `destinations` |
0.0014431476593018 |
| (44) |
DESCRIBE `ships` |
0.0014340877532959 |
| (45) |
SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 211))) |
0.00032591819763184 |
| (46) |
DESCRIBE `ships` |
0.0018470287322998 |
| (47) |
SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 211))) |
0.00036191940307617 |
| (48) |
DESCRIBE `ports` |
0.00082516670227051 |
| (49) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 257))) |
0.00021886825561523 |