(1) |
connect |
0.00088977813720703 |
(2) |
DESCRIBE `ports` |
0.0025339126586914 |
(3) |
SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'chateauneuf-du-rhone-france') AND (orchid_available = 1) LIMIT 1 |
0.044427871704102 |
(4) |
DESCRIBE `destinations` |
0.0025629997253418 |
(5) |
SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 50))) |
0.00063681602478027 |
(6) |
DESCRIBE `avid_specials` |
0.0016698837280273 |
(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.001741886138916 |
(8) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5733') |
0.00042891502380371 |
(9) |
SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '5733') |
0.0028371810913086 |
(10) |
SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '5733') |
0.0027408599853516 |
(11) |
DESCRIBE `cruises` |
0.0037429332733154 |
(12) |
SELECT `cruises`.* FROM `cruises` WHERE (id IN (63940, 63940)) ORDER BY FIND_IN_SET(id, '63940,63940') |
0.0010740756988525 |
(13) |
DESCRIBE `cruiselines` |
0.0026299953460693 |
(14) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('140')) ORDER BY FIND_IN_SET(id, '140') |
0.00050497055053711 |
(15) |
DESCRIBE `ships` |
0.0035591125488281 |
(16) |
SELECT `ships`.* FROM `ships` WHERE (id IN ('1491')) ORDER BY FIND_IN_SET(id, '1491') |
0.00060391426086426 |
(17) |
DESCRIBE `cruisetypes` |
0.0017490386962891 |
(18) |
DESCRIBE `destinations` |
0.0029840469360352 |
(19) |
SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50')) ORDER BY FIND_IN_SET(id, '50') |
0.0006718635559082 |
(20) |
DESCRIBE `ports` |
0.0023429393768311 |
(21) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5733))) |
0.00051307678222656 |