| (1) |
connect |
0.0090839862823486 |
| (2) |
DESCRIBE `ports` |
0.0015339851379395 |
| (3) |
SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'chateauneuf-du-rhone-france') AND (orchid_available = 1) LIMIT 1 |
0.037030935287476 |
| (4) |
DESCRIBE `destinations` |
0.0020568370819092 |
| (5) |
SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 50))) |
0.00047206878662109 |
| (6) |
DESCRIBE `avid_specials` |
0.0017890930175781 |
| (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.001392126083374 |
| (8) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5733') |
0.00028109550476074 |
| (9) |
SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '5733') |
0.0015912055969238 |
| (10) |
SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '5733') |
0.0015559196472168 |
| (11) |
DESCRIBE `cruises` |
0.0037040710449219 |
| (12) |
SELECT `cruises`.* FROM `cruises` WHERE (id IN (63940)) ORDER BY FIND_IN_SET(id, '63940') |
0.00061702728271484 |
| (13) |
DESCRIBE `cruiselines` |
0.002748966217041 |
| (14) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('140')) ORDER BY FIND_IN_SET(id, '140') |
0.00048494338989258 |
| (15) |
DESCRIBE `ships` |
0.0030839443206787 |
| (16) |
SELECT `ships`.* FROM `ships` WHERE (id IN ('1491')) ORDER BY FIND_IN_SET(id, '1491') |
0.00044703483581543 |
| (17) |
DESCRIBE `cruisetypes` |
0.0011088848114014 |
| (18) |
DESCRIBE `destinations` |
0.0017919540405273 |
| (19) |
SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50')) ORDER BY FIND_IN_SET(id, '50') |
0.00048112869262695 |
| (20) |
DESCRIBE `ports` |
0.0024130344390869 |
| (21) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5733))) |
0.00032520294189453 |
