(1) |
connect |
0.0010018348693848 |
(2) |
DESCRIBE `ports` |
0.0022561550140381 |
(3) |
SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'puerto-quetzal-guatemala') AND (orchid_available = 1) LIMIT 1 |
0.0024011135101318 |
(4) |
DESCRIBE `destinations` |
0.0028250217437744 |
(5) |
SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 48))) |
0.00061702728271484 |
(6) |
DESCRIBE `avid_specials` |
0.0019161701202393 |
(7) |
SELECT `avid_specials`.* FROM `avid_specials`
LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = '48' 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.0021169185638428 |
(8) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '357') |
0.00052404403686523 |
(9) |
SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '357') |
0.0038299560546875 |
(10) |
SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '357') |
0.0034909248352051 |
(11) |
DESCRIBE `cruises` |
0.00478196144104 |
(12) |
SELECT `cruises`.* FROM `cruises` WHERE (id IN (80962, 59004, 71532, 67616, 80963, 69184, 69680, 71533, 56346, 38690)) ORDER BY FIND_IN_SET(id, '80962,59004,71532,67616,80963,69184,69680,71533,56346,38690') |
0.002007007598877 |
(13) |
DESCRIBE `cruiselines` |
0.0032129287719727 |
(14) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('18', '91', '24', '15', '20', '26', '50', '114', '8', '19', '28', '218', '23', '262', '14', '159')) ORDER BY FIND_IN_SET(id, '18,91,24,15,20,26,50,114,8,19,28,218,23,262,14,159') |
0.0020802021026611 |
(15) |
DESCRIBE `ships` |
0.0043618679046631 |
(16) |
SELECT `ships`.* FROM `ships` WHERE (id IN ('1108', '780', '74', '78', '82', '111', '340', '483', '1319', '123', '394', '674', '790', '1742', '108', '291', '441', '792', '1474', '43', '325', '403', '626', '657', '795', '1073', '1302', '1569', '1676', '66', '93', '389', '692', '796', '1168', '1303')) ORDER BY FIND_IN_SET(id, '1108,780,74,78,82,111,340,483,1319,123,394,674,790,1742,108,291,441,792,1474,43,325,403,626,657,795,1073,1302,1569,1676,66,93,389,692,796,1168,1303') |
0.0045349597930908 |
(17) |
DESCRIBE `cruisetypes` |
0.0018060207366943 |
(18) |
DESCRIBE `destinations` |
0.0021910667419434 |
(19) |
SELECT `destinations`.* FROM `destinations` WHERE (id IN ('48', '40', '37', '38')) ORDER BY FIND_IN_SET(id, '48,40,37,38') |
0.00095820426940918 |
(20) |
DESCRIBE `ports` |
0.0024950504302979 |
(21) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 357))) |
0.00050210952758789 |