(1) |
connect |
0.00091695785522461 |
(2) |
DESCRIBE `ports` |
0.002202033996582 |
(3) |
SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'caudebec-france') AND (orchid_available = 1) LIMIT 1 |
0.014072179794312 |
(4) |
DESCRIBE `destinations` |
0.002842903137207 |
(5) |
SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 50))) |
0.00062394142150879 |
(6) |
DESCRIBE `avid_specials` |
0.0018270015716553 |
(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.0020220279693604 |
(8) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1558') |
0.00045895576477051 |
(9) |
SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '1558') |
0.0027740001678467 |
(10) |
SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '1558') |
0.0025539398193359 |
(11) |
DESCRIBE `cruises` |
0.0040428638458252 |
(12) |
SELECT `cruises`.* FROM `cruises` WHERE (id IN (78671, 75812, 76334, 76388, 76391, 65761, 75145, 75144, 75146, 78163)) ORDER BY FIND_IN_SET(id, '78671,75812,76334,76388,76391,65761,75145,75144,75146,78163') |
0.0022799968719482 |
(13) |
DESCRIBE `cruiselines` |
0.0026757717132568 |
(14) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('96', '101', '131', '156', '239', '276', '204', '181', '153', '140')) ORDER BY FIND_IN_SET(id, '96,101,131,156,239,276,204,181,153,140') |
0.0017158985137939 |
(15) |
DESCRIBE `ships` |
0.0038940906524658 |
(16) |
SELECT `ships`.* FROM `ships` WHERE (id IN ('1455', '761', '1156', '1223', '1270', '1650', '559', '1542', '672', '1139', '798', '741', '1157', '804')) ORDER BY FIND_IN_SET(id, '1455,761,1156,1223,1270,1650,559,1542,672,1139,798,741,1157,804') |
0.0019950866699219 |
(17) |
DESCRIBE `cruisetypes` |
0.0017039775848389 |
(18) |
DESCRIBE `destinations` |
0.0026609897613525 |
(19) |
SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50')) ORDER BY FIND_IN_SET(id, '50') |
0.00059795379638672 |
(20) |
DESCRIBE `ports` |
0.0022041797637939 |
(21) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1558))) |
0.0005648136138916 |