(1) |
connect |
0.0010430812835693 |
(2) |
DESCRIBE `ports` |
0.0029721260070801 |
(3) |
SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'hakodate-japan') AND (orchid_available = 1) LIMIT 1 |
0.013789176940918 |
(4) |
DESCRIBE `destinations` |
0.0029890537261963 |
(5) |
SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 35))) |
0.00058293342590332 |
(6) |
DESCRIBE `avid_specials` |
0.0018651485443115 |
(7) |
SELECT `avid_specials`.* FROM `avid_specials`
LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = '35' 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.0031671524047852 |
(8) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1308') |
0.00066089630126953 |
(9) |
SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '1308') |
0.0048291683197021 |
(10) |
SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '1308') |
0.0030310153961182 |
(11) |
DESCRIBE `cruises` |
0.003978967666626 |
(12) |
SELECT `cruises`.* FROM `cruises` WHERE (id IN (75258, 75266, 75267, 75268, 75269, 75270, 79326, 79327, 79328, 79615)) ORDER BY FIND_IN_SET(id, '75258,75266,75267,75268,75269,75270,79326,79327,79328,79615') |
0.0023231506347656 |
(13) |
DESCRIBE `cruiselines` |
0.0038681030273438 |
(14) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('23', '15', '91', '8', '29', '18', '33', '20', '24', '14', '26', '151', '159')) ORDER BY FIND_IN_SET(id, '23,15,91,8,29,18,33,20,24,14,26,151,159') |
0.002251148223877 |
(15) |
DESCRIBE `ships` |
0.003993034362793 |
(16) |
SELECT `ships`.* FROM `ships` WHERE (id IN ('780', '349', '1108', '45', '1398', '105', '1282', '448', '547', '1168', '1749', '394', '401', '287', '406', '1672', '111', '695', '717', '776')) ORDER BY FIND_IN_SET(id, '780,349,1108,45,1398,105,1282,448,547,1168,1749,394,401,287,406,1672,111,695,717,776') |
0.0023579597473145 |
(17) |
DESCRIBE `cruisetypes` |
0.001884937286377 |
(18) |
DESCRIBE `destinations` |
0.0035068988800049 |
(19) |
SELECT `destinations`.* FROM `destinations` WHERE (id IN ('35', '40', '2', '34')) ORDER BY FIND_IN_SET(id, '35,40,2,34') |
0.00091099739074707 |
(20) |
DESCRIBE `ports` |
0.0021460056304932 |
(21) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1308))) |
0.00047802925109863 |