| (1) |
connect |
0.0011701583862305 |
| (2) |
DESCRIBE `ships` |
0.0044679641723633 |
| (3) |
SELECT `ships`.* FROM `ships` WHERE (orchid_slug = 'jasmine') LIMIT 1 |
0.015290975570679 |
| (4) |
DESCRIBE `avid_specials` |
0.0029170513153076 |
| (5) |
SELECT `avid_specials`.* FROM `avid_specials`
LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1554 AND class = 'Ship') OR (item_id = 183 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) |
0.0024349689483643 |
| (6) |
DESCRIBE `cruiselines` |
0.003972053527832 |
| (7) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183))) |
0.0006868839263916 |
| (8) |
DESCRIBE `orchid_image` |
0.0068900585174561 |
| (9) |
DESCRIBE `cruiselines` |
0.0028538703918457 |
| (10) |
SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '183') |
0.000518798828125 |
| (11) |
SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1554') |
0.00057077407836914 |
| (12) |
DESCRIBE `deckplans` |
0.0027170181274414 |
| (13) |
DESCRIBE `cabins` |
0.001964807510376 |
| (14) |
DESCRIBE `shipphotos` |
0.001784086227417 |
| (15) |
DESCRIBE `cruisetypes` |
0.0018658638000488 |
| (16) |
SELECT DISTINCT `cruisetypes`.* FROM `cruisetypes`
LEFT JOIN `cruises_and_specials` ON cruisetypes.id = cruises_and_specials.cruisetype_id WHERE (cruisetypes.id = cruises_and_specials.cruisetype_id) AND (cruises_and_specials.cruiseline_id = '206') AND (cruises_and_specials.ship_id = '1554') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC |
0.031427145004272 |
| (17) |
DESCRIBE `destinations` |
0.0036799907684326 |
| (18) |
SELECT DISTINCT `destinations`.* FROM `destinations`
LEFT JOIN `cruises_and_specials` ON destinations.id = cruises_and_specials.destination_id WHERE (destinations.id = cruises_and_specials.destination_id) AND (cruises_and_specials.cruiseline_id = '206') AND (cruises_and_specials.ship_id = '1554') AND (cruises_and_specials.orchid_available = 1) AND (destinations.orchid_available = 1) ORDER BY `destinations`.`name` ASC, `name` ASC |
0.046069860458374 |
| (19) |
DESCRIBE `cruiselines` |
0.0039670467376709 |
| (20) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 206))) |
0.0007479190826416 |
| (21) |
DESCRIBE `ships` |
0.0051219463348389 |
| (22) |
SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1554))) |
0.00060105323791504 |
| (23) |
DESCRIBE `cruiselines` |
0.0029540061950684 |
| (24) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 206))) |
0.00068902969360352 |
| (25) |
DESCRIBE `ships` |
0.0037992000579834 |
| (26) |
SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1554))) |
0.00052690505981445 |
