| (1) |
connect |
0.0011978149414062 |
| (2) |
DESCRIBE `cruiselines` |
0.0037620067596436 |
| (3) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (orchid_slug = 'uniworld-boutique-river-cruise-collection') AND (orchid_available = 1) LIMIT 1 |
0.00098896026611328 |
| (4) |
DESCRIBE `avid_specials` |
0.0016601085662842 |
| (5) |
SELECT `avid_specials`.* FROM `avid_specials`
LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = '96' 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.0011260509490967 |
| (6) |
DESCRIBE `orchid_image` |
0.0020761489868164 |
| (7) |
SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '96') |
0.00043702125549316 |
| (8) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') |
0.00034999847412109 |
| (9) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') |
0.00039315223693848 |
| (10) |
DESCRIBE `cruisetypes` |
0.0019350051879883 |
| (11) |
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 = '96') AND (cruises_and_specials.ship_id = '30') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC |
0.030399084091187 |
| (12) |
DESCRIBE `destinations` |
0.0027458667755127 |
| (13) |
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 = '96') AND (cruises_and_specials.ship_id = '30') AND (ports.id = '271') AND (cruises_and_specials.orchid_available = 1) AND (destinations.orchid_available = 1) ORDER BY `destinations`.`name` ASC, `name` ASC |
0.031852960586548 |
| (14) |
DESCRIBE `cruiselines` |
0.0029408931732178 |
| (15) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 96))) |
0.00049209594726562 |
| (16) |
DESCRIBE `ships` |
0.0039827823638916 |
| (17) |
SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 30))) |
0.0006258487701416 |
| (18) |
DESCRIBE `cruiselines` |
0.0028810501098633 |
| (19) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 96))) |
0.00051116943359375 |
| (20) |
DESCRIBE `ships` |
0.0034770965576172 |
| (21) |
SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 30))) |
0.00062084197998047 |
| (22) |
DESCRIBE `ports` |
0.0018649101257324 |
| (23) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 271))) |
0.0004270076751709 |
