(1) |
connect |
0.00074386596679688 |
(2) |
DESCRIBE `ports` |
0.0017859935760498 |
(3) |
SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'cape-town-south-africa') AND (orchid_available = 1) LIMIT 1 |
0.0013539791107178 |
(4) |
DESCRIBE `destinations` |
0.0018999576568604 |
(5) |
SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 52))) |
0.00037693977355957 |
(6) |
DESCRIBE `avid_specials` |
0.0011658668518066 |
(7) |
SELECT `avid_specials`.* FROM `avid_specials`
LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = '52' 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.001072883605957 |
(8) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '66') |
0.00028896331787109 |
(9) |
SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '66') |
0.00177001953125 |
(10) |
SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '66') |
0.0016241073608398 |
(11) |
DESCRIBE `cruises` |
0.0031490325927734 |
(12) |
SELECT `cruises`.* FROM `cruises` WHERE (id IN (72425, 68885, 68886, 68887, 68888, 68892, 68893, 62112, 77420, 77421)) ORDER BY FIND_IN_SET(id, '72425,68885,68886,68887,68888,68892,68893,62112,77420,77421') |
0.0021560192108154 |
(13) |
DESCRIBE `cruiselines` |
0.0022201538085938 |
(14) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('15', '151', '28', '91', '23', '19', '187', '29', '49', '24', '114', '14', '159', '20', '188', '18', '262')) ORDER BY FIND_IN_SET(id, '15,151,28,91,23,19,187,29,49,24,114,14,159,20,188,18,262') |
0.001474142074585 |
(15) |
DESCRIBE `ships` |
0.0035598278045654 |
(16) |
SELECT `ships`.* FROM `ships` WHERE (id IN ('790', '585', '258', '616', '341', '1108', '610', '780', '545', '338', '652', '1106', '1262', '147', '508', '695', '66', '105', '223', '448', '818', '823', '74', '332', '1474')) ORDER BY FIND_IN_SET(id, '790,585,258,616,341,1108,610,780,545,338,652,1106,1262,147,508,695,66,105,223,448,818,823,74,332,1474') |
0.0021018981933594 |
(17) |
DESCRIBE `cruisetypes` |
0.0013020038604736 |
(18) |
DESCRIBE `destinations` |
0.0018260478973389 |
(19) |
SELECT `destinations`.* FROM `destinations` WHERE (id IN ('40', '52', '30', '38', '7', '8', '28')) ORDER BY FIND_IN_SET(id, '40,52,30,38,7,8,28') |
0.00086498260498047 |
(20) |
DESCRIBE `ports` |
0.0014138221740723 |
(21) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 66))) |
0.00039410591125488 |