(1) |
connect |
0.0007939338684082 |
(2) |
DESCRIBE `ports` |
0.002424955368042 |
(3) |
SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'dunedin-port-chalmers-new-zealand') AND (orchid_available = 1) LIMIT 1 |
0.0047950744628906 |
(4) |
DESCRIBE `destinations` |
0.0026259422302246 |
(5) |
SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 43))) |
0.00066304206848145 |
(6) |
DESCRIBE `avid_specials` |
0.0016610622406006 |
(7) |
SELECT `avid_specials`.* FROM `avid_specials`
LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = '43' 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.0017879009246826 |
(8) |
SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') |
0.00052809715270996 |
(9) |
SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '491') |
0.0021371841430664 |
(10) |
SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '491') |
0.0018208026885986 |
(11) |
DESCRIBE `cruises` |
0.005047082901001 |
(12) |
SELECT `cruises`.* FROM `cruises` WHERE (id IN (69899, 70760, 70761, 70956, 67334, 69311, 71200, 69301, 69884, 66817)) ORDER BY FIND_IN_SET(id, '69899,70760,70761,70956,67334,69311,71200,69301,69884,66817') |
0.0019359588623047 |
(13) |
DESCRIBE `cruiselines` |
0.0031530857086182 |
(14) |
SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('23', '18', '8', '26', '15', '20', '114', '264', '28', '262', '29', '14', '24', '151', '91', '159', '4', '36', '37', '105')) ORDER BY FIND_IN_SET(id, '23,18,8,26,15,20,114,264,28,262,29,14,24,151,91,159,4,36,37,105') |
0.0022718906402588 |
(15) |
DESCRIBE `ships` |
0.0041279792785645 |
(16) |
SELECT `ships`.* FROM `ships` WHERE (id IN ('547', '683', '780', '253', '485', '678', '1330', '1539', '1767', '1325', '287', '1409', '1492', '75', '451', '776', '341', '717', '394', '1398', '332', '616', '1168', '1474', '1672', '1749', '4', '66', '108', '479', '506', '111', '338', '573', '692', '695', '997', '1758')) ORDER BY FIND_IN_SET(id, '547,683,780,253,485,678,1330,1539,1767,1325,287,1409,1492,75,451,776,341,717,394,1398,332,616,1168,1474,1672,1749,4,66,108,479,506,111,338,573,692,695,997,1758') |
0.0047438144683838 |
(17) |
DESCRIBE `cruisetypes` |
0.0019707679748535 |
(18) |
DESCRIBE `destinations` |
0.0068860054016113 |
(19) |
SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '40', '8', '7')) ORDER BY FIND_IN_SET(id, '43,40,8,7') |
0.0010960102081299 |
(20) |
DESCRIBE `ports` |
0.0023407936096191 |
(21) |
SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) |
0.00054407119750977 |