| (1) |
connect |
0.001338005065918 |
| (2) |
DESCRIBE `cruiselines` |
0.0043618679046631 |
| (3) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (orchid_slug = 'delfin-amazon-cruises') AND (orchid_available = 1) LIMIT 1 |
0.0020089149475098 |
| (4) |
DESCRIBE `avid_specials` |
0.0029470920562744 |
| (5) |
SELECT `avid_specials`.* FROM `avid_specials`
LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = '195' 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.0023829936981201 |
| (6) |
DESCRIBE `orchid_image` |
0.00364089012146 |
| (7) |
SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '195') |
0.000885009765625 |
| (8) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') |
0.00055813789367676 |
| (9) |
SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') |
0.00053906440734863 |
| (10) |
DESCRIBE `cruises` |
0.0057621002197266 |
| (11) |
SELECT `cruises`.* FROM `cruises` WHERE (id IN (57671, 57662)) ORDER BY FIND_IN_SET(id, '57671,57662') |
0.0020229816436768 |
| (12) |
DESCRIBE `cruisetypes` |
0.003169059753418 |
| (13) |
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 = '195') AND (cruises_and_specials.ship_id = '858') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC |
0.04918098449707 |
| (14) |
DESCRIBE `destinations` |
0.0035560131072998 |
| (15) |
SELECT `destinations`.* FROM `destinations` WHERE (id IN ('55')) ORDER BY FIND_IN_SET(id, '55') |
0.00079107284545898 |
| (16) |
DESCRIBE `cruiselines` |
0.0044660568237305 |
| (17) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 195))) |
0.0007929801940918 |
| (18) |
DESCRIBE `ships` |
0.0062189102172852 |
| (19) |
SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 858))) |
0.00079703330993652 |
| (20) |
DESCRIBE `cruiselines` |
0.0044829845428467 |
| (21) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 195))) |
0.00078797340393066 |
| (22) |
DESCRIBE `ships` |
0.0056822299957275 |
| (23) |
SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 858))) |
0.00086092948913574 |
| (24) |
DESCRIBE `ports` |
0.0029308795928955 |
| (25) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3863))) |
0.00096702575683594 |
