| (1) |
connect |
0.00082206726074219 |
| (2) |
DESCRIBE `ships` |
0.0039691925048828 |
| (3) |
SELECT `ships`.* FROM `ships` WHERE (orchid_slug = 'viking-sun') LIMIT 1 |
0.0095419883728027 |
| (4) |
DESCRIBE `avid_specials` |
0.0017650127410889 |
| (5) |
SELECT `avid_specials`.* FROM `avid_specials`
LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1474 AND class = 'Ship') OR (item_id = 262 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.0014920234680176 |
| (6) |
DESCRIBE `cruiselines` |
0.0027589797973633 |
| (7) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262))) |
0.00050806999206543 |
| (8) |
DESCRIBE `orchid_image` |
0.0019118785858154 |
| (9) |
DESCRIBE `cruiselines` |
0.0024750232696533 |
| (10) |
SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '262') |
0.00037503242492676 |
| (11) |
SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1474') |
0.00031900405883789 |
| (12) |
DESCRIBE `deckplans` |
0.0016629695892334 |
| (13) |
DESCRIBE `cabins` |
0.0014469623565674 |
| (14) |
DESCRIBE `shipphotos` |
0.0017361640930176 |
| (15) |
DESCRIBE `cruisetypes` |
0.0018229484558105 |
| (16) |
DESCRIBE `destinations` |
0.0026159286499023 |
| (17) |
SELECT DISTINCT `destinations`.* FROM `destinations`
LEFT JOIN `cruises_and_specials` ON destinations.id = cruises_and_specials.destination_id
LEFT JOIN `ports` ON ports.destination_id = destinations.id WHERE (destinations.id = cruises_and_specials.destination_id) AND (cruises_and_specials.cruiseline_id = '262') AND (cruises_and_specials.ship_id = '1474') AND (ports.id = '1709') AND (cruises_and_specials.orchid_available = 1) AND (destinations.orchid_available = 1) ORDER BY `destinations`.`name` ASC, `name` ASC |
0.035622835159302 |
| (18) |
DESCRIBE `cruiselines` |
0.0022099018096924 |
| (19) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262))) |
0.00034189224243164 |
| (20) |
DESCRIBE `ships` |
0.0032429695129395 |
| (21) |
SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1474))) |
0.00050806999206543 |
| (22) |
DESCRIBE `cruiselines` |
0.0025749206542969 |
| (23) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262))) |
0.0004119873046875 |
| (24) |
DESCRIBE `ships` |
0.0029089450836182 |
| (25) |
SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1474))) |
0.0005190372467041 |
| (26) |
DESCRIBE `ports` |
0.001838207244873 |
| (27) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1709))) |
0.0003659725189209 |
