(1) |
connect |
0.0011861324310303 |
(2) |
DESCRIBE `ports` |
0.0031499862670898 |
(3) |
SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'prince-rupert-bc-canada') AND (orchid_available = 1) LIMIT 1 |
0.017055988311768 |
(4) |
DESCRIBE `destinations` |
0.003525972366333 |
(5) |
SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 2))) |
0.00071287155151367 |
(6) |
DESCRIBE `avid_specials` |
0.0022749900817871 |
(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.0045490264892578 |
(8) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1262') |
0.00066900253295898 |
(9) |
SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '1262') |
0.0031290054321289 |
(10) |
SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '1262') |
0.0018670558929443 |
(11) |
DESCRIBE `cruises` |
0.0052077770233154 |
(12) |
SELECT `cruises`.* FROM `cruises` WHERE (id IN (80707, 80707, 87287, 84493, 81579, 81579, 82900, 82907, 84518, 87290)) ORDER BY FIND_IN_SET(id, '80707,80707,87287,84493,81579,81579,82900,82907,84518,87290') |
0.002418041229248 |
(13) |
DESCRIBE `cruiselines` |
0.0038681030273438 |
(14) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('28', '15', '33', '91', '7', '14', '23', '29', '114')) ORDER BY FIND_IN_SET(id, '28,15,33,91,7,14,23,29,114') |
0.0018680095672607 |
(15) |
DESCRIBE `ships` |
0.0052409172058105 |
(16) |
SELECT `ships`.* FROM `ships` WHERE (id IN ('790', '394', '780', '1282', '341', '796', '1606', '147', '332', '1398', '1749')) ORDER BY FIND_IN_SET(id, '790,394,780,1282,341,796,1606,147,332,1398,1749') |
0.0027530193328857 |
(17) |
DESCRIBE `cruisetypes` |
0.0025780200958252 |
(18) |
DESCRIBE `destinations` |
0.0032780170440674 |
(19) |
SELECT `destinations`.* FROM `destinations` WHERE (id IN ('2')) ORDER BY FIND_IN_SET(id, '2') |
0.00066804885864258 |
(20) |
DESCRIBE `ports` |
0.0028250217437744 |
(21) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1262))) |
0.00065398216247559 |