| (1) |
connect |
0.00078797340393066 |
| (2) |
DESCRIBE `ports` |
0.0017979145050049 |
| (3) |
SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'equator-crossing') AND (orchid_available = 1) LIMIT 1 |
0.018971920013428 |
| (4) |
DESCRIBE `destinations` |
0.0023319721221924 |
| (5) |
SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 40))) |
0.00042605400085449 |
| (6) |
DESCRIBE `avid_specials` |
0.0011742115020752 |
| (7) |
SELECT `avid_specials`.* FROM `avid_specials`
LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = '40' 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.0011558532714844 |
| (8) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3606') |
0.00028181076049805 |
| (9) |
SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '3606') |
0.0016231536865234 |
| (10) |
SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '3606') |
0.0024161338806152 |
| (11) |
DESCRIBE `cruises` |
0.0038280487060547 |
| (12) |
SELECT `cruises`.* FROM `cruises` WHERE (id IN (73585, 73586, 76686, 76689, 76206, 78225, 78229, 78351, 76568, 76569)) ORDER BY FIND_IN_SET(id, '73585,73586,76686,76689,76206,78225,78229,78351,76568,76569') |
0.0018949508666992 |
| (13) |
DESCRIBE `cruiselines` |
0.0023260116577148 |
| (14) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('18', '28', '114')) ORDER BY FIND_IN_SET(id, '18,28,114') |
0.00068092346191406 |
| (15) |
DESCRIBE `ships` |
0.0027611255645752 |
| (16) |
SELECT `ships`.* FROM `ships` WHERE (id IN ('884', '75', '340', '547', '1302', '78', '84', '74', '82', '796')) ORDER BY FIND_IN_SET(id, '884,75,340,547,1302,78,84,74,82,796') |
0.00091004371643066 |
| (17) |
DESCRIBE `cruisetypes` |
0.0013420581817627 |
| (18) |
DESCRIBE `destinations` |
0.0017139911651611 |
| (19) |
SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '37', '29', '35', '38', '48', '52')) ORDER BY FIND_IN_SET(id, '43,37,29,35,38,48,52') |
0.00092983245849609 |
| (20) |
DESCRIBE `ports` |
0.0015699863433838 |
| (21) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3606))) |
0.00038409233093262 |
