(1) |
connect |
0.0010068416595459 |
(2) |
DESCRIBE `ports` |
0.0024847984313965 |
(3) |
SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'equator-crossing') AND (orchid_available = 1) LIMIT 1 |
0.027776956558228 |
(4) |
DESCRIBE `destinations` |
0.0027990341186523 |
(5) |
SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 40))) |
0.00072097778320312 |
(6) |
DESCRIBE `avid_specials` |
0.0017499923706055 |
(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.0016679763793945 |
(8) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3606') |
0.0003659725189209 |
(9) |
SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '3606') |
0.0040020942687988 |
(10) |
SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '3606') |
0.0026328563690186 |
(11) |
DESCRIBE `cruises` |
0.0039770603179932 |
(12) |
SELECT `cruises`.* FROM `cruises` WHERE (id IN (72199, 72203, 72426, 72427, 72429, 72436, 72437, 71254, 72206, 72210)) ORDER BY FIND_IN_SET(id, '72199,72203,72426,72427,72429,72436,72437,71254,72206,72210') |
0.0037059783935547 |
(13) |
DESCRIBE `cruiselines` |
0.0027480125427246 |
(14) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('18', '28', '114')) ORDER BY FIND_IN_SET(id, '18,28,114') |
0.0010340213775635 |
(15) |
DESCRIBE `ships` |
0.0039999485015869 |
(16) |
SELECT `ships`.* FROM `ships` WHERE (id IN ('884', '75', '790', '547', '84', '1302', '74', '657', '796')) ORDER BY FIND_IN_SET(id, '884,75,790,547,84,1302,74,657,796') |
0.0014951229095459 |
(17) |
DESCRIBE `cruisetypes` |
0.0018088817596436 |
(18) |
DESCRIBE `destinations` |
0.0027589797973633 |
(19) |
SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '37', '40', '35', '38', '48', '52')) ORDER BY FIND_IN_SET(id, '43,37,40,35,38,48,52') |
0.001384973526001 |
(20) |
DESCRIBE `ports` |
0.0023059844970703 |
(21) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3606))) |
0.00048208236694336 |