| (1) |
connect |
0.0019330978393555 |
| (2) |
DESCRIBE `ports` |
0.0034859180450439 |
| (3) |
SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'chateauneuf-du-rhone-france') AND (orchid_available = 1) LIMIT 1 |
0.05974292755127 |
| (4) |
DESCRIBE `destinations` |
0.0034480094909668 |
| (5) |
SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 50))) |
0.0010840892791748 |
| (6) |
DESCRIBE `avid_specials` |
0.0026209354400635 |
| (7) |
SELECT `avid_specials`.* FROM `avid_specials`
LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = '50' 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.0015640258789062 |
| (8) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5733') |
0.00059008598327637 |
| (9) |
SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '5733') |
0.0035758018493652 |
| (10) |
SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '5733') |
0.0037031173706055 |
| (11) |
DESCRIBE `cruises` |
0.0058689117431641 |
| (12) |
SELECT `cruises`.* FROM `cruises` WHERE (id IN (63940, 63940)) ORDER BY FIND_IN_SET(id, '63940,63940') |
0.0017170906066895 |
| (13) |
DESCRIBE `cruiselines` |
0.0041999816894531 |
| (14) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('140')) ORDER BY FIND_IN_SET(id, '140') |
0.00093603134155273 |
| (15) |
DESCRIBE `ships` |
0.0061869621276855 |
| (16) |
SELECT `ships`.* FROM `ships` WHERE (id IN ('1491')) ORDER BY FIND_IN_SET(id, '1491') |
0.00094199180603027 |
| (17) |
DESCRIBE `cruisetypes` |
0.0023319721221924 |
| (18) |
DESCRIBE `destinations` |
0.0037169456481934 |
| (19) |
SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50')) ORDER BY FIND_IN_SET(id, '50') |
0.00080108642578125 |
| (20) |
DESCRIBE `ports` |
0.0030438899993896 |
| (21) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5733))) |
0.0006859302520752 |
