| (1) |
connect |
0.0010719299316406 |
| (2) |
DESCRIBE `ports` |
0.002424955368042 |
| (3) |
SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'lan-ha-bay-vietnam') AND (orchid_available = 1) LIMIT 1 |
0.037581920623779 |
| (4) |
DESCRIBE `destinations` |
0.0029468536376953 |
| (5) |
SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 35))) |
0.00065112113952637 |
| (6) |
DESCRIBE `avid_specials` |
0.0020389556884766 |
| (7) |
SELECT `avid_specials`.* FROM `avid_specials`
LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = '35' 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.0011758804321289 |
| (8) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4713') |
0.0005948543548584 |
| (9) |
SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '4713') |
0.0018291473388672 |
| (10) |
SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '4713') |
0.0017740726470947 |
| (11) |
DESCRIBE `cruises` |
0.0039529800415039 |
| (12) |
SELECT `cruises`.* FROM `cruises` WHERE (id IN (80327)) ORDER BY FIND_IN_SET(id, '80327') |
0.00065708160400391 |
| (13) |
DESCRIBE `cruisetypes` |
0.0015411376953125 |
| (14) |
DESCRIBE `destinations` |
0.0033040046691895 |
| (15) |
SELECT `destinations`.* FROM `destinations` WHERE (id IN ('35')) ORDER BY FIND_IN_SET(id, '35') |
0.00052404403686523 |
| (16) |
DESCRIBE `cruiselines` |
0.0024559497833252 |
| (17) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183))) |
0.00049686431884766 |
| (18) |
DESCRIBE `ships` |
0.0035898685455322 |
| (19) |
SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1761))) |
0.00044512748718262 |
| (20) |
DESCRIBE `cruiselines` |
0.0031061172485352 |
| (21) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183))) |
0.00056695938110352 |
| (22) |
DESCRIBE `ships` |
0.0056228637695312 |
| (23) |
SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1761))) |
0.00077080726623535 |
| (24) |
DESCRIBE `ports` |
0.0026769638061523 |
| (25) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4713))) |
0.00055503845214844 |
