(1) |
connect |
0.00091695785522461 |
(2) |
DESCRIBE `ports` |
0.0024149417877197 |
(3) |
SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'inside-passage-alaska') AND (orchid_available = 1) LIMIT 1 |
0.0046839714050293 |
(4) |
DESCRIBE `destinations` |
0.0031020641326904 |
(5) |
SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 2))) |
0.0006110668182373 |
(6) |
DESCRIBE `avid_specials` |
0.0018751621246338 |
(7) |
SELECT `avid_specials`.* FROM `avid_specials`
LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = '2' 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.0018308162689209 |
(8) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') |
0.0005800724029541 |
(9) |
SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '40') |
0.0027849674224854 |
(10) |
SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '40') |
0.003209114074707 |
(11) |
DESCRIBE `cruises` |
0.0079009532928467 |
(12) |
SELECT `cruises`.* FROM `cruises` WHERE (id IN (72427, 72439, 71619, 78123, 52637, 71101, 71102, 71620, 72447, 69189)) ORDER BY FIND_IN_SET(id, '72427,72439,71619,78123,52637,71101,71102,71620,72447,69189') |
0.0024139881134033 |
(13) |
DESCRIBE `cruiselines` |
0.0035901069641113 |
(14) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('8', '18', '26', '20', '24', '91', '15', '29', '262', '33', '14', '103', '23', '28', '110', '159')) ORDER BY FIND_IN_SET(id, '8,18,26,20,24,91,15,29,262,33,14,103,23,28,110,159') |
0.002277135848999 |
(15) |
DESCRIBE `ships` |
0.0048868656158447 |
(16) |
SELECT `ships`.* FROM `ships` WHERE (id IN ('485', '776', '111', '683', '45', '1330', '287', '780', '1398', '394', '401', '1492', '792', '547', '82', '1266', '389', '66', '1108', '1486', '75', '105', '1168', '790', '695', '1619')) ORDER BY FIND_IN_SET(id, '485,776,111,683,45,1330,287,780,1398,394,401,1492,792,547,82,1266,389,66,1108,1486,75,105,1168,790,695,1619') |
0.0045080184936523 |
(17) |
DESCRIBE `cruisetypes` |
0.0020151138305664 |
(18) |
DESCRIBE `destinations` |
0.0029199123382568 |
(19) |
SELECT `destinations`.* FROM `destinations` WHERE (id IN ('2', '40', '35', '34', '43', '48')) ORDER BY FIND_IN_SET(id, '2,40,35,34,43,48') |
0.0012600421905518 |
(20) |
DESCRIBE `ports` |
0.0024528503417969 |
(21) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) |
0.00052094459533691 |